Skip to Content

Purpose of this blog:

This blog explains how to create Fiori Multidimensional Reporting using custom Analytic Query or BW Query as a source in S/4HANA on-premise.

It is based on the following SAP Note.

2623507 – Fiori Multidimensional Reporting in S/4 HANA onPremise using custom analytical queries

 

Highlights:

  • A custom Fiori Tile is created with Launchpad Designer and predefined web template is used in the tile.
    • In S/4HANA Public Cloud, it is possible to create Multidimensional Reporting Application in View Browser using “Create Application” button, but it is not available in S/4HANA on-premise.
  • Analytic Query of CDS View and BW Query including the query for BPC for S/4HANA can be used as a source of Multidimensional Reporting Application. In CDS View, the annotation “@Analytics.query: true” is used to set it as Analytic Query.
    • Analytic Query doesn’t have to be published as OData service to be used in Fiori Multidimensional Reporting Application as Transient Provider communication is used, not normal OData Service.
  • There are two types of web application for Multidimensional Reporting; UI5 based application (“Design Studio Data Grid”) and Web Dynpro based application (“Web Dynpro Data Grid”). “Design Studio Data Grid” is available as of SAPUI5 1.48 (S/4 HANA on Premise 1709) and used as default tool for Multidimensional Reporting Application since S/4HANA 1709. Web Dynpro based application is main solution for Multidimensional Reporting Application in S/4HANA =< 1610. In addition, it is used as the alternative to the SAPUI5 based reporting application even in/after S/4HANA1709, i.e. to fulfill the SAP Accessibility Standard and to offer in addition to the Export to Excel functionality an Export to PDF functionality. It could help avoiding OutOfMemory for large result set. (See SAP Note 2557541)
  • It is possible to set the target of “Jump to” in Design Studio Data Grid.

 

How to create Multidimensional Reporting Application using “Design Studio Data Grid”

Prerequisite: Fiori Catalog to save the tile has been created beforehand and which is included in the Role to which the user is assigned in Frontend Server (FES).

With Launchpad Designer (Transaction: /UI2/FLPD_CUST), Tile and Target Mapping has to be created for Multidimensional Reporting Application.

(See the blog “SAP Fiori Launchpad – Simplification of Target Mapping Configuration without LPD_CUST” in detail.)

 

Select the catalog in which the created tile is stored, and create custom tile for Multidimensional Reporting Application as below.

 

Name Value
Title <Title of the tile>
Icon <Select the Icon>
Use semantic object navigation Checked
Semantic Object <Sematic object>
Action <Action>
  • Semantic Object and Action can be selected from predefined ones or type directly.

 

The tile is created in the catalog.

Next, create Target mapping and set Intent/Target/General and Parameters as below.

 

Intent/Target/General:

Name Value
Semantic Object <Set the same Semantic Object used in the title>
Action <Set the same Action used in the title>
Application Type SAPUI5 Fiori App
Title <Title of the target mapping>
URL /sap/bc/ui5_ui5/sap/FIN_DS_ANALYZE
ID fin.acc.query.analyze
Device type Check Desktop only

 

Parameters:

Name Detail Example of Default value
XQUERY

<Query name; For Analytic Query of CDS View, 2C<SQL View name of the CDS View> is used.

For BW Query, technical name of BW Query is used as it is>

2CCFITRIALBALQ0001

(for the CDS View C_TRIALBALANCE)

XSYSTEM <SAP System Alias (to the backend system), e.g. S4FIN; can be maintained via IMG (Manage SAP System Aliases) or via the transaction SM30 (View /IWFND/V_DFSYAL)> LOCAL
XSEMANTIC_OBJECTS (Optional) Semantic Object name of the target of “Jump to” GLAccount
XDATALIMIT_ROWS (Optional) The limit of the row to be displayed in the result set. “-1” should be set for removing the limit.

10000

(default)

XDATALIMIT_COLS (Optional) The limit of the column to be displayed in the result set. “-1” should be set for removing the limit.

