SAP Analytics Cloud for planning - Filter Data Action based on Dimension Property via Scripting

[guenay]

Hi everyone,

While researching this topic, I came across several discussions where people were asking if it's possible to filter a Data Action based on Dimension Properties. The common answer was "No."

However, I have an idea:

1. I can create a script that initializes a dropdown menu populated with the Dimension Properties.
2. The user selects an option from the dropdown.
3. Based on the user's selection, the script assigns the corresponding Dimension members to a variable.

This variable would then be used to populate the parameter in the Data Action, triggering its execution.

Would this approach work? If so, could you provide some example scripts to help implement this?

Kind regards,

ismail

@N1kh1l special thanks to you in advance.

[William_Yu]

Hi guenay, 

   If your requirement is to pass dimension property as parameter to data action, what you described basically is right. But you can directly set dimension member parameter to data action via API and trigger it. 

Best regards, William 

[guenay]

Thanks William for your input.