How to export list of dependencies from a tabular cube?

ovonemty 56 Reputation points
2023-01-23T13:45:38.91+00:00

I have my cube already deployed:

User's image

I am looking to map the dependencies of the cube; that is, the name of tables / data objects being used in these cubes.

How can I output that list??

I would like to get the full list of all the sources like:

User's image

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,247 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 29,896 Reputation points MVP
    2023-01-23T17:25:11.6266667+00:00

    Hey, The below link can help : [https://stackoverflow.com/questions/58373283/ssas-tabular-dmv-to-get-source-query-for-a-table

    0 comments