Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
YTD,MTD without using Time series Function in OBIEE 11g
Hi,
I want to calculate YTD, MTD & year ago YTD for a measure. The issue is I cant use Time series function as the current data model do not support me for defining chronological key.
Is there any alternative way to calculate YTD and Year ago YTD?
Thank's
San
Answers
-
It sounds like you know the ideal and probably the only solution is to set up your date dimension with hierarchical levels and you get the time series functionality for "free".
Anything else will be difficult to implement and will give you lots of issues down the line.
0 -
2769228 wrote: Is there any alternative way to calculate YTD and Year ago YTD?
Short answer: Don't.
Longer answer: Don't bother. Anything else is just going off into the wrong direction without any proper added benefit and will cost you a LOT more effort and performance plus it won't even be reusable.
0 -
The only way to do it non-logically is to have a physical snapshot table that reflects the To-Date value as of last ETL run ... as mentioned - a lot more work with no added benefit!
0 -
Hello,
So if you cant apply crhonological key, maybe you could use analytics functions, to use it, you have to use the "EVALUATE" functions, check if your obiee its enable it.
Kind Regards,
0
