How to export list of dependencies from a tabular cube?

ovonemty 51 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.
431 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,239 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 29,786 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 No comments