How to use NavigationUtils.openDataAnalyzer() to open data analyzer for a specific query and dimension filters and their values.
|static openDataAnalyzer(connection?: string, dataSourceName?: string, parameters?: UrlParameter | UrlParameter, newTab?: boolean): void|
Opens the Data Analyzer.
You have a requirement to open data analyzer using a direct HANA connection, for a specific query and filter dimensions and their values.
Formatting UrlParameter(s) with dimension names, e.g. "Period", and their values does not work.
- SAP Analytics Cloud (Enterprise)
URL parameter used for passing filter dimensions and their values work only with ID values.
NavigationUtils parameters require certain specific format as detailed in the following blog: Dynamically passing filter values from SAP Analytics Cloud Analytic Application to a Story | SAP Blogs
Specifically, the parameters which contains values for filter values use IDs as detailed in the blog.
The blog defines the syntax as
Dimension ID (Required Parameter)
f<XX> Dim = <Dimension ID>
Here <XX> is any number between 01 and 99. If you want to pass filters for multiple dimensions then assign a new value to XX each time you add a new dimension.
For example f01Dim = “0CUSTOMER”
f02Dim = “0MATERIAL”
How to find a dimension ID:
- Open a story in SAP Analytics Cloud and add a story filter. This will bring up a list of all the available dimensions. Hover the cursor over the dimension name ,the tooltip then shows the dimension ID and description as they are available in the model.
For all the details please refer to blog: Dynamically passing filter values from SAP Analytics Cloud Analytic Application to a Story | SAP Blogs
KBA , LOD-ANA-AD , Analytics Designer , How To