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!

Month Ago issue

830309Jun 30 2014

Hi All,

I have a Fact column Month Ago Budget, which has formula AGO(Fact-Target.Budge,Dim-Time.Month,1) it is working fine when i select any month in a given year excet January.

i.e. If i select Jun-14 the i am getting May-14

but if i select Jan-14 it is not fetching Dec-13 's data.

in my Time Dimension(Dim-Time) Month is the lowest level.

Please let me know what could be the possible issue here.

Regards,

Arjun.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 28 2014

Added on Jun 30 2014

#11g, #bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #function, #obiee, #time

0 comments

149 views