Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 638
  • Last Modified:

Table name

Hello,
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.
thanks
0
samprg
Asked:
samprg
  • 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
0
 
samprgAuthor Commented:
It's good, I need table's name in data source view (Database) and column name for dimension Parent-Child, thanks
0
 
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
0
 
samprgAuthor Commented:
Thanks
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

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