November 2, 2009 at 1:07 am
I automatically generated a Time Dimension in SSAS. My Problem is, that the Year is of type datetime and I want to use this dimension in a fact table where I have a numeric year column. What is the common way to solve this?
1. Transform the numeric value to a datetime value
2. Don't use the generated Time Dimension
3. Other Way
Thanks for every tip
November 4, 2009 at 5:51 am
I use a char(4) field, but I manually created my own time dimension table, dtblCalendar, to manage my date information.
November 6, 2009 at 11:58 am
The general practice is to link the date key and use year, month, day or any other stuff would be used from Time dimension.
If you would like to link year to time dimension then you may create named calculation for the year type datetime in DSV for the table. IN that way you need not touch physical table.
If you have many fact tables like this then instead of adding to fact tables/tables it would be easier to add integer year to time table.
Based on your usage, you can freely customize.
Best of luck!
>Ravi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply