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

  • May 2, 2014 at 2:04 pm

    #1710453

    UserDatasourceFact

    UserID | SourceID

    1 | A

    2 | A

    I have Project Dimension Table:

    Project ID | Source

    P1 | A

    P2 | A

    P3 | B

    I am wondering if the projects table can serve as a fact table that contains source and user attributes.

    ----------------------------------------------------