Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to get list of Dimesion and Fact table from Specific DataSource Expand / Collapse
Author
Message
Posted Tuesday, August 26, 2014 11:44 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:15 AM
Points: 54, Visits: 446
Hi experts,

I am have 5 data source , I need to find list of Fact and Dimension from the corresponding Data Source.
pls guide me.

thanks


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

I am Learner -- SQL
Post #1607665
Posted Wednesday, August 27, 2014 1:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 13,641, Visits: 11,514
What kind of data source? Where are you trying to find those lists? In the data source view of SSAS?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1607682
Posted Wednesday, August 27, 2014 2:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:15 AM
Points: 54, Visits: 446
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
Post #1607717
Posted Wednesday, August 27, 2014 2:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 13,641, Visits: 11,514
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1607721
Posted Wednesday, August 27, 2014 2:51 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:15 AM
Points: 54, Visits: 446
Under Cubes I can find dimension but how to find which dimension is coming from which data source ?

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

I am Learner -- SQL
Post #1607727
Posted Wednesday, August 27, 2014 2:56 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 13,641, Visits: 11,514
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1607731
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse