OBIEE YTD difference calculation

Cameron Loepker

Version: Oracle Business Intelligence 12.2.1.3.0

Hello Board,

What would be the easiest way (formula) to calculate YTD difference from last year? is there an easy way to do this in the criteria tab?

thanks,

Cameron

[Deleted User]

Time series functions and properly formed time dimensions:

https://gerardnico.com/dat/obiee/obis/logical_sql/function_time

https://gianniceresa.com/2017/01/time-series-functions-why-how-what-where-obiee/

Cameron Loepker

Thanks!

[Deleted User]

Does this answer you question? You really shouldn't try to create weird functions yourself in the criteria tab like doing FILTER("Measure" USING YEAR("Date")-1) or other atrocities like that. That's garbage hacking of the worst sort and sadly extremely common.