Linking data management sequence to combo-box selection in dashboard

AndreaF
Contributor III

Hi, sorry I always get a bit confused on how to use parameters in data management sequences/steps.

I have a dashboard with: a combo-box that let users select an Entity member; a cube-view which Pov is based on the combo-box selection; a button which runs a data management sequence.

The combo-box bound parameter uses a member list.

AndreaF_0-1695051996872.png

The data management sequence contains only one step, which is a custom calculate.

I would like the data management step to run on the selected Entity member (the one selected in the combo-box). How do I link the Entity of the data management step to the selected Entity member?

With the current Entity filter setup in the data management step:

AndreaF_1-1695051741358.png

- I can run the step from Application/Data management page and I am prompted to select an Entity. No issue in this case.
- I receive an error if running the data management sequence from the dashboard (Summary: Error processing Data Management Step 'Plan_Growth_Adjs'. Invalid parameter. Entity Filter, |!prm_plan_bu_entity!|.)

 

Thank you

1 ACCEPTED SOLUTION

AndreaF
Contributor III

The solution has been:

In the dashboard button, add a parameter when calling the data management sequence, and set the parameter equal to the combo-box bound parameter.

AndreaF_0-1695114767246.png

AndreaF_1-1695114895289.png

In the data management set, use the parameter defined in the dashboard button (and not the combo-box bound parameter as I was initially doing)

AndreaF_2-1695115052000.png

 

View solution in original post

1 REPLY 1

AndreaF
Contributor III

The solution has been:

In the dashboard button, add a parameter when calling the data management sequence, and set the parameter equal to the combo-box bound parameter.

AndreaF_0-1695114767246.png

AndreaF_1-1695114895289.png

In the data management set, use the parameter defined in the dashboard button (and not the combo-box bound parameter as I was initially doing)

AndreaF_2-1695115052000.png