• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 686
  • Last Modified:

Table name

I'm working in SSAS DMV.
I get dimensions name and informations
from "Select * from $system.mdschema_dimensions",
but I need tables name from data source view.
  • 2
1 Solution
ValentinoVBI ConsultantCommented:
Have a look at the MDSCHEMA_LEVELS view.  It contains LEVEL_NAME_SQL_COLUMN_NAME
and two other ...SQL_COLUMN_NAME fields, maybe those help?

More info: http://msdn.microsoft.com/en-us/library/ms126038.aspx
samprgAuthor Commented:
It's good, I need table's name in data source view (Database) and column name for dimension Parent-Child, thanks
Mark WillsTopic AdvisorCommented:
Think that is a bit more involved than you might think is reasonable...

And, no I dont have an easy, ready made answer for you (sorry about that), but a few thoughts that might help...

There is a great report series that does do a good job of documenting your cube - especially hierarchies and levels. Have a look at : http://www.ssas-info.com/VidasMatelisBlog/144_using-ssrs-to-report-ssas-2008-database-structure-using-dmvs

There is also a bit of code given in : http://social.msdn.microsoft.com/Forums/en-AU/sqlanalysisservices/thread/31f45113-8270-4681-8565-8bbd7ca0a6ae for a list of table names. Though think the DMV's *should* be able to do the same.

A list of those DMV's (part list - the mdschema) : http://www.ssas-info.com/analysis-services-faq/80-ssas-2008-dmvs/1342-analysis-services-2008-systemmdschema-dmvs which also has a graphic of the outputs.

Then, there is the sass wiki with some great links http://ssas-wiki.com/w/Articles#DMV_.28Dynamic_Management_View.29 scroll down to metadata and DMV
samprgAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now