Skip to Content

Filter Vs Combo Box - Hierarchy

Hi All,

I need some help with selectors in the dashboard design (BI Dashboard 4.0 SP2)

Here is my Issue:

I need to select a unique row from a dataset based on 4 selection criteria. Resultant destination cell becomes the input for a gauge.

I can use the Filter component with 'Number of Filters' as 4 as achieve this. But I run into the following issues with the filter component:

Issue #1 Set a particular label/selection as default, for instance one of the selections is Year and I want this year to always be the current year. My dataset has years ranging from 2000-2012 and the default always is 2000 (and the list is arranged in ascending order), another selection is a division name , I want the headquarter to be teh default but that also is arranges in alphabetical order.

Issue #2 Since the size of individual filters cannot be adjusted. For instance the Division name can run upto 20 Chars and the Year will always be 4 chars, to accomodate both the size is set to 20, which doesnt look good and takes up unnecessary space.

To overcome the above, I have tried using the 4 combo boxes. The result dataset of first combo box becomes the source data of the second , so on and so forth until the result of the final combo box is a unique row, one cell of which is teh input to the gauge. The combo box lets me choose the default value to show

The Issue with this is:

1. the default selections do not show the correct unique row. If I make a new set of selections the unique row is selected.

2. In the process of making selections, until the last selection is made more than one row is resturned which results in incorrect values of the gauge. For instance teh first combo box returns 4 rows , the second 3, the third 2 and teh last one one uniques row. But when just teh first selection is done, the value in the gauge is incorrect.

Any suggestions?

Thanks for taking your time.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 05, 2012 at 04:15 PM

    Hi Shabna,

    I personally stand for the combo box as it gives more flexibility.

    Do the following and you will resolve the 2 issues you listed above with Combo Boxes:

    1. starting from 2nd combo box, Behavior -> Common -> Selected Item:

    Type: "Position"

    Item: 1

    2. This will always result in a unique row in the final destination and a correct value for the gauge

    Try it and let us know if this is what you were lookin for.


    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.