• I personally wouldn't build views for dims/facts over the staging tables. I'd use SCD2 design and create a proper warehouse. The SSAS then just sits on top of that. You call whichever makes the most sense for the report when you build it.

    Running views to make dim/facts only really works for small data loads which you don't need the warehouse for in the first place. The indexing in a warehouse is very different, which is why you reorganize all the data in the first place.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA