Security Question - Dynamic Security SSAS


  • I have a question about SSAS Role based security.

    I have implemented a security in DSV

    where i have table for users(Active Directory Users). I have a bridge table which has relationshop with Business , which is tied to company..

    Apparently for some reason the security doesn't work . I have two similar implementation that works fine , it is just this cube that don't seem to be performing correctly , Not sure why.

    I created relationship reference relationship but for some reason it doesn't work. Heere is the screen shot of how my DSV and relationship look like  and exisst statment that i use Exists([Dim Business].[Business],StrToMember("[Dim Users].[Network Login ID].&["+Username+"]"),"Fact Business User Bridge"), Any suggestions



    Friday, July 26, 2013 10:09 PM

All replies