3292615 - SAC : Issue While opening data analyzer from analytical application

Symptom

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.

Environment

SAP Analytics Cloud (Enterprise)

Cause

URL parameter used for passing filter dimensions and their values work only with ID values.

Resolution

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)

Parameter Syntax:

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

Keywords

KBA , LOD-ANA-AD , Analytics Designer , How To

Product

SAP Analytics Cloud all versions