Skip to Content
0
Sep 25, 2014 at 06:12 AM

Cascade Drill Down

31 Views

Hi Gurus,

I have a scenario where in cascading drill-down takes place. I click on first chart and only then my second char appears, only when I click on second chart the third chart should appear, (basically only when selection is made in the previous chart the next chart should appear).

This happens when I first load the dashboard.

But When I change my selection in the first chart the second chart appears, but the third chart too is there (when there is no selection made in the second chart)

AS per my understanding, basically, here the selection in the second chart is not clearing and so the third chart is retaining the values of previous selection. Is there anyway to achieve this.

Below are the codes I have used for 1st,2nd charts respectively. I want to make it work somehow.

Chart 1:

if(PH1.isVisible()&&PH1.getSelectedMember("AAMMI0110").externalKey!="" )

{

PH2.setVisible(true);

DS_5.setFilter("AAMMI0110",PH1.getSelectedMember("AAMMI0110").internalKey);

}

else if (PH1.isVisible()&&PH1.getSelectedMember("AAMMI0110").externalKey=="")

{

TEXT_6.setVisible(false);

}


Chart 2 :

if(PH2.isVisible()&&PH2.getSelectedMember("0PRODH1").externalKey!=="")

{

PH3.setVisible(true);

DS_6.setFilter("0PRODH1",PH2.getSelectedMember("0PRODH1").internalKey);

}

else if (PH2.isVisible()&&PH2.getSelectedMember("0PRODH1").externalKey=="")

{

PH3.setVisible(false);

}

Thanks in advance.

Regards,

Sara