7 Replies Latest reply: Feb 14, 2013 12:58 AM by 976632 RSS

    Quarter ago problem

    976632
      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


      please help for this
        • 1. Re: Quarter ago problem
          976632
          Hi
          plz help
          • 2. Re: Quarter ago problem
            Dhar
            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
              user248025
              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
                Sasi  Nagireddy
                Hi,

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

                  thank you for ur reply

                  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
                    Dhar
                    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
                      976632
                      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

                      please see this