Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
MTD without Time dimension in OBIEE

Hi All,
I have time dimension defined as Year ,Quarter, Week, Day.
I want to create MTD for a metric. Since Month is not present in the hierarchy, I cannot use TODATE function to create MTD.
Is there any other alternative ?
Note: Lets say for April'16 there are 5 weeks. I can pass any week from the prompt , and MTD should calculate till that particular week.
Regards,
Answers
-
Hi,
Why isn't month part of you time dimension?
If you want to do month-to-date analysis the simplest way is to just add the month to the time dimension have model it as an alternate hierarchy in OBIEE (because weeks and months don't have a direct parent-child relation, even if it looks your weeks are strange as a week can also be split between 2 quarters but you seem to have quarter as parent of the weeks...).
You can also model it directly in the RPD by doing some date calculation on the Day (I guess it's your key).
0