50

(default)

XVISIBLEPROMPTS (Optional) Comma-Separated list of dimensions for which variables should initially be shown

“” (Show all)

(default)

<Field name of the source query> Result set can be filtered by using the fields of the query as a parameters, e.g. When parameter name is set to “Ledger” and “0L” is set as default value, the result set is filtered with “0L”. * %%UserDefault.Ledger%%

 

  • You can set the parameter and value directly in the URL. For example, the query 2CCFIPROFCTRQ2701 is displayed by adding “?XQUERY=2CCFIPROFCTRQ2701” after the URL of Analysis launched from Fiori Query Browser like “https://<Server>:<Port>/sap/bc/ui5_ui5/ui2/ushell/shells/abap/FioriLaunchpad.html?sap-client=100&sap-language=EN#AnalyticQuery-analyze?XQUERY=2CCFIPROFCTRQ2701”.

 

 

  • When using <field name of the source query> in parameter to filter result set, User Default Value can be uesd by using “%%UserDefault.<parameterName>%%” or “%%UserDefault.extended.<parameterName>%%”.

 

 

The target mapping is created in the catalog.

The best way to understand how to create the tile is to check the definition in the predefined app, e.g. “Trial Balance” (F0996A) in Fiori Catalog “SAP_SFIN_BC_GL_REPORTING”.

 

Result:

The app can be assigned to My Home Group in Fiori Launchpad and can be launched.

 

Prompt screen is displayed.

Result:

BW Query can be set as the data source of the Multidimensional Reporting Application.

The Tile in Launchpad Designer:

Target mapping:

Result:

For Design Studio related errors, you should open messages on the component BI-RA-AD-EA.

 

How to create Multidimensional Reporting using “Web Dynpro Data Grid”

For creating Web Dynpro Data Grid based Multidimensional Reporting, Web Dynpro application FPM_BICS_OVP is used and Tile and Target Mapping has to be created like the tile for Design Studio Data Grid based application.

 

 

 

Tile:

Name Value
Title <Title of the tile>
Icon <Select the Icon>
Use semantic object navigation Checked
Semantic Object <Sematic object>
Action <Action>
  • Semantic Object and Action can be selected from predefined ones or type directly.

 

 

 

Target Mapping:

Intent/Target/General:

Name Value
Semantic Object <Set the same Semantic Object used in the title>
Action <Set the same Action used in the title>
Application Type Web Dynpro
Title <Title of the target mapping>
Application FPM_BICS_OVP
Configuration FPM_BICS_OVP
System Alias <SAP System Alias (to the backend system), e.g. S4FIN; can be maintained via IMG (Manage SAP System Aliases) or via the transaction SM30 (View /IWFND/V_DFSYAL)>
Device type Check Desktop only

 

Parameters:

Name Detail Example of Default value
bsa_query

<Query name; For Analytic Query of CDS View, 2C<SQL View name of the CDS View> is used.

For BW Query, Technical name of BW Query is used as it is>

2CCFITRIALBALQ0001

(for the CDS View C_TRIALBALANCE)

sap-ui-tech-hint “WDA” (Constant value) WDA
sap-ushell-next-navmode “explace” (Constant value) explace
<field name of the source query> Result set can be filtered by using field name as a parameter, e.g. When parameter name is set to “Ledger” and set “0L” as default value, the result set is filtered with “0L”. * %%UserDefault.Ledger%%
BSA_VARIABLE_XXX

Parameters can also be passed to variable of BW Query by the URL parameters left (XXX is the technical name of a BW variable)

 

BSA_VARIABLE_0CALMONTH=201806

(single value)

BSA_VARIABLE_0CALMONTH =201806 ; 201807

(multiple single values)

BSA_VARIABLE_0CALMONTH =201806 – 201807 (intervals)

 

 

The predefined app can be used to understand how to create the tile, e.g. “Trial Balance (Accessible)” (F0996) in Fiori Catalog “SAP_SFIN_BC_GL_REPORTING”.

 

