Skip to Content
avatar image
Former Member

12 month but devided into current and previous year

hi guys

i have this requirement to disaply amount for current period and previous period for 12 month.

Current period is the period of user entered year and previous period is previous year

So if user enter feb 2007 u2026Then current year is feb, jan ,dec 2006

And previous period is Nov 2006 to March 2006

user is entering the value 0CALMONTH ...and report to need to display 12 month internval betwen years. my problem is how to check the year and interval

please help me without any custom exit? can it be possible thru varibale?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 02, 2008 at 03:55 AM

    If you have 0CALQUARTER in your cube, It will be straight forward by offsetting Calender Quareter value by -1, -2 and -3 for last 12 months.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      hi

      i can easily display all 12 month period but my requirement is to calcualte within 12 month how many are curent and how many are previous years

      say user enterd march 2007 .....

      i need to calculate total amount for march 2007 to jan 2007 ...and dec2006 to april2006 separatly which will give me 12 month but 2 diferent years value ...

      i just need 2 column with 2 periods data as curent and previous