Symptom
- When trying to change the selection of the query in the "Schedule Status > Edit Query" tab the following error message appears in SAP Analytics Cloud (SAC):
"The query selection cannot be changed. Only filters can be added, removed, or changed."
Environment
- SAP Analytics Cloud
- Any supported datasource to import data to models such as SAP Universe, SAP BW, etc.
Reproducing the Issue
- Logon to SAP Analytics Cloud.
- Select Main menu > Browse Models.
- Select "View more" on the column datasource in the model.
- In the last updated section select Edit Import Settings.
- Click on Edit Query.
- Open the existing query and try to add a dimension or measure that didn't exist before.
- Notice that the error message appears: The query selection cannot be changed. Only filters can be added, removed, or changed.
Cause
- Query filters can be modified, but columns cannot be added, removed, or changed. In the case of SQL databases, freehand SQL queries can't be edited.
- Documented in the section: Updating and Scheduling Models in the Product's documentation.
Resolution
- You can't add or remove dimensions or measures since this is a limitation. However, you can use dimensions as filters in the query.
- One enhancement has been introduced into New Model Type (model with measure) in Non-SAP Data Center Tenants (CF) Only. So if you are experiencing this issue in Classic Account model, it is recommended to migrate your Classic Account Model to a New Model Type.
See Also
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.
Keywords
model, cannot, modify, change, UNX, import, universe, BW, filters, added, removed, BW Query, Schedule, Schedule Status, Selection Screen, Dimension, SAC, SAPanalytics , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , LOD-ANA-ML , SAC Modelling , Product Enhancement
Product
SAP Analytics Cloud 1.0