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

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 10:54 PM
Points: 10, Visits: 41
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.

Ta.
Post #983406
Posted Monday, November 8, 2010 2:10 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:35 AM
Points: 451, Visits: 324
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:

http://technet.microsoft.com/en-us/library/cc966399.aspx

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