How to get list of Dimesion and Fact table from Specific DataSource

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 1

What kind of data source? Where are you trying to find those lists? In the data source view of SSAS?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

selvakumar.sms SSC Eights! Points: 895 More actions · Answer 2

I am in SSMS -Analysis Service ,i want to find list of Fact tables and Dimension tables coming from each data source.

--------------------------------------------------------

I am Learner -- SQL

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

In SSMS, you can see the list of databases first.

Open it up, there you can see the list of cubes and dimensions.

Inside a cube, you can see the various measure groups and their facts.

You cannot see from which data source they come from. You can see the various data source definitions though.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

selvakumar.sms SSC Eights! Points: 895 More actions · Answer 4

Under Cubes I can find dimension but how to find which dimension is coming from which data source ?

--------------------------------------------------------

I am Learner -- SQL

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 5

selvakumar.sms (8/27/2014)
Under Cubes I can find dimension but how to find which dimension is coming from which data source ?

You'd have to look in the Visual Studio solution.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP