Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Want to get the next month in a Calculation.

862959May 24 2011 — edited Jun 2 2011

Hi Experts,
I am trying to get the next month in the BR. There is a Run-Time prompt for the month. Now What I want is that whatever he gives input in the prompt, I want to take its next month like :- If Run-Time prompt is [month] , And now user enter input as Mar. My requirement is that I want to use the next month in my calculation i.e Apr.Something like FIX(@next[month]:Dec]

Could you please help in this , I have tried functions like @NEXTSIBLING or @SHIFTSIBLING, these are working fine but in case of the last month of quater like for March,June,Sep,Dec. its not working as its not able to get next month which is in other Quater.

My hierarchy is like that :-
QTR1 - Jan,Feb,Mar
QTR2 - Apr,May,Jun
QTR3- Jul,Aug,Sep
QTR4 -Oct,Nov,Dec

It will be really very helpful fot me..Please provide me somekind of solution.Thanks

Regards.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 30 2011

Added on May 24 2011

#business-intelligence-applications, #epm, #epma, #essbase, #hyperion, #performance-management-applications, #planning, #planning-and-budgeting

6 comments

457 views