Product Information
SAP Analytics Cloud – Sample Content: Generic Analysis application – URL parameter
With 2023.QRC2
The Generic Analysis is based on the so-called “classic mode”, not the optimized view mode. No further updates have been planned for Generic Analysis. There are also no plans to ship the Generic Analysis for optimized mode.
Once the Data Analyzer (see below) can offer the functionality of the Generic Analysis, this Analytical Application will be deprecated and is not more available via SAP Analytic Cloud Content Network. Content in your system will not be affected by the deprecation.
For details, please follow the SAP Roadmap Explorer here. You can easily access Data Analyzer through the product menu now.
With 2021.QRC2, we provide the option for the Generic Analysis application to set e.g. variable and/or filter values using URL parameters.
This blog describes how the parameters can be defined and how they can be applied.
Model Parameter
Model parameter can be used for the application widget Table.
Parameter | Values | Options |
p_ModelId | <MODEL_ID> |
Set the model to the table. The ID must be one of the following: A model ID with format
|
The parameter value must be URL encoded to work properly. Without URL encoded parameter, model Id may not be properly applied.
Variable Parameters
Variable parameters can be supplied for an application widget using a model with variable constraints.
Note
Variable parameters may be combined with filter and open prompt parameters. Any variables will be applied to the application before filters are applied.
Limitation
The parameter <p_ModelId> works not together with p_Variable. If you would like to set the variables via URL, then you need to use the same model in the sender and receiver application.You can use a bookmark url and the variable parameters. The bookmark must be based on the same model and the parameter <p_ModelId> is not required.
All parameter values must be URL encoded to work properly. Without URL encoded parameters, variables may not be properly applied.
For example, PM_COUNTRY_SELOPT$Multiple$DE,FR must be encoded as PM_COUNTRY_SELOPT%24Multiple%24DE%2CFR.
Parameter | Values | Options |
p_Variable | <VARIABLE_INFO> |
Identifies the variable and the values to apply the parameter too. <VARIABLE_INFO> consists of several parts. Parameter Syntax: p_Variable=<VARIABLE_ID>$<TYPE>$<VALUES>$<EXCLUDE>$$
1. <VARIABLE_ID> is the variable to apply the parameter value too. 2. $ is a character to separate the variable information from each other. 3. <TYPE> defines which type the variable values are
4. <VALUES> are the variable values for a variable. The parameter uses the IDs you want to set the variable value
<VALUE> is the technical name for a variable value. 5. <EXCLUDE> indicates whether the values are included or excluded. Optional. By default, set too true. Use true if you want to include the variable values in the member selection. Use false if you want to exclude the variable values in the member selection 6. $$ is a character to separate the variable parameter from each other. With this separator it is possible to set several variables NoteIf any supplied values cannot be resolved with the data source the variable value will not be applied. To find a variable ID and variables values: 1. Open an application in SAP Analytics Cloud. Select (Edit Prompts). A list of variables used in the application would appear if any models used by the application require prompts. |
p_Prompt
Optional. By default, set to false |
true, false |
Set this value too true if you want the prompt dialog to open. The variable values that were transferred via url parameters are set first and then the prompt dialog is opened. |
Unencoded Example URL:
https://<Tenant>/sap/fpa/ui/tenants/1fb7f/app.html#;mode=view;view_id=appBuilding;appId=F369AB05B762BA9624B25AF5C1747618;p_Variable=PM_CALMONTH_INT$Range$202001-202012$$PM_COUNTRY_SELOPT$Multiple$DE,FR
Encoded Example URL:
https://<Tenant>/sap/fpa/ui/tenants/1fb7f/app.html#;mode=view;view_id=appBuilding;appId=F369AB05B762BA9624B25AF5C1747618;p_Variable=PM_CALMONTH_INT%24Range%24202001-202012%24%24PM_COUNTRY_SELOPT%24Multiple%24DE%2CFR
FILTER Parameters
Parameters to apply filters to an application can be added to the open application URL.
If filters already exist for the specified application/widget, the filters applied in the URL will replace any filters on the same dimension. Any existing saved filters that are not replaced will continue to be applied in addition to the URL specified updates and additions. Filter parameters may be combined with display and variable parameters. Any variables will be applied to the application before filters are applied.
Note
Variable parameters may be combined with filter and open prompt parameters. Any variables will be applied to the application before filters are applied.
All parameter values must be URL encoded to work properly. Without URL encoded parameters, variables may not be properly applied.
Example: p_ModelId=t.1.BestRun_Advanced:BestRun_Advanced;p_Filter=Location_4nm2e04531$Multiple$[Location_4nm2e04531].[States].&[CT1],[Location_4nm2e04531].[States].&[CT2]$false$States$$
encoded as
p_ModelId=t.1.BestRun_Advanced:BestRun_Advanced;p_Filter=Location_4nm2e04531%24Multiple%24%5BLocation_4nm2e04531%5D.%5BStates%5D.%26%5BCT1%5D%2C%5BLocation_4nm2e04531%5D.%5BStates%5D.%26%5BCT2&5D%24false%24States%24%24
Parameter | Values | Options |
p_Filter | <FILTER_INFO> |
Identifies the filters and the values to apply the parameter to. <FILTER_INFO> consists of several parts. Parameter Syntax: p_Filter=<DIMENSION_ID>$<TYPE>$<VALUES>$<EXCLUDE>$<HIERARCHY>$$
1. <DIMENSION_ID> is the dimension Id to apply the parameter value too. 2. $ is a character to separate the filter information from each other. 3. <TYPE> defines which type the filter values are
4. <VALUES> are the filter values for a dimension. The parameter uses the IDs of the dimension members you want to filter on.
<VALUE> is the technical name for a variable value. 5. <EXCLUDE> indicates whether the values are included or excluded. Optional. By default, set too true. Use true if you want to include the variable values in the member selection. Use false if you want to exclude the variable values in the member selection. NoteThe Exclude indicator work together with Single and Multiple values. Ranges are not supported. 6. <HIERARCHY> specifies a hierarchy on which to filter. NoteThe member id depends on the selected hierarchy, so the hierarchy must always be specified as a parameter 7. $$ is a character to separate the filter parameter from each other. With this separator it is possible to set several filter parameters. NoteIf any supplied values cannot be resolved with the data source the filter value will not be applied. |
Unencoded Example URL:
https://<Tenant>/sap/fpa/ui/tenants/1fb7f/app.html#;mode=view;view_id=appBuilding;appId=F369AB05B762BA9624B25AF5C1747618;p_ModelId=t.1.BestRun_Advanced:BestRun_Advanced;p_Filter=$$Location_4nm2e04531$Multiple$[Location_4nm2e04531].[States].&[CT1],[Location_4nm2e04531].[States].&[CT2]$false$States$$Product_3e315003an$Multiple$PD1,PD12$true$@FlatHierarchy
Encoded Example URL:
https://<Tenant>/sap/fpa/ui/tenants/1fb7f/app.html#;mode=view;view_id=appBuilding;appId=F369AB05B762BA9624B25AF5C1747618; p_ModelId=t.1.BestRun_Advanced:BestRun_Advanced;p_Filter=Location_4nm2e04531%24Multiple%24%5BLocation_4nm2e04531%5D.%5BStates%5D.%26%5BCT1%5D%2C%5BLocation_4nm2e04531%5D.%5BStates%5D.%26%5BCT2&5D%24false%24States%24%24Product_3e315003an%24Multiple%24PD1%2CPD12%24true%24%40FlatHierarchy
Additional Information
With the Analytics Designer Sample Content via ACN, we provide two sample analytical applications. They show how the URL parameters are generated and how they are interpreted via script.
- Feature – URL Parameter – Sender_App
- Feature – URL Parameter – Receiver_App
Here is a script example of how to create the filter parameters for all filtered dimensions of a DataSource.
You check for all dimensions whether a filter has been set and if a filter is available, the filter is then converted into the required URL syntax. It is important that the associated hierarchy is determined, since the values are dependent on the hierarchy.
Sender_APP
Receiver_App
Here is a script example, how the url filter parameters are interpreted and the filters for the dimensions are set.
The sample applications also contain the scripts for the variable values.
Enjoy !!
Nice overview, thanks! Is there a plan to remove the limitation and allow both model and variables as parameters?
Yes, we plan to fix this limitation. But I can't give an exact time frame.
Hi Christina,
Thank you for the details. Can you please let me know how can I pass the model id in the following format?
My tennant namespace is cubeserv and the model is BI_Kongress.xlsx. How to combine the two to get this format? With CUID everything works fine but I just want to explore the other possibility.
Best regards,
Aneeque Hassan
Hi Christina,
and another question 🙂
how does the URL look like with the new navigation URL syntax?
Best regards,
Aneeque