This discussion is archived
5 Replies Latest reply: Apr 18, 2013 2:42 AM by Arrun RSS

Past Three Months data

Arrun Newbie
Currently Being Moderated
Hi,
I need to display the past three months' data, may be using a filter or function in Oracle BI Answer. Is there anyone who can help me with this? Your solution will be highly appreciated!

Thank You,
Aru
  • 1. Re: Past Three Months data
    JaiG Pro
    Currently Being Moderated
    Use the Timestampadd function along with the date column you have and you should get what you need. Here are a couple blog posts for pointers on how to use the function:
    http://www.varanasisaichand.com/2010/11/timestampdiff-and-timestampadd.html
    http://shahin-obiee.blogspot.com/2012/04/various-calculations-for-date_16.html

    Please award points if helpful/correct.
  • 2. Re: Past Three Months data
    Arrun Newbie
    Currently Being Moderated
    Hi Jai,


    I have an issue with the AGO function.
    I have used a formulae some thing like below.

    Ago("XXX"."X" , "YYY"."Y"."Month" , 3)

    Similarly like for month 2 and month 1.Well the point is I need a ytd bal for the prev 3 months and current month too.
    When I pass the filter as APR-2012 im getting data for APR-12,MAR-12,FEB-12,JAN-12 But
    When I pass the filter as MAR-2012 im only getting data for MAR-12,FEB-12,JAN-12 but could not get data for DEC-11

    Please help me out

    Thanks,
    Arun

    Edited by: Arrun on Mar 15, 2013 4:30 AM
  • 3. Re: Past Three Months data
    Sasi Nagireddy Expert
    Currently Being Moderated
    Which version ur using?

    If it is 11 we have period rolling time series function right.You can go with that.

    PERIODROLLING(Measure,Starting Period offset,Ending Period Offset)

    Do let me know for the updates?

    Thanks.
  • 4. Re: Past Three Months data
    Sasi Nagireddy Expert
    Currently Being Moderated
    Can u close the thread if it is answered.

    Thanks.
  • 5. Re: Past Three Months data
    Arrun Newbie
    Currently Being Moderated
    Hi Nagireddy,

    Starting Period and Ending period should dynamically change.
    I cannot pass the starting value as X and Ending value as Y

    Thank You,
    Aru

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points