Skip to Content
Technical Articles

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


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



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



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



Name Detail Example of Default value

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



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

    starts the application and displays only the Chart
    starts the application and displays only the Table (Default setting)
    starts the application and displays both Chart and Table. The Chart is displayed above the Table.
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
    • Example of the setting of XDISPLAY and XCHART_TYPE:
  • 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”.



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


Prompt screen is displayed.


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

The Tile in Launchpad Designer:

Target mapping:


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.





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:


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



Name Detail Example of Default value

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



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

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



(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”.



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!


You must be Logged on to comment or reply to a post.
  • 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!


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


    Mihir Kiri


    • Hello Kiri,


      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

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



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


    Mihir Kiri

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

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

      Thanks, Masa



    • 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

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


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

    • 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

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

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

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




    • 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


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



    • 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


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




  • 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


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

  • 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



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




    • 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

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



        • 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

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



          • 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

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



  • is it possible to add semantic object navigation inside query browser data Eg:- in query browser on click of GL No/Description it should go to GL Line item Standard apps

    • Hello Raju,

      I think impossible, as the semantic objects has to be set in the parameter of target mapping for the tile. But the same tile and target mapping is used for any queries in QB.

      Thanks, Masa

  • 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

    • 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


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

        Right Click of a Column:

        Jump To Dropdown.





          • 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

          • 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


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

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

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


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

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


        • 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

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




  • Hi @masaaki.arai


    Ned again!


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


    @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!

    • 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

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



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



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




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




  • 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


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

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

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



  • 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



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

      • Hello Robert,

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

        Thanks, Masa


  • 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


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

    • 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

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




    • 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

      • 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

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