Technical Articles
How to create custom Fiori Multidimensional Reporting Application in S/4HANA on-premise
25/8/2022
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
- Why WD Grid?
- Standard apps: In finance area, use, both Design Studio based app and WD Grid app are provided F0996A and F0996 in many cases. Please consider using WD Grid apps in princilple.
- Test: You can launch WD Grid app with Tcd RSRT by selecting WD Grid as Query Display.
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 |
| 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
- &XDISPLAY=CHART&XCHART_TYPE=PIE
- 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>%%”.
- See the blog Applying User Defaults in SAP S/4HANA
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!
Very comprehensive! Much needed! Thanks!
Very timely Masa! We used the BW option at a customer this week and it worked perfectly. Thanks!
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!
Hello Jerry,
it is necessary to change the position in the Query. It is not possible in Fiori Design Studio.
Thanks, Masa
OK, got it. Many thanks!
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
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
Thanks Masa for the confirmation. I really appreciate your prompt response.
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
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
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
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
Hi Kiri,
In addition, below are my ideas, but are not verified.
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.
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.
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
Hello Masa,
Thank you for your reply. Any method to increase the threshold in LOV in the prompt window ?
Hi Ahmed,
A developer answered maximum 1000 values in the dialog are displayed. it is strange why only 10 values are displayed.
Thanks, Masa
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 @Masaaki Arai,
Any method to increase the LOV limit ?
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.
Regards,
Bal.
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!!
Bal.
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.
Thanks,
Bal.
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
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.
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
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
Martin
Hi Rimmete,
Unfortunately, yes.
I found the following parameter don’t work on UI 1.48 but work on 1.60.
Thanks for your understanding,
Masa
Hi Masaaki Arai
thank very much for your response. The Blog is very helpful!
kind regards
Martin
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
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.
Regards,
Shiva
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 ?
Thanks
Shiva
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?
Thanks.
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: 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
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
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?
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,
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
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..
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!
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?
Thanks
Hi,
You can solve this behavior in the following steps:
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
Thanks for the feed back .. that should work, but I think they need to fix it in the fin.analyze (MDR app)
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.
Thanks,
Anna
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,
it is technically possible. create system alias for BW in S4HANA and use it in the tile.
Thanks, Masa
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:
Thanks
Pat
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
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.
https://blogs.sap.com/2017/02/27/abap-cds-views-with-authorization-based-on-access-control/
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
Erol
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.
Thanks
Meena.
Hello,
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.
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
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.
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
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
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
Hi Mayank,
No, only on the Public Cloud.
regards, Masa
Thanks Masa for your prompt reply.
Regards,
Mayank
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
Fiori
BW Query
Thanks!
Chris
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
Hello Frank,
AFAIK, None..
regards, Masa
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
Hi Juwin,
You can use XSEMANTIC_OBJECTS.
regards, Masa
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