5 Replies Latest reply: Mar 20, 2013 7:47 PM by Kasyap RSS

    Time Series Functions

    ann 2012
      I have added a time series measure in RPD

      Year Ago Sales = AGO("Enterprise Analytics"."Facts Sales Fact"."Sales Le $" , "Enterprise Analytics"."Hierarchy Time"."Fiscal Year" , 1)

      If I pull 'Year Ago Sales' in Answers it takes forever to run it - ( 5-6 minute) - The result is correct.

      If I simply pull - "Enterprise Analytics"."Facts Sales Fact"."Sales Le $" - runs in 5 seconds.

      Is thier any way I can optimize the timeseries functions?

      Any response would be greatly appreciated!!

      We are on Oracle Business Intelligence 11.1.1.6.5 version.

      Edited by: ann 2012 on Mar 14, 2013 2:13 PM