Skip to Content
Technical Articles
Author's profile photo Masaaki Arai

How to create custom Fiori Multidimensional Reporting Application in S/4HANA on-premise

5/3/2022:

3112220 – FAQ: Web Dynpro Apps and Design Studio Apps in SAP S/4HANA and SAP S/4HANA Cloud

 

23/10/2021:

3081996 – Deprecation of SAP Design Studio Apps in SAP S/4HANA 2021

Most SAP Design Studio apps are no longer supported and will be deleted from the system as of SAP S/4HANA 2022. This includes all Finance apps based on the Design Studio technology. The apps are no longer available by default on the SAP Fiori launchpad. However, you can still locate them using the app finder until they’re deleted. In the system, you can easily identify the deprecated apps by the word Deprecated on the respective tiles.

 

Updated:

13/04/2021: Updates on WEB Dynpro Grid

 

15/12/2020: Announcement from SAP PM team.

WEB Dynpro as Default app for Drill-down Reports

With S/4HANA2020, the WEB Dynpro Data Grid will be the default reporting tool for all drill-down reports. The benefits are as follows:

  • Available on Desktop and Tablet devices
  • Adheres to SAP’s Accessibility standards
  • Includes a PDF format download
  • Offers Exception Reporting Option to define customer-specific field name mappings using BAdI
  • The Filters are shown in the header area of a Data Grid App and they offer a huge flexibility (no separate popup as we have it in Design Studio)
  • The Navigation Panel can be hidden (more space on the screen

Some new may no longer be available by default on the SAP Fiori Launchpad, however will be accessible via the app finder.

 

 

 

4/7/2019: Add URL Parameter XPROMPT (Tile), XTITLE, XDISPLAY, XCHART_TYPE (Target Mapping).

 

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 Manage Launchpad Apps or 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)
    • See the blog about the difference between Design Studio grid and WD Grid in detail.
  • 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 Manage Launchpad Apps or 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>
Parameters “XPROMPT=X”  *If you want to force Prompt screen
  • Semantic Object and Action can be selected from predefined ones or type directly.
  • * If “XPROMPT=X” is set, prompt screen appears even when all prompt values are set. If you want to skip prompt screen when all prompt values are set, set nothing in “Parameters”. For technical reason, only this parameter has to be set in “Parameters” field in the tile, not the target mapping.

 

 

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) filtering Semantic Object name of the target listed in “Jump to” menu. “GLAccount”
XDATALIMIT_ROWS (Optional) The limit of the row to be displayed in the result set. “-1” should be set for removing the limit. Default value is 10000 “20000”
XDATALIMIT_COLS (Optional) The limit of the column to be displayed in the result set. “-1” should be set for removing the limit. Default value is 50. “50”
XVISIBLEPROMPTS (Optional) Comma-Separated list of dimensions for which variables should initially be shown. All variables are displayed by default “Ledger”
XTITLE (Optional) Name of the Title of the Application. (>= 1.58). Query Name is displayed by default. “Trial Balance”
XDISPLAY (Optional) The initial Display Mode. Following values are supported

  • CHART
    starts the application and displays only the Chart
  • TABLE
    starts the application and displays only the Table (Default setting)
  • CHART_TABLE
    starts the application and displays both Chart and Table. The Chart is displayed above the Table.
CHART
XCHART_TYPE (Optional) The ChartType to be displayed. See the following table (*) about the supported chart type and parameter values. INFO_COLUMN is set by default. INFO_BAR
<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 you create a query with Custom Analytical Queries, please find the query name as below.
    • Push “Information…” in setting icon.
    • and you can find the Query Name.
  • XDATALIMIT_ROWS/ XDATALIMIT_COLS: See SAP Note 2557541 – Configuration of amount of data to retrieve from server
  • XCHART_TYPE: Following values are supported
Chart type Old New
Area AREA INFO_AREA
Bar HORIZONTAL_BAR INFO_BAR
Bar – Stacked HORIZONTAL_STACKED_BAR IN INFO_STACKED_BAR
Column VERTICAL_BAR INFO_COLUMN
Column – Stacked VERTICAL_STACKED_BAR INFO_STACKED_COLUMN
Horizontal Area HORIZONTAL_AREA INFO_HORIZONTAL_AREA
Line LINE INFO_LINE
Pie PIE INFO_PIE
    • Example of the setting of XDISPLAY and XCHART_TYPE:
      • &XDISPLAY=CHART&XCHART_TYPE=PIE
  • 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_XX

