Home Forums Data Warehousing Analysis Services How to get list of Dimesion and Fact table from Specific DataSource RE: How to get list of Dimesion and Fact table from Specific DataSource

  • In SSMS, you can see the list of databases first.

    Open it up, there you can see the list of cubes and dimensions.

    Inside a cube, you can see the various measure groups and their facts.

    You cannot see from which data source they come from. You can see the various data source definitions though.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP