Data Source Views

  • 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.

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

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