none
PerformancePoint Services Cascading filter bug (SSAS source) RRS feed

  • Question

  • Hello all,

    Scenario is: Time controls available Locations and Location controls Sub-Locations so:

    I have Time dimension filter which is cascaded to Location filter

    and this is cascaded to Sub-Location filter.

    Now the Time -> Location works,

    but Location -> Sub-Location doesnt filter, instead shows all Sub-Locations.

    I have even made connection formula in the Location -> Sub-Location connection:

    MDX:

    nonempty( <<UniqueName>> * Sub-Location.children )

    How do I cascade the Time also to the Sub-Location filter? 

     

    Thursday, October 17, 2013 7:53 AM