on 11-22-2021 10:02 AM
Hello experts, I'd like to know if it is possible to use SAC Model Variables in SAC Advanced formulas, especially in the Memberset statement.
my usecase is the following:
- a planning model with import data
- input story at Company level, Company is prompted through the Model Variable
- a data action with an Advanced formula, I'd like that the scoping of the formula is driven from the Model variable value already selected
I wasn't able to find any reference to this.
thanks for your feedback
As William pointed out, model variables cannot be used in data actions, story filters nor in import jobs.
Makes me wonder as well why they exist!
I'd suggest you to vote here:
https://influence.sap.com/sap/ino/#/idea/263082
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi daniele_cortopassi,
Model variable will not filter your data in the story and it can't used in data action. Instead of using model variable, I suggest to create either story filter or page filter(input control), data action can take value from story filter or page filter as input parameter.
Best regards, William
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi lazfreitas , that's exactly my point, I'd like to understand if it is possible to use the memberset statement the Model Variables (prompts at model level). So far I didn't found any example or reference in the guides
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
67 | |
26 | |
9 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.