Performance Point Filter not linking to CUBE Dimension Security in 2010 RRS feed

  • Question

  • Hi Team,

    I have written simple MDX Descendants([Dimension - Organisation].[Organisation Hierarchy],3) which works fine on PPS 2007. [Dimension - Organisation] having a security in BI solution, I mean I allowed  only few users to access few members in dimension. When I browse the dimension in BIDS it is working fine and  it is showing what I want.

    The point is, When I link the Organisation dimension to performance point filter it is showing all members. It is not picking my dimension security settings which I put in BIDS.

    Am I doing anything wrong here or things have changed from 2007 to 2010?

    Appreciate your help.....

    Many thanks





    Monday, May 16, 2011 3:05 PM


  • Are you using the per-user security setting in the authentication settings for the SSAS data source you have defined?  These are all setup individually now in PPS 2010.  I would check that and also verify the credentials being passed in through a Profiler trace against the SSAS instance.

    Dan English's BI Blog
    Thursday, May 19, 2011 11:05 AM

All replies