on 02-13-2015 10:34 PM
The Dashboards has been built using the Design Studio with the Datasource as two individual BW Queries pointing to two different components such as the cross tab and column chart.
In our previous Xcelsius we had the functionality of dynamic visibility which does the drill down from the crosstab to a column chart and we are trying to implement the same in the Design Studio.
We like to have in a way that we click on each individual rows in the Cross Tab, subsequently the Column chart should display data only for that particular selected row.
I tried the below code:
CROSSTAB_1.getSelectedMember()
DS_2.setFilter().
I tried the above code with the syntax of the dimension included but still I was unable to make it function.
Can someone please assist / guide me in order to make the above functionality to work.
Thanks
Hi Ahmed,
You are on the right track with your script but if you could provide more specific details of how you've coded that script we can try to resolve your issue.
To perform a drill down from a crosstab to a chart the following steps are required:
1. Assign a separate data source to the crosstab (say DS_1) and chart (say DS_2). The data sources must share the dimension that you want to drill down by;
2. In the On Select event script of the crosstab, code as follows:
DS_2.setFilter(dimension, CROSSTAB_1.getSelectedMember(dimension).internalKey);
Can you provide screenshots of the Edit Initial View window of your versions of DS_1 and DS_2 as well as a screenshot of your application showing crosstab and chart? This will help with providing further feedback.
Regards,
Mustafa.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Mustafa,
That perfectly worked! I had this code of DS_2.setFilter("0COSTCENTER__ZFUNCTION", CROSSTAB_1.getSelectedMember("0COSTCENTER__ZFUNCTION").internalKey);
The missing part was I did not do the filter on the edit initial view for the components and now it worked.
Thanks again for your help!!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tammy,
Thank You for the idea and indeed it helped me in creating another component for one of our other dashboard.
Thanks!
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.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.