YTD,MTD without using Time series Function in OBIEE 11g

2769228

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

Joel

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.

[Deleted User]

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.

Thomas Dodds

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!

cesar.advincula.o

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,