Hi,

This document provides steps and details on how to control or filter multiple combo boxes using a single combo box filter in SAP BO Dashboards(Xcelsius)

Versions of Software Used:

SAP BO Dashboards 4.0 – Version 6.0.5.0 , Build – 14,0,6,1036

Data Sample Used:


Below is the data sample used , we have different cities and also different values (value1,value2,value3) for corresponding cities.


Now, I want to give a single combo box as filter to user on City and filter all the values 1,2,3 and display them in scorecards.

City
Delhi
Pune
Mumbai
Chennai
City Wise Value 1
City Value1
Delhi 23
Delhi 34
Pune 12
Pune 23
Pune 44
Pune 53
Mumbai 67
Mumbai 9
Chennai 12
Chennai 10
Chennai 44
Chennai 33

City Wise Value 2
City Value2
Delhi 23
Delhi 34
Delhi 12
Pune 23
Pune 44
Mumbai 53
Mumbai 67
Mumbai 9
Chennai 12
Delhi 10
Delhi 44
Chennai 33

City Wise Value 3
City Value3
Mumbai 23
Mumbai 34
Pune 12
Pune 23
Pune 44
Pune 53
Mumbai 67
Mumbai 9
Chennai 12
Chennai 10
Chennai 44
Chennai 33
City Wise Value 4
City Value4
Delhi 23
Delhi 34
Pune 12
Pune 23
Pune 44
Pune 53
Pune 67
Mumbai 9
Chennai 12
Pune 10
Delhi 44
Chennai 33

Steps:


1. Create a combo box on the cities i.e. Delhi,Pune,Mumbai & Chennai <Combo box1>

2. Set the insertion type as Row and provide all the cities as source data and a single cell as the Destination.This will throw the City name which will be selected in the combo box to your destination cell.

3.Now, take another combo box <combo box2> and this time map it to the the City Wise Value1 data.

4.Select Labels as the City column.

5.Select insertion type as Filtered Rows, select the source data as the city and value1 columns and also the destination accordingly.

6.Now, the main step which will make it control from our single combo box1, go to Behavior tab of combo box2 properties and choose selected item type as Label and item as the Destination of our first combo box <combo box1>.

This step will make entry which will come in the first combo box into our City Wise value 1 combo box and will filter the data accordingly.

7.Perform this operation for all the other data separately.

8.Hide the combo boxes for city wise value1,value2,value3,value4.


Also, find attached xlf for your detail reference.


Note: Remove the .txt from the file.


Regards,

Javed


To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. SAP RON

    Hi Javed, Thanks for sharing, Do you have a video of these instructions, it would be helpful for someone like me who are new to the dashbaord designer, will appreciate, Thank you

    (0) 

Leave a Reply