Custom Input Parameter for a Cube View

JakeSteinberg
New Contributor II

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!

1 ACCEPTED SOLUTION

Manasa
New Contributor III

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.

View solution in original post

1 REPLY 1

Manasa
New Contributor III

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.