Forum Discussion

JakeSteinberg's avatar
JakeSteinberg
New Contributor III
2 years ago

Custom Input Parameter for a Cube View

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!

Methodology
  • Manasa's avatar
    Manasa
    2 years ago

    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.

  • Manasa's avatar
    Manasa
    New Contributor III
    2 years ago

    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.