BARG
Reputation: 43
List tables/Views used by a SSAS tabular Model in SQL Server
Is there any way to List all tables/Views used by SSAS tabular Model in SQL Server
Upvotes: 1
Views: 2669
Answers (1)
Gigga
Reputation: 577
There are DMVs that might give you some information: https://learn.microsoft.com/en-us/analysis-services/instances/use-dynamic-management-views-dmvs-to-monitor-analysis-services?view=asallproducts-allversions, TMSCHEMA_DATA_SOURCES sounds promising.
Upvotes: 3
Related Questions
- How to find which views are using a certain table in SQL Server (2008)?
- How do I find the tables and columns which make up a view
- Search a group of SQL Server views for tables use
- Determine table referenced in a view in SQL Server
- How to get table names as seen in SQL database with SSAS DMV/MDX query
- finding tables and columns used in oracle sql view
- Finding source of data in SSAS tabular
- SSAS Tabular Model Dynamic Management Views and stored procs
- SSAS Tabular View
- How to list the source table name of columns in a VIEW (SQL Server 2005)