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.

[N1kh1l · Accepted solution]

@guenay 

Your approach will work but its not scalable for larger dimensions. Technically you are just filtering the members using a property value and passing this filtered array as parameter to Data Action. 

I generally prefer to keep DA simple as it helps during debug and reconciliation when DA outputs are not as expected.

But Yes the approach will work.

Nikhil

[guenay · Accepted solution]

I found out that the maximum number of elements allowed for the parameter is 100, which means this option doesn't meet my requirements.