Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calculating To Date functions manually without Time series function

933203May 9 2013 — edited May 9 2013

Hi,

Below is my requirement.

We have a measure column (Ship To Budget Amount). The lowest grain level for this measure is at Month level and not day level.

So now my client wants this measure to be calculated both YTD and AGO. But since this measure is not at day level(Start_dt and End_dt) i am unable to use To date and Ago functions.

Hence i need to calculate it manually. Can some one please help me by telling how to achieve this.

Can we write any function/formula to get the to date and ago values.

Your help is deeply appreciated and will be marked asap.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 6 2013

Added on May 9 2013

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

145 views