Cube Designing

View previous topic View next topic Go down

Cube Designing

Post  Tridip on Tue May 08, 2012 8:27 am

Hi,
While designing data source view in SSAS we are combing(Joining) fact and dimension table using T-sql and using it as a single fact.
Is it a correct design approach that we are joining FACT and Dimension using T-sql and using it as a Fact in the DSV of cube.
e.g,If I have Fact Internet sales and DimDate table then we are joining DimDate and Fact Internet sales using T-sql(for some reason) and using the result as a fact in Datasource view.
Please suggest.

Tridip

Posts : 1
Join date : 2012-05-02

View user profile

Back to top Go down

Re: Cube Designing

Post  Lindell on Wed May 09, 2012 8:07 am

Hello there.

Short answer, no it's not the correct design approach. Use the DimDate keys in facttable and reference it to the fact and let the cube do the joining and aggregations cause it will make it faster, smaller and easier to maintain.

Lindell

Posts : 6
Join date : 2011-08-02

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum