Improve company productivity with a Business Account.Sign Up

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

How to Identify Source Tables for a Cube in SSAS?

What is the easiest/best way to identify what TABLES are used as Sources for a SSAS CUBE?

I'm seeking to find a way to list-out the TableName(s) that a SSAS Cube sources its data from.

Thanks
0
MIKE
Asked:
MIKE
1 Solution
 
lcohanDatabase AnalystCommented:
-- You can do it via a MDX query like:

SELECT  *
 FROM  $SYSTEM.MDSCHEMA_DIMENSIONS
 WHERE  [CUBE_NAME]='TEST CUBE'


--OR see:

"Using SSRS to report SSAS 2008 database structure using DMVs"

http://www.ssas-info.com/VidasMatelisBlog/144_using-ssrs-to-report-ssas-2008-database-structure-using-dmvs
0
 
MIKESoftware Solutions ConsultantAuthor Commented:
Thanks!!!
0
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

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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