6 Replies Latest reply: Sep 16, 2013 5:41 AM by Thanos A RSS

    scripting: How to retrieve the value for next year

    1037569


      Hi Experts,

       

      Need help on HFM rules for retrieving the next year value

       

      Specificationt: Financial year values start from Apr to Mar

       

      I am bale to retrieve the values from Apr to dec, when trying to retrieve for Jan and mar getting the wrong values

      using : A# xxx.C1#xxx.y#cur

       

      please suggest your comments

      Thanks,

      SSr

        • 1. Re: scripting: How to retrieve the value for next year
          HFM_CZ

          Did you try using Y#Next to retrieve next year value?


          See page 264: http://docs.oracle.com/cd/E40248_01/epm.1112/hfm_admin.pdf

          • 2. Re: scripting: How to retrieve the value for next year
            1037569

            Hi,

             

            Still getting the wrong values

             

            FYear start from April to Mar

             

            For ex:

            2012                                                                                    2013

                      apr     may     jun     jul     aug     sep     oct     nov     dec   jan     feb     mar
                      1        1            1     1       1        1         1        1        1       1       1        1

            YTD

            OT     1          2          3      4       5        6        7        8        9     10     11     12

             

            Thanks,

            Ssr

            • 3. Re: scripting: How to retrieve the value for next year
              Thanos A

              Hi Ssr,

               

              Can you give us more details... I cannot understand your issue...

              • 4. Re: scripting: How to retrieve the value for next year
                1037569

                Hi,

                 

                Using the below script for getting the YTD values

                 

                If Hs.Period.Number()=1 Then

                HS.EXP "A#xyzYTD.C1#abc.c3#Calc = A#xyz.C1#abc.c3#Calc.w#PEriodic.P#Apr

                .

                .

                .

                HS.EXP "A#xyzYTD.C1#abc.c3#Calc = A#xyz.C1#abc.c3#Calc.w#PEriodic.P#Apr+...........A#xyz.C1#abc.c3#Calc.w#PEriodic.P#Jan.Y#

                HS.EXP "A#xyzYTD.C1#abc.c3#Calc = A#xyz.C1#abc.c3#Calc.w#PEriodic.P#Apr+...........A#xyz.C1#abc.c3#Calc.w#PEriodic.P#Feb.Y#

                HS.EXP "A#xyzYTD.C1#abc.c3#Calc = A#xyz.C1#abc.c3#Calc.w#PEriodic.P#Apr+...........A#xyz.C1#abc.c3#Calc.w#PEriodic.P#Mar.Y#

                 

                Getting the Perfect values from Apr to dec, but when trying to retrieve for Jan and mar getting the wrong values

                 

                Thanks...

                • 5. Re: scripting: How to retrieve the value for next year
                  1037569

                  Hi All,

                   

                  finally Got the solution

                   

                  HS.EXP "A#xyzYTD.C1#abc.c3#Calc = A#xyz.C1#abc.c3#Calc.w#Periodic.P#Dec.y#Prior +...........A#xyz.C1#abc.c3#Calc.w#PEriodic.P#Jan

                  Thanks for All...

                  • 6. Re: scripting: How to retrieve the value for next year
                    Thanos A

                    Hi,

                     

                    I was about to say that the year is the issue but you were faster. Your "problem" starts from the issue that you are using two different HFM years in order to input data for one Calendar year....

                     

                    2012 to 2013 for 2013 calendar year

                    2013 to 2014 for 2014 calendar year

                     

                    If this is a new app, I would suggest to change your approach to

                         2014 to 2014 for 2013 data

                         2015 to 2015 for 2014 data

                     

                    In this way, your calculations will not get "confused by the change of the year.

                    Regards,

                     

                    Thanos