Categories
- All Categories
- 94 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14.2K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 53 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations Gallery
- 2 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Time Series (AGO)is not working in BICS
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.
Answers
-
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
0