Display Condition for Analytical chart depending on dynamic values RRS feed

  • Question

  • Hi,

    I have MDX query filter on Dashboard which shows three level tree structure of items from user defined heirarchy. I also have two analytical charts, say.......chart_1 and chart_2.

    Now, I want to display only chart_1 when any item at level 1 from MDX filter is selected and show only chart_2 when level 2 of 3 item is selected from the MDX filter.

    I have set display condition on these charts but it is difficult to maintain because items get added to the heirarchy everyday and my condition fails as they didnt get selected in 'display condition' as per their level.

    [ Note: I have designed dashboard as above because I have different measures to show depending upon level of the member in MDX filter. I couldnt do this in PPS chart, as I could have done this in SSRS, So i created two charts with different measures on them.]

    Thanks in advance.


    Monday, March 7, 2011 6:26 AM