SAP BO Dashboards(Xcelsius) - Controlling multiple combo boxes(filters) from a single combo box(filter)

[former_member195290]

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