Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OBIEE YTD difference calculation
Cameron Loepker
Rank 4 - Community Specialist
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
0
Answers
-
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/
0 -
Thanks!
0 -
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.
0