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
- Open a story.
- On button.onClick, define scripts:
NavigationUtils.openDataAnalyzer("ConnectionName", "DataSourceName") - Click on the button.
- 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
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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