cancel
Showing results for 
Search instead for 
Did you mean: 

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

guenay
Participant
0 Kudos
312

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.

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert

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
Participant
0 Kudos

Thanks William for your input.