7 Replies Latest reply on Feb 14, 2013 6:58 AM by 976632

# Quarter ago problem

Hi

my hierarchy is year-quarter-month

quarter values like q1-2011,q2-2011,q3-2011,q4-2011 like this
month values--jan-11,feb-11,mar-11 like this

by using ago function i calculate quarter ago

but it gives for q2-2012 it gives q2-2011

i neeed q2-2012 get q1 2012 values

ago function im using quater time dimension only

i ssort the quarter values based on quarter number still i didnt get that

• ###### 1. Re: Quarter ago problem
Hi
plz help
• ###### 2. Re: Quarter ago problem
Hi ARYABRAHMA,

When the time dimension's chronological key is incorrect, there would generally be issues during time series functions usage. So, just check your chronological key for the lowest level in your period hierarchy if was set properly or not.

Hope this helps. If you are still unable to get it, please post more details of your hierarchy design, the period dimension sample data.

Thank you,
Dhar
• ###### 3. Re: Quarter ago problem
Hi,

Can palce your ago function expression?

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

Ago("Sales"."Base Measures"."Dollars" , "Sales"."Time MonthDim"."Quarter" , 1)

For more refer,
http://gerardnico.com/wiki/dat/obiee/ago
http://docs.oracle.com/cd/E23943_01/bi.1111/e10540/dimensions.htm#BIEMG1409

Thanks
Deva
• ###### 4. Re: Quarter ago problem
Hi,

Let me know if it is resovled or not?
• ###### 5. Re: Quarter ago problem
Hi

i tried this way but same problem

for quarter ago i get previous year current quarter (

but i need previous quarter in the current year

how to find this

my ago function is
ago(amount,timedim.quarter,1)
• ###### 6. Re: Quarter ago problem
Hi,

To understand your period dimension better, post some sample data of it and also your current dimensional hierarchy in OBI.

Thank you,
Dhar
• ###### 7. Re: Quarter ago problem
Hi

my hierarachy is level based

year-quarter-month

values are

year-2000,2001,---

quarter---q1-2000,q2-2000,q3-2000,q4-2000----

month--jan-11,feb-11,mar-11,apr-11 --like this

for quarter ago i get previous year quarter

but that get previous quarter current year