Pass parameter from input control to Data Action in SAP Analytics cloud

[pragnya_m]

Hi ,

how to pass parameter value from input control to Data action. User should select only one member of the each dimension(product , cost center, entity , plant are the dimensions.) to seed the valid combination of data for planning. So, i have selected single selection and hierarchy as flat presentation but data action is not considering the input control as input value. I need to pass input control values as a single member to the data action. Is hierarchy selection of input control is mandatory for data action to work? Could you please let me know if there is any other alternate approach for this?

Regards,

Lakshmi

[N1kh1l · Accepted solution]

pragnya.m

Ok I get your problem now. I by passed that issue by just creating a hierarchy in the dimension with all members as root. Currently if hierarchy name is not defined for prompt the Advnaced formula does pass validation.

Prompt:

Dimesnion:

Input control

Nikhil

[Hemanshu_KS · Accepted solution]

Hi @N1kh1l 
I'm looking to use an input control as a fixed value parameter in my data action, but it looks like we can't use input controls that have some members excluded. Is there any workaround or scripting that could help us make this work? PFB the images for your reference. 

 

[pragnya_m]

Nikhil Anand, Thanks for replying. It is working fine when my input control user setting is "multiple selection hierarchy" with ParentH1 as hierarchy.

Is hierarchy selection of input control is mandatory for data action parameter to work?

Here user should select only base member(Single selection) of the each dimension(product , cost center, entity , plant are the dimensions.) to seed the valid combination of data for planning. So, i have marked user setting as "single selection" and hierarchy as flat presentation but data action is not considering the input control as input value in this case.

[N1kh1l]

pragnya.m

When you add the Data Action trigger, you can configure the prompts to read input control.

Example: TargetPeriod prompt

Hope this helps !!

Nikhil