SAP Knowledge Base Article - Public

2466312 - "The query selection cannot be changed" error message appears in SAP Analytics Cloud

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

  1. Logon to SAP Analytics Cloud.
  2. Select Main menu > Browse Models.  
  3. Select "View more" on the column datasource in the model.
  4. In the last updated section select Edit Import Settings. 
  5. Click on Edit Query.
  6. Open the existing query and try to add a dimension or measure that didn't exist before.
  7. Notice that the error message appears: The query selection cannot be changed. Only filters can be added, removed, or changed.

Cause

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. Please Vote for this idea on the link below if you would like to see this feature added in SAC, as the most voted idea gets picked first by our SAC Developers. https://influence.sap.com/sap/ino/#/idea/229660/?section=sectionDetails

See Also

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 , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predicitive , Problem

Product

SAP Analytics Cloud 1.0