Cube buiding question.....

[ema15]

I am building a cube using MS Analysis Services from MS SQL Server. I have a table with fields: SalesmanID, CustomerID, ProductID, DeliveryDate and SalesQuantity. And I am using this table directly as a fact table. My question is how I can create Time dimension? Can I just create a view from the same table like:
Select DeliveryDate,
Year(DeliveryDate) as Year,
Month(DeliveryDate) as Month,
Week(DeliveryDate) as Week
from MyTable
and link to fact table by DeliveryDate field and use that view as Time dimension? Please Help!!!

 

[Shab]

My guess is that it will work. However it is a good idea that you create a new table with your delivery date, The_day, the month and the year as three columns and add another Time_id column (identity). So this time_table will have four columns.
Then update the mail table you have with time_ids instead of dates.

Hope it helps,

Shab