TY / LY calculations, can it be done?

[Alfredomulet]

Hello everyone, this is my first posting to this group, sorry if it's been asked before, here is my question: is it possible and what would be the best way to do time series analysis TY / LY (this year last year calculations with BO Designer?

As far as I've found right now, there could be two options, first create a measure and add a WHERE clause to the definition like:

(to_number(to_char(FACT_TABLE.DATE,'YYYY')) - 1)

or to create a relationship table on the warehouse such as:

YEAR PREV_YEAR
2002 2001
2003 2002
2004 2003

and then (here is where I´m not sure) create a Previous_date object and filter the measure by it???? ...

I appreciate your comments,
cheers,

Alfredo

 

[skrandel]

This is best done at the universe level with a smart calendar. Log on to tech support and look for my conference presentaion from last year: Empowering End Users through Smart Universe Design.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com