Home Forums SQL Server 2005 Business Intelligence Dynamic Dimension Security in Analysis Services based on User and Datasource Dimension RE: Dynamic Dimension Security in Analysis Services based on User and Datasource Dimension

  • Hi,

    Should you have put the second expression of the Exists() into brackets?

    SELECT

    [Project Dim].[Project Title].Children on 0

    FROM (

    SELECT

    Exists([Mandant Dim].[Mandant Name].CHILDREN,

    {[User Dim].[Username].&[Peter], "User Mandat Fact"}) on 0

    FROM [Security Concept])

    Second, what about this data

    UserDatasourceFact

    UserID | SourceID

    1 | A

    2 | A

    "Paul" and "Peter" see same group of projects?

    Regards,

    Igor

    Igor Micev,My blog: www.igormicev.com