Symptom
Measures and dimensions are missing in the query builder in SAC when creating model on OData connection to Datasphere.
Environment
- SAP Analytics Cloud version 2024.2.18
- OData connection
Reproducing the Issue
- Login to SAC.
- Under side navigation go to Modeler.
- Select Connection as OData services.
- Choose connection name.
- Select query and click on Next.
Notice that only one measure is available under query builder. Although other measures and dimensions are there in Datasphere side.
Cause
Input parameter is not supported in SAC Query Builder.
Resolution
Set the default value for the input parameters on DS side. Then in SAC, use freehand query instead of the query designer to fetch the data.
See Also
- 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 an case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using Google or Bing:
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.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 Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Keywords
model, OData, import, measure, dimension, query , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem
Product
SAP Analytics Cloud 1.0