Skip to Content

Use of Input controls and filters


Can anyone tell me if is possible to create an input control against my WEBI report that will perform the action of "Contains" or "Begins With"?

I can also see you can use a filter bar on a WEBI but it is a very basic dropdown list allowing the selection of all values or a single value, can this or similar functionality offer the ability to multi select or create customer filters.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 24, 2014 at 07:41 PM

    My initial thought was that this wasn't possible, but hey it's Friday afternoon where I am so I decided to see if I could figure this out. I think I may have something that will work for you.

    My example uses the eFashion universe.

    The first step is to create a variable with no Formula to accept your filter value. I called mine "Store Name Filter Value"...

    I then created a new input control based on Store Name Filter Value...

    Select "Entry field" as the Control Type with a default value of an asterisk ("*") and set the operator to "Equal to".

    Next I created another variable called "Is Match" that takes the value of "Store Name Filter Value" and checks if it matches that of "Store Name" which is a dimension directly from the universe.

    Finally, I added a report filter on "Is Match".

    Here is the result. You see all rows with the default value of "*" in the input control...

    Now if I set my input control value to "*New*" I only the rows with the word "New" somewhere in the Store name.

    As it is this is case sensitive, but you could make it case insensitive by using the Upper function within formula in the Is Match variable.

    Enjoy,

    Noel


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.