Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 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