Custom Input Parameter for a Cube View

[JakeSteinberg]

Hello,

I am looking to build an Input Parameter and additional rule (if necessary) in which the User will be prompted to input the beginning of an Entity (eg. A123) and the Cube View will return all Entities in the rows which start with A123. (eg. A123_400, A123_500, A123_600). Has anyone created something similar to this? Thank you!

[Manasa · Accepted solution]

Hi jake, 

I haven't tried this before but I think the following approach should work.

• input parameter that's attached to a text box
• button to save the input and refresh the dashboard
• cv filter : E#Root.Descendants.Where(Name StartsWith '|!param_userInput!|')

do check the performance of the report, it might take a while to load.

Thanks.