on 08-22-2013 4:43 PM
Dear Expert's,
I am stuck with a problem while designing my dasboard.
I have data in the following format.
Year - Quarter - Customer - Division - KF1 - KF2
2005 - Q1 - SAP - Consulting - 10 - 20
2005 - Q2 - IDE - Food - 20 - 10
2005 - Q2 - SAP - Jets - 12 - 11
2006 - Q2 - RAM - Jets - 11 - 11
What i wish to do, is to create radio box(for selection) to choose any Year, Quarter , Customer & Division
eg if the user chooses 2005 , i want to display 3 line entries
2005 - Q1 - SAP - Consulting - 10 - 20
2005 - Q2 - IDE - Food - 20 - 10
2005 - Q2 - SAP - Jets - 12 - 11
if the user further selects quarter - Q2 (without disturbing the selection on for year ) the result should be
2005 - Q2 - IDE - Food - 20 - 10
2005 - Q2 - SAP - Jets - 12 - 11
If the selection from year is removed (still maintaining the selection on quarter Q2 ) the result should show
2005 - Q2 - IDE - Food - 20 - 10
2005 - Q2 - SAP - Jets - 12 - 11
2006 - Q2 - RAM - Jets - 11 - 11
Simply i need to create a filer for all the fields.
The issue that i am facing with filer component is that - 1 - it returns only one desitnation row , 2 - you can only get Key values in result set
Issue with combo box is i cannot select multiple fields (dimensions) using it .
Please suggets .
Thanks in Advance
Hi,
I have a similar issue and I am able to use multiple combo boxes and filter rows upon selection. Now I have another requirement. The dashboard user wants to see a total value on the chart too. This means if I select year 2005, for quarter selection there should be an (All) selection that would sum up the values for all the quarters. I have a third level for months in a quarter and if i select a particular quarter, I should be able to select (All) to see the sum of all months in that quarter. Is this possible in the same chart? Please let me know if my question is not clear.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Zamir
Add one combobox component for each. Set up the Label property to the values of respective columns. Then use Filtered Rows as the Insersion Type.
Use the the Dataset as Source Data. Map the Destination to another location with same number of column as the source data range.
Then use the destination of the previous combobox as source for the next and keep on going.
Refer to the following guides if you need to see how to setup combobox and filtered rows.
http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_dashD_user_en.pdf
> Setting up interactive elements.
Runali
Hi Runali,
Thanks for the sharing the solution of implementing multicolumn (cascading) filtering. I am looking for multiple selections of the LOVs at all columns (levels). I know component List Builder can be used for multiple selections but it doesn't have filtered rows option. Do you have any solution/workaround to achieve this?
Thanks,
Anurag
Hi Bose,
I have worked on the similar scenario. As you have mentioned in the above query, by using filter component, result will be a single row data and that too it gets only key values. It is the component behavior.
Steps for implementing Multicolumn Filtering in Dashboards
1. Insert 4 combo boxes into the canvas.
2. For 1st combo box, map labels to year column data, map all columns data (including year column) as source and map required number of rows for destination with equal number of columns as in source.
3. For 2nd combo box, map the Quarter column data from the destination of 1st combo box, map the complete destination of 1st combo box as source and map required number of rows for destination with equal number of columns as in source.
4. For 3rd combo box, map the Customer column data from the destination of 2nd combo box, map the complete destination of 2nd combo box as source and map required number of rows for destination with equal number of columns as in source.
5. For 4th combo box, map the Division column data from the destination of 3rd combo box, map the complete destination of 3rd combo box as source and map required number of rows for destination with equal number of columns as in source.
6. This 4th combo box destination will be your required data with all columns which you can use for displaying through charts or spreadsheets.
You can go through the attached image in which you can find how I have arranged data in my spreadsheet for combo boxes source and destination.
In my Dashboard I have filtered Year, Plant, Month & Product Category. But scenario is similar. Keep posting if you find any difficulty in implementing this method.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bose,
Using COMBO BOX for year,quarter,customer and division and map the selected values to different cells. and do the Vlookup() based on the selected cells so that you can get the required output as you mentioned...
Regards,
Subbarao
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Bose,
we need some Clarifications for suggesting you...
1)Is it a static dashboard or dynamic dashboard
2) which Connection you are using
...
Regards
Subbu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
One option is to create an 'All' value for all the filtering column. So for 'all' year you will have all the quarters listed under it. So de-selecting year will be achieved by selecting All in the year filter.
Does this help?
Thanks
Runali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.