a month ago
Hi team,
I am currently working on a Multi Action in SAP Analytics Cloud that contains four Data Actions from different models.
Is there a way to create a generic parameter (for example, a Year parameter) so that I only need to enter a value such as 2028 once, and then have all the Data Actions within the Multi Action automatically use that same year value?
In other words, I would like to maintain a single parameter at the Multi Action level and pass it to all underlying Data Actions, avoiding the need to enter the year separately for each one.
Has anyone implemented something similar or can confirm whether this is supported?
Muti action:
Data actions in question with year:
Thanks in advance.
Ganjos
Request clarification before answering.
May be something like below
var dateMember = "[Date].[YQM].&[202601]"; // YQM if your prompt hierrachy is YQM
// Set the parameter value on your Multi Action, change p_Date1,p_Date2,p_Date3 and p_Date4 with your date parameters name.
MultiAction_1.setParameterValue("p_Date1", dateMember);
MultiAction_1.setParameterValue("p_Date2", dateMember);
MultiAction_1.setParameterValue("p_Date3", dateMember);
MultiAction_1.setParameterValue("p_Date4", dateMember);
// Execute the Multi Action
MultiAction_1.execute();
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @N1kh1l,
Thanks for your answer. I’m following what you suggested, but the script doesn’t recognize the parameters.
They are exactly the same as in the multi-action.
Thanks in advance,
Ganjos
| User | Count |
|---|---|
| 6 | |
| 6 | |
| 4 | |
| 4 | |
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.