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%%

 

 

  • 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.

 

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

 

To report this post you need to login first.

2 Comments

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

Leave a Reply