Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
When an Analysis Services database is in Tabular mode at the 1200 compatibility level, the metadata of the data model can be extracted by running a set of queries against the system views of the database to return all the user-specified metadata about the data model. The system views are also known as Database Management Views (DMVs).
To extract metadata by executing the Discover operation, follow these steps:
Use SQL Server Management Studio to open an MDX query window to the Analysis Services and select the appropriate database.
Run the following queries against the database:
<pre IsFakePre="true" xmlns="http://www.w3.org/1999/xhtml"> SELECT * FROM [$System].[TMSCHEMA_MODEL]
SELECT * FROM [$System].[TMSCHEMA_DATA_SOURCES] SELECT * FROM [$System].[TMSCHEMA_TABLES] SELECT * FROM [$System].[TMSCHEMA_COLUMNS] SELECT * FROM [$System].[TMSCHEMA_PARTITIONS] SELECT * FROM [$System].[TMSCHEMA_RELATIONSHIPS] SELECT * FROM [$System].[TMSCHEMA_MEASURES] SELECT * FROM [$System].[TMSCHEMA_HIERARCHIES] SELECT * FROM [$System].[TMSCHEMA_LEVELS] SELECT * FROM [$System].[TMSCHEMA_ANNOTATIONS] SELECT * FROM [$System].[TMSCHEMA_KPIS] SELECT * FROM [$System].[TMSCHEMA_CULTURES] SELECT * FROM [$System].[TMSCHEMA_OBJECT_TRANSLATIONS] SELECT * FROM [$System].[TMSCHEMA_LINGUISTIC_METADATA] SELECT * FROM [$System].[TMSCHEMA_PERSPECTIVES] SELECT * FROM [$System].[TMSCHEMA_PERSPECTIVE_TABLES] SELECT * FROM [$System].[TMSCHEMA_PERSPECTIVE_COLUMNS] SELECT * FROM [$System].[TMSCHEMA_PERSPECTIVE_HIERARCHIES] SELECT * FROM [$System].[TMSCHEMA_PERSPECTIVE_MEASURES] SELECT * FROM [$System].[TMSCHEMA_ROLES] SELECT * FROM [$System].[TMSCHEMA_ROLE_MEMBERSHIPS] SELECT * FROM [$System].[TMSCHEMA_TABLE_PERMISSIONS]
The output of these steps results in rowsets that describe the user-defined metadata objects within the database. The values returned in the rows correspond to the properties documented in [MS-SSAS] for the Tabular Metadata objects.