Result:

Prompt screen is in upper screen.

The result set is in lower screen.

For Web Dynpro Data Grid related errors, you should open messages on the component BW-RUI-FPM.

 

This blog have important message: Transient Provider connection is the second important communication way other than standard OData communication in Fiori architecture. In addition, it is also used for advanced scenarios like SAC or BusinessObjects. This communication has to be used as it has so strong analytics functionalities (internally Analytic engine used in BW is reused). Most analytics experts has already known it.

Don’t miss it!

 

Enjoy Fiori Multidimensional Reporting and Analytics scenario in S/4HANA!

 

To report this post you need to login first.

12 Comments

You must be Logged on to comment or reply to a post.

  1. Jerry Kuo

    Thanks for sharing! We have developed two types of multi-dimensional reports successfully.

     

    But, can we adjust the measure’s order in the reports ?

    For example, I want to pull Net Sales column to the STD Cost column’s right side.

    I just know the way to adjust the measure’s order in the datasource.

    Thanks for your help!

     

    (0) 
  2. Mihir Kiri

    Hi Masa,

    This blog was very helpful to us. Thank you very much for this blog. So what we understand is that we can have 1 tile for each BEx query. Is it possible to use same tile for multiple BEx queries just like it is in Query Browser for Analytical CDS views ?

    Regards,

    Mihir Kiri

     

    (0) 
    1. Masaaki Arai Post author

      Hello Kiri,

      No.

      it is possible to display the BW query technically by adding ?XQUERY=<Query name> in the URL. But should not be the operation for Business Users.

      It could be the development request.

      Thanks, Masa

      (0) 
  3. Mihir Kiri

    Hello Masa,

     

    We are using SAP CAR for our Retail client. There are various VDMs delivered by SAP in form of calculation views in SAP CAR. We are not able find those VDMs in Query Designer. Is it possible to expose those VDMs in form of calc. views to Query Designer ?

    Regards,

    Mihir Kiri

    (0) 
    1. Masaaki Arai Post author

      Hello Kiri,

      Thanks for inspiring question.

      I dont know much about CAR, but I think it could be the solution to create BW Query on top of HANA Calc View. It is possible to create BW Query on top of HANA View as well as CDS View. It should be able to be consumed in Fiori Design Studio just the same as Analytic Query of CDS View or BW Query.

      If you want to create CDS View, not BW Query, you can create ABAP External View from the HANA Calc View and consume it in CDS View.

      Of course as prerequisite, it is necessary to set up Fiori Design Studio beforehand.

      https://launchpad.support.sap.com/#/notes/2356997

      As much as I know, VDM is created with HANA Calc View, not CDS View in Hybris as well.

      Thanks, Masa

       

       

      (0) 
    2. Masaaki Arai Post author

      Hi Kiri,

      In addition, below are my ideas, but are not verified.

      • For Fiori Element app, HANA Calc View has to be exposed as Odata Service either using XS Engine or creating BW Query and exposing it as OData Service. Then UI Annotations might have to be added with Annotation Modeler of Web IDE.
      • For Fiori KPI Tile, Smart Business Cockpit for SoH (not S/4HANA) could be used (but it has to be reviewed, I haven’t tested). OData Service exposed from BW Query can be the source of S/4HANA Version of Smart Business Cockpit (KPI Modeler), but it is not possible as Evaluation can not be created if S4FND or S4CORE is not installed in backend system.

      Sorry if those ideas dont work.

      Thanks, Masa

      (0) 
  4. Ahmed Riyaz

    Hello @Masaaki Arai,

    This post is an excellent contribution to the community. Thank you very much.

    We have implemented your steps and it is working very well. However I want to increase the threshold for LOV values in the prompt screen of the design studio template which get invoked. Is it possible to increase that coz currently if LOV for the prompt variable coming from BEx is more that 10 then I just get a blank window with search bar when I take input help for a prompt as my LOV values are more than 10.

     

    (0) 

Leave a Reply