Dynamically filter the values displayed in an Input Control within an SAP Analytics Cloud story

[Eladtayarr]

Hey everyone!

On an SAP Analytics Cloud story and I'm facing a challenge with Input Controls.

Currently, I have one Input Control that displays all members of a selected hierarchy.
What I need to achieve is to dynamically filter the values displayed in this Input Control based on the selection made in another Input Control.

Is there a solution that allows me to dynamically filter the members of one Input Control based on the selection of another Input Control?

Any guidance or suggestions would be greatly appreciated! 🙏

[AbdullahShaffi]

Yes. It's possible.

If your Input control is based on Booked values, then you need to enable Cascading effect. If you do not any booked Actuals, you can write a data action to initialize valid combinations with a dummy data to enable cascading option.

In case of Unbooked data, this requires a bit of JavaScript to be done.
Example: Let's say you have a Selection_1 for Profit Center Dimension and Selection_2 for Cost Center Dimension.

Cost Center Dimension should have Profit Center maintained as properties.

On selecting Input_Control_1 (Profit Center), use PlanningModel.getMembers function to read all members in the dimension. Loop the result and append to a Dropdown box with filter on CostCenter.ProfitCenter = {InputControlSelection}.

Currently, there are no APIs to append members to an Input control.
You can also use InputControl.getInputControlDataSource().setSelectedMembersWithUnbooked() or InputControl.getInputControlDataSource().setSelectedMembers() but this works more like setting default values based on another Input control selection.

[Eladtayarr]

Thank you so much for your help!