121 thoughts on “SSAS: Using DMV Queries to get Cube Metadata

  1. Hi Benny,

    Just want to ask if there is a way to extract the table source (physical tables/views/name query) used by the cube measures/dimensions from data source view? If yes may i ask your help to formulate as I’ve been searching on this but found no answer 🙂

    Thanks!
    Bernard

  2. Hi Benny,

    Cool post. Any idea how to use DMV against empty (not yet processed) SSAS databases?
    We want to deploy a standard solution to any SSAS instance and then dynamically (via SQL config table) drop cubes and dims.

    Cheers,
    Tom

    1. Sumanth, Measures are usually numeric and you can get the precision if numeric MDSCHEMA_MEASURES Rowset. Don’t think you can get the same info for dimensions as the key value can be different from name value.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s