Skip to Content

SAC - The query selection cannot be changed

Hello Experts,

We have SAP SAC connected to SQL server and story boards are built on top of the model in SAC. Just the analytic model. Not a planning model.

We wanted to add the additional fields in to the Model from SQL server, but it isn't allowing us to edit the Model , throwing some error like :The query selection cannot be changed " the SAP OSS note - 2466312.

This note is a year old( 04/19) and solution says that.

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

Is there any way to add new fields in to the model without affecting the existing story boards.

Regards

Ramakrishnan Ramanathaiah

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Mar 12 at 09:51 AM

    Hi Ramakrishnan, This Note still applies, same as we documented in our Guide here:
    https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/6aa6a99d4eb5467896c4fd47bc9c7642.html

    I can tell you this has been requested by multiple customers already and its in our dev's backlog without any current timeline as it affects the whole modeling framework.

    Best, Mark

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 12 at 01:29 PM

    Thank you very much Mark for the answer.

    So If the end users have built stories on top of existing models, and we can not add fields to the existing models without affecting storyboards. Are there any other ways, like copying models and editing / move the story boards to the new model as long as the old fields still remains in the model. Could you update when you get a chance.

    Regards

    Ram

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.