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

Data Source Views Expand / Collapse
Posted Thursday, September 9, 2010 1:50 PM


Group: General Forum Members
Last Login: Sunday, July 10, 2016 11:10 PM
Points: 10, Visits: 58
Hello all and apologies as this is a repost from the Newbie forum...

Just looking for some advice for a newbie to SSRS.

Search as I might I've been unable to find any useful information with regard to best practice for DSV design approaches. I guess the crux of my question is should I, when starting from a relational source, be using the DSV to model a star(ish) schema or would that be counter productive. Is it normal to simply import the tables and associations from the underlying source untouched, or is some tweaking required?

Another thing troubling me is how to handle multiple pseudo "fact" tables that reference a single "dimension". Is it acceptable to use a single dimension table joined to several other facts, or would that result in a potential ambiguous join. My concerns arise from pit falls encountered when using other data modelling tools (see Cognos' Framework Manager), where it is recommended to use multiple aliased instances of the dimension table.

Appreciate any advice you chaps have.

Post #983406
Posted Monday, November 8, 2010 2:10 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, October 13, 2016 11:37 AM
Points: 500, Visits: 424
It sounds like you're looking for a SSAS Design best practice. This link is for SSAS 2005 but it has a great deal of fundamentals to start from:

Star schemas a preferably a good start for a beginner if you're building a simple cube.
Post #1017460
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse