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

[former_member184594]

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.

[TammyPowlas · Accepted solution]

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.

[former_member184594 · Accepted solution]

Thanks Tammy for your help.

I found a video for drill-down functionality.

quadox Webcast: SAP Design Studio - Datennavigation mt Drilldown und Fingergesten für iPhone &am...

[Former Member]

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

[former_member184594]

Thanks Micheal for your help.

[former_member182918]

This message was moderated.