Creating your own time dimensions in transformer 1

[collierd]

Does anybody know how to create specific time dimensions in transformer, other than those created with date wizard
More specifically I want to create dimensions with rolloing years, i.e 3 years data which in 2002 assesses 2002 vs 2001 vs 2000 rather than 2001 vs 2000 vs 1999 and just post everything else as late
Also, I am looking to change the default year dimension to look at current month, then current less 1 and so on rather than jan to dec

Thanks,

Damian

 

[ADB1]

We have a calendar table on our database which holds data with respect to actual date, week number, day name, month name, year etc etc then we can link this to any other date on any other database table (using the actual date column in calendar) and use it as the basis for any date dimensions or calculations. The calendar table itself contains years of data from past and for future.

 

[Brad123]

You can also use an excel spreadsheet to build your data dimension. We have a template that we use where we type in the last date that we want to see in the dimension and excel fills in the values for the previous n years and calculates all of the custom date information (i.e. quarter) that we need.

This has helped greatly, especially if you don't want to create a seperate table.

Hope this helps!

Brad

 

[goldsmt]

Click on date dimension
Click on show diagram button
Posiotion curson over the All Years lable on left hand side of diagram
Click and hold left mouse button, drag line under other special date dimension
Name dimensions, ie last 3 years etc
Select relative time box to custom
select N period running total as basic approach
Enter number of periods as 3
Select target period as year - leave offset as 0


this will provide the running 3 years

for months repeat the sequence above, but target perion as month and number of periods as 12, you can experimenrt with the target offset, ie, 0 will show you the last 12 months including current month, -1 will show the last 12 full months.

Regards

tony Goldsmith