SAP Knowledge Base Article - Public

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

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.
  • 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

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