none
Cascading Filters Across SSAS Cubes in Performance Point 2012 RRS feed

  • Question

  •  I have a dashboard with two different data sources. Right now I have two scorecards and two filters (one for each cube I am using as a data source).

    Since the two filters are both hitting a staff dimension  (with identical underlying data) I would like the end users to only select their name once and have the value "cascade" to the filter from the other cube.

    Is this something that is possible to do?


    • Edited by clio423 Monday, January 28, 2013 11:50 PM
    • Moved by Elvis Long Wednesday, January 30, 2013 6:23 AM
    Monday, January 28, 2013 11:48 PM

All replies

  • Hi clio423,

    We discusstion SQL Server Analysis Services realted issue in this forum. From your description, it is more related to PerformancePoint. I will move this thread into PerformancePoint Server Forums> Monitoring and Analytics forum for better support.

    Thanks for your understanding.

    Regards,


    Elvis Long
    TechNet Community Support

    Wednesday, January 30, 2013 6:20 AM
  • Yes you can do that from 2 different data sources or cubes as long as your underlying dimensions are same. Meaning the 'Member Unique Name' should be consistent like [Dim Dimension1].[DimensionName].&[Somevalue] in both the cubes.

    Connect the 2 cascading filters on MemberUniqueName, cascading should work.


    http://dailyitsolutions.blogspot.com/

    • Proposed as answer by Dan English Tuesday, June 18, 2013 11:36 AM
    Thursday, February 14, 2013 7:16 PM
  • Thanks! This worked perfectly!
    Friday, May 17, 2013 4:39 PM