SAP Knowledge Base Article - Public

3503828 - NavigationUtils.openDataAnalyzer() generates error when the data source is from Datasphere live connection.

Symptom

Using NavigationUtils.openDataAnalyzer(connection?: string, dataSourceName?: string) to open Data Analyzer with Datasphere as data source. Seeing the following error:

  • The query executed with errors.
    Caught exception : exception 42764: The query is inconsistent : Only queries with query datasource referencing each other.
    Listener call failed to OuQueryExecutionListenerLambda | Reason: Illegal Argument: Structure dimension must be present to create a filter line menu with measures/accounts.

Environment

SAP Analytics Cloud 2024.8.15.

Reproducing the Issue

  1. Open a story.
  2. On button.onClick, define scripts:
    NavigationUtils.openDataAnalyzer("ConnectionName", "DataSourceName")
  3. Click on the button.
  4. Error:

    The query executed with errors.
    Caught exception : exception 42764: The query is inconsistent : Only queries with query datasource referencing each other.
    Listener call failed to OuQueryExecutionListenerLambda | Reason: Illegal Argument: Structure dimension must be present to create a filter line menu with measures/accounts.

Cause

Should define a parameter for data source system type.

Resolution

Use: NavigationUtils.openDataAnalyzer("ConnectionName", "DataSourceName", UrlParameter.create("systemType", "DATASPHERE"))

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

data analyzer, jump, URL parameter, parameter define, passing parameter, open url , KBA , LOD-ANA-DAN , SAC Data Analyzer , LOD-ANA-UNS-DVP , Unified Story Developer Issues , LOD-ANA-AD , Analytics Designer , Problem

Product

SAP Analytics Cloud 1.0