Time Series (AGO)is not working in BICS

User_CEU9I

Hi all,

I am unable to perform time series functions (AGO) for MTD, YTD. It's throwing an error. Please see the attached test scenario for the details.

I am using Oracle transportation intelligence on cloud service instance(6.4.1) version. I am working on cloud and don't have access to RPD.

I have to perform YTD and MTD at analysis only.

Please let me know how solve this error?

Regards,

Ram.

P G

Hi

I have checked your attached file. But you was written wrong Formula.

AGO Syntax:

Ago(<<Measure>>, <<Level>>, <<Number of Periods>>)

<<Measure>> represents the logical measure column from which you want to derive.

<<Level>>  you select the Specific level from the Time logical dimension / Hierarchy.

<<Number of Periods>> is the size of the offset, measured in the grain you provided in the <<Level>> argument.

In <<level>> you need to add hierarchy level.

Eg. Ago("Base Fact"."Revenue","Time"."Time Hierarchy"."Year",1)

also Check this link.

http://www.vlamis.com/blog/2011/6/17/doing-time-series-calculations-in-answers-11g.html

http://obieeil.blogspot.in/2013/08/obiee-and-time-series-calculations-in.html