Analysis Services - Querying Catalog Views from SQL Server

Views: 369
Reading Time: 3 minutes

Hi guys,
How are you?

In this post, I would like to write about querying Analysis Services catalog views, either with queries through SQL Server or using the SQL Server Management Studio MDX or DMX query interface.

My purpose in this post is just to demonstrate SQL Server Analysis Services (SSAS) catalog views (DMV). If you want to understand how I can do these queries by SQL Server using Linked Server “INTERFACE_CUBOS”, as if they were normal database queries, which I find more practical, see how in the post Analysis Services (SSAS) - How to query information and process command line (XLMA) commands through SQL Server.

The full link to Analysis Services DMV's can be found in this link.

Management Studio Query Example> New DMX Query

Management Studio Query Example> New MDX Query

Query Example in Management Studio> New Query (Transact-SQL)

Querying Catalog View Information

After this short introduction, let's now start our queries.

Retrieve information from all instance cubes

Retrieve cube dimension information

Retrieve attribute information from a cube

Retrieve cube information

Retrieve calculated measures information using cube expression

Retrieve dimension information and its Measure Group

That's it, guys.
I hope you enjoyed this post, which was just an introduction to using Analysis Services catalog view queries.

A hug and see you next.