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 Igor,

    thank you for your Response.

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

    This Query was only a try to filter the Projects based on the returned Datasources. I am not sure wether the query is correct.

    Yes Peter and Paul have acces to the same Datasource. But they both should only see P1 and P2, because only this Projects comes from Datasource A.