Cube Designing

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.

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.