Need help with Drill down functionality

[Former Member]

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

[MustafaBensan · Accepted solution]

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.

[former_member520077]

This message was moderated.

[former_member520077]

This message was moderated.

[Former Member]

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!!!

[MustafaBensan]

No problems.  Glad you got it working

[former_member520077]

This message was moderated.

[Former Member]

Hi Tammy,

Thank You for the idea and indeed it helped me in creating another component for one of our other dashboard.

Thanks!

[TammyPowlas]

Please have a look at and see if that helps give you some ideas.