Forum Discussion

DRider's avatar
DRider
Icon for OneStream Employee rankOneStream Employee
2 years ago

Nested parameters to return one value

I am building a report that uses a nested parameter.  This report will run on a dashboard within Guided Reporting if it makes any difference. My parameters are Member List types. EntityParam1 uses ...
Parameters
Reports
FredLucas's avatar
FredLucas
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hi DRider,

I believe your set up should work as long as the combo box that holds the EntityParam1 is refreshing (as part of the User Interface Action) the dashboard that contains the component that uses the EntityParam2.

What does the error message says? I find it strange that is actually trying to do " E#Corporate.ChildrenInclusive.ChildrenInclusive.Children" are you sure that is what is causing the issue? Can you give us more information on how you've got to that conclusion?


I'd do two things, 1) update the Param2 member filter to include the dimension prefix like this:  E#|!EntityParam1!|.ChildrenInclusive.Children; 2) run the dashboard in debug mode to understand what might be going on (if step 1 does not fix it).