Skip to Content

Drill Down on Charts and Click on Chart to Filter Other charts

Hello All,

I have a couple of questions on Design Studio.

1. I have 6 dimensions (0PRODH1, 0PRODH2, 0PRODH3...0PRODH6) in my Bex query. What we want to do is create a pie chart and with each click the pie chart should go to one below Product Hierarchy starting from 0PRODH1, 0PRODH2, until 0PRODH6. Is this possible? If it is how?

2. Is it possible to filter other charts by clicking a chart. For example, I have a one pie chart and let's say another bar chart next to it. Is it possble to click on pie chart and filter the bar chart next to it with the selected values in pie chart? How can I do that? I try to that with the script below but there is NO getSelectedValue() properties in the script for pie chart.

I appreciate your help already. Thanks.

DS_1.png (78.5 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Apr 10, 2014 at 11:26 AM

    See this thread:

    BO Design studio Chart Component issue ...!! | SCN

    "

    If Chart is bound to DS_1 and On Select event of chart is as below:

    DS_2.setFilter(dimension, CHART_1.getSelectedMember(dimension));"

    This works when you click a value on one chart it will select another.

    I haven't tried it with hierarchies.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 10, 2014 at 11:35 AM

    Hi Zahid,

    please use the following scripting function...

    URUN_HIER.setFilter("0MATERIAL_0PRODH2", URUN_HIER_2_PIE_CHART.getSelectedMember("0MATERIAL_0PRODH2"));

    Hope it helps?

    Best regards,

    Michael

    Add comment
    10|10000 characters needed characters exceeded