Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, March 14, 2016 2:40 PM
Points: 55, Visits: 457
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 3, 2016 7:09 AM
Points: 15,149, Visits: 13,037
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 SQLKover.

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: Monday, March 14, 2016 2:40 PM
Points: 55, Visits: 457
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 3, 2016 7:09 AM
Points: 15,149, Visits: 13,037
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 SQLKover.

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: Monday, March 14, 2016 2:40 PM
Points: 55, Visits: 457
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 3, 2016 7:09 AM
Points: 15,149, Visits: 13,037
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 SQLKover.

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

Add to briefcase

Permissions Expand / Collapse