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

Question

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

cesar.advincula.o · Answer

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,

Thomas Dodds · Answer

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!

[Deleted User] · Answer

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.