Skip to Content
avatar image
Former Member

Need help with Drill down functionality

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • Best Answer
    Feb 14, 2015 at 01:24 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2015 at 11:49 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13, 2015 at 10:39 PM

    Please have a look at Why use OpenDocument with Design Studio and see if that helps give you some ideas.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 16, 2015 at 11:47 PM

    Hi Tammy,

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

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2016 at 11:20 AM

    This message was moderated.


    DS1.PNG (9.1 kB)
    DS2.PNG (9.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2016 at 12:14 PM

    This message was moderated.


    DS1.PNG (9.1 kB)
    DS2.PNG (9.4 kB)
    Add comment
    10|10000 characters needed characters exceeded