Oracle Analytics and AI

user8590399

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,

Gianni Ceresa

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).