Hi,

I have a hierarchy A->B-->C in my cube,

I have created three cascading filters using this hierarchy in PPS dashboard designer. I want to connect all the three filters to an analytic chart. But when I keep the Hierarchy A-B-C in the background of the chart ,I am able to connect it to just one filter at a time.

But I want that if any of the three filters are changed the report should be updated. How can I achieve this??

Is there some connection formula that needs to be added?? If so, a sample example would be most appreciated.

Thanks in Advance