[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1439
  • 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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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