Parameters can also be passed to variable of BW Query by the URL parameters left (XX 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!

 

Assigned Tags

      94 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Daniel Hernandez
      Daniel Hernandez

      Very comprehensive! Much needed! Thanks!

      Author's profile photo Jocelyn Dart
      Jocelyn Dart

      Very timely Masa! We used the BW option at a customer this week and it worked perfectly. Thanks!

      Author's profile photo Jerry Kuo
      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!

       

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Jerry,

      it is necessary to change the position in the Query. It is not possible in Fiori Design Studio.

      Thanks, Masa

      Author's profile photo Jerry Kuo
      Jerry Kuo

      OK, got it. Many thanks!

      Author's profile photo Mihir Kiri
      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

       

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog 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

      Author's profile photo Mihir Kiri
      Mihir Kiri

      Thanks Masa for the confirmation. I really appreciate your prompt response.

      Author's profile photo Akshay Khatri
      Akshay Khatri

      Hi Masa,

       

      Do we have any way of hiding the ?XQUERY=<Query name> parameter in the fiori URL? Or is it possible t mask the same.

       

      Regards,

      Akshay

      Author's profile photo Gagan Bakhshi
      Gagan Bakhshi

      Hi,

      You can use it is one way, define different target mappings for each query, and configure them as Jump to options within the same tile. That should solve your requirement.

       

      Thanks

      Author's profile photo Mihir Kiri
      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

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog 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

       

       

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog 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

      Author's profile photo Ahmed Riyaz
      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.

       

      Author's profile photo Ahmed Riyaz
      Ahmed Riyaz

      Hello @Masaaki Arai,

      Just a gentle followup, any clue on how to increase the threshold for LOV values in default design studio template which is invoked ? I keenly await your feedback. Meanwhile thanking you in anticipation.

       

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Ahmed,

      Sorry, I cannot understand. in my app, >10 values can be selected using scroll bar, It is SAP UI 1.52.

      Thanks, Masa

       

      Author's profile photo Ahmed Riyaz
      Ahmed Riyaz

      Hello Masa,

      Thank you for your reply. Any method to increase the threshold in LOV in the prompt window ?

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Ahmed,

      A developer answered maximum 1000 values in the dialog are displayed. it is strange why only 10 values are displayed.

      Thanks, Masa

      Author's profile photo Ahmed Riyaz
      Ahmed Riyaz

      Hi Masa,

      I really appreciate your prompt response.

      Can we increase to more than 1000. I have more than 1000 prompt LOV values for my Plant which is in selection.

      Author's profile photo Ahmed Riyaz
      Ahmed Riyaz

      Hello @Masaaki Arai,

      Any method to increase the LOV limit ?

       

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Ahmad,

      Below is the answer from a developer.

      No, this was done on purpose due to performance and memory to make sure the results are revealed without timeout due to too many records being transferred over the line.

      Thanks, Masa

      Author's profile photo Ahmed Riyaz
      Ahmed Riyaz

      Hello @Masaaki Arai,

      We had raised a message to SAP and they too confirmed that the LOV list cannot exceed 1000. Same has been specified in SAP note 2701463. Additionally note also mentions to update to (at least) version 1.52.21 of UI5-on-ABAP. Otherwise text search on prompt help does not work as expected.

      This is just FYI in case you are facing issues with text search.

      Author's profile photo qingsong yang
      qingsong yang

      Hello Masaki,

      This blog was very helpful to me. Thank you very much for this blog. I did it according to your blog. I set the XDATALIMIT_ROWS = 20000, but I found that the maximum number of items to display is still only 10000.Can you tell me why?Thank you .

      Author's profile photo Baljinder Sidhu
      Baljinder Sidhu

      Hi Masaaki Arai ,

       

      Great blog, just in need of some advice please. I am doing something very similar however wanting to map a custom Fiori tile to a custom Embedded BW query (on SFIN_M01), the reason for this is that we have added some new variables/ sections such as calendar year and Profit Center Node Hierarchy. Now the standard PC Plan/ Actual tile are reference tiles i believe for Web Dynpro App, am i therefore best to create a new tile via KPI modelling tools and consume the query via OData although it is on a Transient provider? I have tried creating the tile and adding the XQUERY technical name however this does not seem to work, must the tile go in a custom catalog? Any advice is greatly appreciated. We are working with S/4 HANA  on prem 1610 therefore not sure if all the options are available to us.

       

      Regards,

      Bal.

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Bal,

      it sounds strange. I believe you can create custom Multidimensional Reporting app by setting BW Query name in the parameter of XQUERY in the target mapping, which is described also in this blog.

      KPI Modeling tools is not relevant, as multidimensional reporting app uses BW Query connection, not normal Odata service of the CDS View.

      Thanks, Masa

       

      Author's profile photo Baljinder Sidhu
      Baljinder Sidhu

      Thanks Masa, i think there was an issue in our setup, however now i have a Multidimensional report launching from a custom Embedded query, which is great!!

       

      Just a quick thought, i have added a custom field to ACDOCA and then re-generated the Transient Providers under SFIN_M01 to include it, however what if i wanted this field to be a hierarchy do i need to maintain that in S/4 or is it some how generated by the BW Transient providers?

       

      Thanks again for all your advice!!

       

      Bal.

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Bal,

      Sorry, which field do you add concretely?

      In the BW content for BPC for S/4HANA, the InfoObject using Hierarchy has been predefined. But if you want to use Custom hierarchy for Custom field, I think manual steps is needed to create InfoObject with hierarchy in which hierarchy data is read virtually to the source table in realtime. Sorry if may assumption is not correct.

      THanks, Masa

       

      Author's profile photo Baljinder Sidhu
      Baljinder Sidhu

      Hi Masa,

       

      Correct it is a custom field we have added to ACDOCA, however for reporting it would be useful to have this InfoObject as a Hierarchy. I have already added it to the BW Transient providers using the Model Adapt tool, just not sure how to create the Hierarchy, i am guessing this will be some S/4 config similar to Profit Centers etc, but i do not see how this is then available in the Embedded BW as a hierarchy, Will keep looking.

       

      Thanks,

      Bal.

      Author's profile photo Ned Falk
      Ned Falk

      Jump Targets for analytical report

       

      It seems like some delivered fiori apps allow for jumping to the master data or other objects from  lists ( using  SAP UI5)   THe Multi Dim report also allows it via ... But where  can you enable jump targets for an Analytical report or KPI or ApF

      Thanks

      Author's profile photo Ned Falk
      Ned Falk

      Hello@Masaaki Arai,

      I hope someone can help on these two questions:  basically I want to understand how jumps are enabled and how to limit them and apply them to other things like the Analytic list page in the fiori report designer.

      1. using XSEMANTIC_OBJECTS you can jump to other targets. for example Customer

        a. But what if you want to limit the options to jump to only some targets related to customer?

        b. What if you have a custom app you want them to jump to passing the customer field value

        c. In the report designer (ALP) ( analytical list reports/page), you need to publish a tile.  in the process you identify a semantic object and action to trigger the  execution of ALP .  Is it possible to have jumps here if you specify the semantic object as an existing one like Customer, and the action to be a new value like “displayALP.   Will that enable the jumps connected to customer, but again, how do you limit the available jumps

      2. Also if you are using a custom CDS view and you have custom field called "XXXCustomer"  what anotation would you do to tell the system that the value of this should be considered to be "customer" to allow it to pass to jump targets as customer..
      Author's profile photo Gagan Bakhshi
      Gagan Bakhshi

      Hi,

      Can you also clarify if you can define a jump to like facility on the columns in the report, i.e if GL Account value is clicked and it triggers a jump, the jump to is working fine with the button as you shared.

      (Asking in terms of Design Studio grid)

      Can we replicate the behaviour on cell level in the report, SAP actually mentions that something like that can be done using context lists.

      Thank you

      Author's profile photo Martin Rimmele
      Martin Rimmele

      Hi Masaaki Arai

      we are not able to set the Parameters XDISPLAY an XCHART_TYPE for our Design Studio Apps.

      Adding the two parameters in the Target-Mapping will not affect our Design Studio apps.

      I saw that these parameters were added via blog update. Do these parameters only work from a certain S/4HANA release or FPS? we currently have S/4HANA 1709 FPS1.
      Or do you need a certain minimum requirement of the frontend server for this?

       

      kind regards

      Martin

       

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Rimmete,

      Unfortunately, yes.

      I found the following parameter don’t work on UI 1.48 but work on 1.60.

      • XTITLE
      • XDISPLAY
      • XCHART_TYPE

      Thanks for your understanding,

      Masa

       

       

      Author's profile photo Martin Rimmele
      Martin Rimmele

      Hi Masaaki Arai

      thank very much for your response. The Blog is very helpful!

       

      kind regards

      Martin

       

      Author's profile photo Shiva Kona
      Shiva Kona

      Hi Masaaki Arai,

       

      Thanks for the useful blog, I have a query can you please help ?

      I have created an Analytical fiori application with the back end implementation as SQL view of a CDS 2C<SQL view name> of  my CDS view.

      I have done this by adding the sql name in the X-Query of the URL Parameters in the target mapping of the tile in Launchpad configuration.

      Now i have created the DCL for the CDS view and the data when i execute the cds is getting filtered by DCL but the data in the fiori app is not getting filtered.

      Seems the SQL View is not applying the DCL while rendering result on Analytical application.

      Now how can i apply the DCL on the Analytical application which is using SQL view of a cds ?

      or how can i achieve this ?

       

      Regards,

      Shiva

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Shiva,

      The authorization trace with Tcd ST01 would help finding the authorization and values needed.

      BTW, "SQL View" of  2C<SQL view name> is not SQL View itself, only name issue: SQL name is used to express analytical query name. physically is is analytic query, not SQL view.

      Thanks, Masa

      Author's profile photo Shiva Kona
      Shiva Kona

      Thanks for the reply Masaaki,

      If it is physically analytic query, then how to apply classic authorization concept here.

      I have authorization object and values to be applied  but i want them to be applied on analytic query.

      I mean my analytic query should give me values only after filtering by authorization object.

      Regards,

      Shiva

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Shiva,

      DCL should be create for authorization of CDS View in which authorization object has to be set. you can you the standard auth object in it. Standard DCL code should help your understanding. pls run tcd SACM.

      Thanks, Masa

      Author's profile photo Shiva Kona
      Shiva Kona

      Thanks for the reply Masaaki,

      Exactly this is what i have done but DCL is being applied on CDS view but not on SQL view, Since my Analytic query is based on SQL view it is not applying DCL.

      I want that DCL to apply on my Analytic query or SQL view ?

      How to do this ?

      Thanks

      Shiva

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Shiva,

      Analytic Query running on RSRT is NOT SQL View, although the name is 2C<SQL VIew name>.

      Strange... DCL should work for analytic query. you can try running with RSRT.

      Thanks, Masa

      Author's profile photo Vadim Zaripov
      Vadim Zaripov

      Hi Masaaki!

       

      Do you know if there's a way to trigger certain public saved view in the target mapping?

       

      Like in the above example - I want tile to trigger the second view by default for all the users. Is it possible?

       

      Thanks.

      Author's profile photo u k
      u k

      Hello Masa,

      Great post and Thanks for sharing the info. I have same question as Ned Falk - Passing the parameters to Jump to?

      For Example: If I am showing list Sales Orders in my Open Sales Multidimensional app, and I want the User to use Jump to VA03 for a specific Sales Order, to see the Sales Order document flow - How can we do this without re-entering the Sales Order? 

      Thanks, Ukk

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Ukk,

      Creat WebGUI tile as below. the point is parameter: SalesOrder / VBAK-VBELN.

       

      you can find tech name of the field, in the tech info of the corresponding SAPGUI screen.

      Select the field and push F1, and select technical information.

      Hope it helps.

      Thanks, Masa

       

      Author's profile photo Juwin Pallipat Thomas
      Juwin Pallipat Thomas

      Hi Masa,

      How to configure these "Jump To" options? I created a custom Query view for I_GLAccountLineItemCube, and automatically all the jump targets from the original cube start appearing on my custom query. But, how do I activate this functionality on a completely custom view & query? I read and tried these options, but they don't seem to work on the Fiori App AnalyticQuery-analyze: https://blogs.sap.com/2018/05/15/rri-from-abap-cds-analytical-query-to-fiori-application/ https://blogs.sap.com/2018/09/03/report-to-report-interface-rri/

      Right Click of a Column:

      Jump To Dropdown.

       

      Thanks,

      Juwin

       

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Thomas,

      pls activate the target Fiori app and set XSEMANTIC_OBJECTS in the target mapping of the tile for FDS app.

      the linted blog is not about Fiori link called Intent Based Navigation. it is tradititional BW way (so, it should work for e.g. Analysis Office).

      IBN:

      https://help.sap.com/doc/saphelp_nw751abap/7.51.0/de-DE/74/5586a3468640d48b84ffe0e28fe473/frameset.htm

      Regards, Masa

      Author's profile photo Ned Falk
      Ned Falk

      Hi @masaaki.arai,

      More issues..  I have been trying to tell our CDS Dev team not to rename the technical names of SAP delivered fields.. But so far I have not won that  battle.. I  have just found 1 best practice blog that says they should not do that!  Are there other best practice docs that say that( not to rename SAP fields !)

      Assuming the field name is "Sales_Order" not VBAK_VBELN  is there any code I can do that will in the config tell the VA03 tile to look for "sales_order" ?

       

      Best Ned

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Ned,

      Is your request the dictionary of the field names in VDMs?

      I think there are no published ones, but if you pick some important VDMs, many field names should be covered. e.g. you can find charg  is batch in I_MaterialDocumentRecord. some views could be uses ad dictionary I think.

      Yes, the field name in VDM should be used, otherwise you would face difficulty in IBN.

      when you push F2 key in the view name, you can find the data elements for the fields, which could be the hint to find a field is coming from which field in the source table.

      hope they could be the weapon for your battle.

      On the other hand, I know some customers who love the naming rule : <Table>_<Field> just like your company.

      Thanks, Masa

       

      Author's profile photo Ned Falk
      Ned Falk

      Are there any formal BP guides that say  " do not change the SAP VDM".. If you build a custom web app you can pass "yourMAMa" as SalesOrder id..  But the Fin.Analyze is not custom.. is there anyway with customizing to tell the VA03 tcode that it should read the value of the "Sales_order" field?  I think not 🙁

      Author's profile photo Ned Falk
      Ned Falk

      Also .. sorry I am such an CDS idiot.. ( I was great punch card programmer)  I do not want to redo all the cds views that have renamed the fields.
      I will have a semantic object / action called ZTradeContract/Display..    the t code for this is WB23  the input to this is the trading contract #  in german = KOMWBHK-TKONN.

      So on the Consumption (QUERY) CDS view I will be using for the Query browser and Tile I tried to rename the field back to KOMWBHK.TKONN.  but  it throws an syntax error.    All I could do is rename it to TOKNN see below.

      When I add the parameter to the Ztrading contract tile  will it pass tkonn to KOMWHHK.TKONN?

      SoldTo,
      @AnalyticsDetails.query.axis: #ROWS
      @EndUserText.label: 'Status'
      @AnalyticsDetails.query.display: #TEXT
      ApplicationStatus,
      @AnalyticsDetails.query.axis: #ROWS
      @EndUserText.label: 'Contract #'
      PurchaseTradeContract as tkonn,
      @AnalyticsDetails.query.axis: #ROWS
      @EndUserText.label: 'Contract Type'
      TradingContractType,
      @EndUserText.label: 'Price'
      @AnalyticsDetails.query.axis: #ROWS
      MaterialPriceChar,

       

      Author's profile photo Ned Falk
      Ned Falk

      I am trying this jumping to a TCODE tile and passing a parameter  without success:(!

      I am trying to use fiori tiles based on either FPM_BICS_OVP  or Fin.acc.query.analyze ( the design studio grid option.  I am trying to jump from the grid tile to a traditional tcode based fiori tile.  like VA05.  In this case it is a custom version ZVA05,  Here is what I have done so far ..  no success!

       

      1) Look at the inputs for ZVA05 (field name for sold to party =VBAK- KUNNR (Below) or  for doc# VBAK-VBELN

       

       

      2) Create target tile to execute ZVA05 in fiori designer.  Semantic Object  = ZVA05P   with parameters based on prior selection screen field names (VBAK-VBELN and VBAK-KUNNR)

      3) Create Fiori Tile for Design Studio MUlti-dim Grid.  Runs CDS Query 2CZNED_ARREPORT  with XSEMANTIC_OBJECTS = ZVAO5P  (from above)

      4) Run tile -  highlight a row and use Jump-to - ( it just spins and spins)

      4) The issue I think is in  the CDS view  but I am not a coder..  The CDS view has have pass Customer as VBAK-KUNNR.. but the coding people at the company I am consulting for have renamed all the fields and even if they did not the field names might be different in the table vs the input screen.  I tried this code in the CDS view ..

      @AnalyticsDetails.query.axis: #ROWS
      @AnalyticsDetails.query.display: #KEY_TEXT
      @EndUserText.label: 'Customer'
      @Consumption.semanticObject: 'VBAK-VBELN'
      Customer,

      With no success. . Any ideas..  I tried a few options ( maybe the model cache needs to be cleared?

      Ned

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Ned,

      Strange... this setting have worked in my test.

      The only difference is, in my case, @Consumption.semanticObject: ‘VBAK-VBELN’ is not included.

      Thanks, Masa

      Author's profile photo Ned Falk
      Ned Falk

      Thanks Masa for responding,

       

      The cute view that this query view is off of has the field customer.

      How could yours work unless the field name was feedback vbak-vbeln in the CDs view.

      How would it know which field to pass to the sales order transaction. From the multi dim reportI thought that was the purpose of that extra semantic object tag in the CVS view so I tried it.

       

      Is there anyone else that you can pick up that might have input thanks so much.

      Any bloggers out there that have good ideas as well?

       

       

       

      Author's profile photo Ned Falk
      Ned Falk

      Hi @masaaki.arai

       

      Ned again!

       

      I am going crazy..  the CDS view has prompts but specifically they are set to not be mandatory..

       

      Salesrep,
      @AnalyticsDetails.query.display: #TEXT
      @EndUserText.label: 'Sales Associate'
      @AnalyticsDetails.query.axis: #ROWS
      @Consumption.filter: { selectionType: #SINGLE, multipleSelections: true, mandatory: false }

       

      When you open the cds view in the query browser the prompt window does not open.  HOWEVER,  this is the not desired part,  if you create a tile as shown above all the non mandatory prompts appear..  if you set the visibleprompts param with no prompts it brings up the prompt screen all blank but it still brings up the prompt screen..  We do not want any prompt screen,  unless specifically called up by the user.  "just like the query browser works!"

       

      Thanks for any tips anyone!

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      If you want to display prompt in any cases, add “XPROMPT=X” in the tile as explained in the blog. otherwise, if there is no mandatory parameter with default value in the query, the prompt screen doesnt appear. It is the design.

      Thanks, Masa

      Author's profile photo Gagan Bakhshi
      Gagan Bakhshi

      Hi Masa,

      I don't think it is working this way. We have ui5 1.60.24. We are using BEx queries. We have a prompt on Project value which can be submitted without any value, and there are no default values. When the tile is executed, it still shows the Project field as prompt, and we simply move forward without passing any value.

      Also, there is another thing that you might want to clarify regarding filters. I have two exactly similar queries for which I have a navigation  in jump to. It takes the prompt value automatically when we jump to the other screen, but the same does not apply to filters i.e a filter applied in once screen is not getting propagated to the other screen, is there any special condition for the same?

       

      Thanks

      Author's profile photo Gagan Bakhshi
      Gagan Bakhshi

      Hi,

      You can solve this behavior in the following steps:

      1. Run the tile after configuring the CDS query.
      2. When the prompts appear, do not select anything and click OK.
      3. Once the data loads, check the URL above.
      4. Copy the value for sap-xapp-state.
      5. Go to the target mapping for your tile.
      6. Add a parameter with sap-xapp-state, and paste the above value as default value.
      7. Save your changes.

      Done. Next time you run the tile, it should not ask you for the prompts. You can then open prompts manually from the gear icon within the report, and change or add values.

      This should solve your requirement.

      Thanks

      Gagan

      Author's profile photo Ned Falk
      Ned Falk

      Thanks for the feed back ..  that should work,  but I think they need to fix it in the fin.analyze (MDR app)

      Author's profile photo Ned Falk
      Ned Falk

      Unfortunately,  the app state is what is used for the variants. ..  so if you apply the app state that works from the Query Browser ( that suppresses the prompts)  it overrides the appstate applied with the variants...the customer put in a ticket on this...there is most likely a note that fixes it I just could not find it.  It should not work with out prompts in the query browser as is correct but fail with finn analyze...

       

       

       

      Author's profile photo Max One
      Max One

      Hi Masa,

       

      thank you for this great blog! It was very helpful.

       

      I have a question regarding the Jump to functionality:

      Is there any way to limit the Jump Targets? For example the Customer returns so many navigation targets and i want to limit it and control which targets are displayed.

       

      Thanks,

      Anna

      Author's profile photo Sharadkumar Patel
      Sharadkumar Patel

      Hello Masa,

      It is nice blog and helpful us to display data from Custom Analytical Query using functionality of Multi Dimensional Reporting.

      I have one Query: Please let us know if have any option to disable Export to Excel functionality in multidimensional reporting.

      Thank you in Advance

      Sharad Patel

       

      Author's profile photo Former Member
      Former Member

      Hello Masaaki, great blog! have you ever used this approach with BW queries defined in a separate BW4hana instance? (not embedded BW). Use case: we use bw4hana for consolidation of data SAP and Not SAP and we want  to provide a consistent user experience and use custom Fiori analytical apps as front end (instead of SAC / Business Objects)

       

      Thanks for your feedback!

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello,

      it is technically possible. create system alias for BW in S4HANA and use it in the tile.

      Thanks, Masa

      Author's profile photo S S
      S S

      Hello,

      This is really a great blog. I am facing one problem using Design Studio Template.

      I have one CDS view analytical query created as Tile in Fiori (Design Studio Template) Tile, Keyboard keys like Page Up, Page Down , Tab are not working when Report is executed.

      I have tried this in multiple browsers. How can this be fixed?

      Author's profile photo Patrick Yolabo
      Patrick Yolabo

      Hello Masaaki,

      This is really a great blog! Thank you for sharing this info.
      I would like to know if in the Output screen using BW Query as source we can perform following:

      • Drag & drop Keyfigures + Characteristics
      • Drilldown
      • Add more functionalities like: save as bookmark, possibility to add additional column and perform calculation, etc. How can we achieve this?

      Thanks

      Pat

      Author's profile photo Robert Gregnol
      Robert Gregnol

      Hello Masaaki,

      How are these reports restricted via authorizations?  SAP delivered standard content for analytical apps (example Trial Balance Comparison) the trace shows that S_RS_AUTH is being called (analysis authorizations).  I created a new analysis authorization however nothing was set to auth relevant.
      I activated a couple info objects using the BW -MT to mark a couple different objects auth relevant however they get ignored when running the reports via FIORI app or RSRT.  I can see in the RSECADMIN trace that 0TCAACTVT gets called after being made auth relevant however it doesn't actually provide any restrictions.

      Thank you

      Robert

       

      Author's profile photo Robert Gregnol
      Robert Gregnol

      I've dug a bit deeper into this issue and it looks like the BW query via RSRT can be viewed in SE11 (different naming convention is used) from the view I was able to find the DDL source/data definition.  The access control is not specified in the data definition and no access control is assigned when checking the CDS view via t-code SACM.

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Robert,

      Yes, it is controlled with access control, DCL in which auth object and the field of CDS View is linked.

      https://blogs.sap.com/2017/02/27/abap-cds-views-with-authorization-based-on-access-control/

      Thanks, Masa

       

      Author's profile photo Erol Özdemir
      Erol Özdemir

      Hi Masa,

      is there a parameter to set fullscreen-mode in target mapping for FIN_DS_ANALYZE?

       

       

       

      If user opens the tile in Fiori-Lpd, report should display initially in fullscreen-mode.

      Thank you in Advance

      Erol

      Author's profile photo Baljinder Nagra
      Baljinder Nagra

      Hi Masa - thanks for this and many other blogs on the topics.  I see an SAP note regarding end of maintenance for Design Studio (BI-RA-AD).  2622437 - End of Maintenance for Design Studio 1.6.  Does this apply to users of S4 HANA Embedded Analytics Design Studio templates?  Or is this only explicitly for standalone SAP BusinessObjects software package components?

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello,

      No, BO Design Studio is different from Fiori Design Studio. But as of S/4HANA 2020, WD grid is the prime solution for multidimensional analytics in S/4HANA.

      Thanks, Masa

      Author's profile photo Meenakshi A N
      Meenakshi A N

      Hi Masa,

      Excellent Blog!!.

      1. Could you please let me know how can I default rows and column fields on initial rendering instead of dragging and drop each time while opening the app.

      In my case, Only 1 column comes by default from cds view.I need around 10+ columns to be shown on initial load of the app.

      Any suggestions are much appreciated!

      2. Provided the optional values as prompts, My report data as # values for all the prompt values given by user. Is there any way I can replace # with value entered by the user during prompts screen.

       

      Thanks

      Meena.

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello,

      1. pls set in the query (CDSView) using AnalyticsDetails.query.axis.
      2. sorry, I cannot understand enough but default value can be set with @Consumption.filter.defaultValue or lookup entry.

      Thanks, Masa

      Author's profile photo Meenakshi A N
      Meenakshi A N

      Thank you!! 1st issue resolved.

      2nd issue,

      I am getting # values in report. User is passing four input paramaters in prompts. How can I replace this with the correct value from cds.

      Please help!!

      I dont have filter option available here..How to enable filter


      Author's profile photo Meenakshi A N
      Meenakshi A N

      Hi Masa,

       

      I am getting # values in report. User is passing four input paramaters in prompts. How can I replace this with the correct value from cds.

       

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Meenakshi,

      # means No data, so pls check if the data is stored in the source.

      it is not related to the parameter value.

      Thanks, Masa

      Author's profile photo Meenakshi A N
      Meenakshi A N

      hello masa,

      Yes, it has data..For GLAccount in prompts i am giving value as

      0015080001.But in the report it is replaced with #.Similarly many columns has data in backend.

      I referred this blog which says # can be replaced by clicking on Filter ->filter member.But that doesnt work for me.

      https://blogs.sap.com/2017/05/31/custom-analytical-query-how-to-create-a-custom-analytical-query-and-display-in-a-grid-based-application/#

       

      Need ur suggestions and inputs

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello,

      it seems not product issue. the best is to consult with the analytic expert.

      if you share the source of generated CDS View, I can check.

      Thanks, Masa

      Author's profile photo Mayank Jaiswal
      Mayank Jaiswal

      Hello Masaki,

      Can we use View Browser application to create Multidimensional report in Private Cloud as well ? You mentioned that it can be used in Public cloud hence the question.

      Best Regards,

      Mayank Jaiswal

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Mayank,

      No, only on the Public Cloud.

      regards, Masa

      Author's profile photo Mayank Jaiswal
      Mayank Jaiswal

      Thanks Masa for your prompt reply.

      Regards,

      Mayank

      Author's profile photo Christiane Weis
      Christiane Weis

      Hi Masa, all,

       

      I try to fix the column with in my Fiori Web Dynpro Data Grid. And I would like to have the Column Header in 2 lines.

      Can you help me with that?

      In my BW Query this is possible but it is not reflected on Fiori side. See screens

      BW%20QueryFiori

      Fiori

      BW Query

       

      Thanks!

      Chris

      Author's profile photo Frank Schwitalla
      Frank Schwitalla

      Hi Masa, all,

       

      we´re trying to use XSEMANTIC_OBJECTS  to activate "Jump To" -Menu in a DesignSudio-App.

      It works fine with e.g. CostCenter. Is there way to add a sematic action as well? E.g.

       

      CostCenter-displayCOLineItemReportingView

      we wish to only Jump to this specific destination.

       

      Thanks!

       

      Frank

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Frank,

      AFAIK, None..

      regards, Masa

      Author's profile photo Juwin Pallipat Thomas
      Juwin Pallipat Thomas

      Hi Masaaki Arai

      It is possible to set the target of “Jump to” in Design Studio Data Grid.

      Is there a way to activate this functionality in WDA? This is a very useful functionality that connects the query report to other Fiori apps. Design Studio apps supports this functionality pretty easily. But, as you mentioned in the blog, these apps deprecated. So, what is SAP's alternative for this functionality on WDA.

      Thanks,

      Juwin

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Juwin,

      You can use XSEMANTIC_OBJECTS.

      regards, Masa

      Author's profile photo Arathy Nair
      Arathy Nair

      Hi Masaaki Arai

       

      Even I have the same query . I tried using XSEMANTIC_OBJECTS in Web Dynpro Data Grid type App  but the "Jump to" feature is not working for me in Web Dynpro Data Grid . Is there any parameter like XSEMANTIC_OBJECTS we can use in Web Dynpro Data Grid ?

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Arathy,

      In such cases, it would help to check the definition of the tile of the standard app.

      other than that, the following blog would help.

      https://blogs.sap.com/2021/07/12/how-to-enable-intent-based-navigation-for-reporting-with-web-dynpro-grid/

      Thanks, Masa

       

       

      Author's profile photo Arathy Nair
      Arathy Nair

      Hi Masaaki Arai,

       

      I referred the blog you mentioned but it is working only for standard  semantic objects . I have created two custom WDG Apps .But I unable to navigate to WDG App2  from WDG App1 in "Jump To" feature.

       

      Author's profile photo Dmitry Kuznetsov
      Dmitry Kuznetsov

      Hi Masaaki Arai,

       

      it's a great post I keep coming back to.

       

      Since WebDynpro-based grid is the future-proof solution, would you be able to point to the full list of URL parameters it can accept?

       

      Cheers,

      Dmitry Kuznetsov

      Author's profile photo Grace Zou
      Grace Zou

      Hi Masaaki Arai, Can I ask if there is any official help documentation about the process described in the blog?

      Thanks!

      Grace

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hi Grace,

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

      regards, Masa

      Author's profile photo Randy Timmers
      Randy Timmers

      Thank you for this clear blog post! Helped me a lot!

       

      I have a question regarding Custom Business Objects. Same as for Custom Analytical Queries it is possible to create a tile via the application for Custom Business Objects in Public Cloud. But in on premise this is not available. Do you know if it is possible to create a tile from a custom business object using the launchpad designer?

       

      Thank you in advance!

      Author's profile photo Masaaki Arai
      Masaaki Arai
      Blog Post Author

      Hello Randy,

      Pls create Fiori elements List Report with BTP BAS.

      regards, Masa

      Author's profile photo Sharmila Siddheswaran
      Sharmila Siddheswaran

      Hi Masaaki Arai

      Where could I see the list of the predefined multi-dimensional reports and Analytical list pages in S/4 Hana Cloud? Please suggest to me whether the app is available to see all types(Overview,multi-dimensional, analytical list pages) of standard reports

      Under the Manage KPIs and Reports app, am able to see only standard/custom KPIs and reports relevant to the generic drill-down type and not to standard multi-dimensional and Analytical list pages type.

      Please clarify why the multidimensional report will be opened in different UI technology (Web Dynpro). Likewise, KPIs/Generic drill-down reports opened in smart business-run technology.

       

      Thanks.

      Sharmila S