Hyperion Planning (MOSC)

MOSC Banner

Using PRIOR/XRANGE with cross-dim (fails when crossing years)

edited Oct 7, 2019 8:01AM in Hyperion Planning (MOSC) 5 commentsAnswered

I have a dynamic calc member called AAFPU_BOP with the following member formula:

@PRIOR("AAFPU_EOP"->"SalesChannel_Total",,@REMOVE(@XRANGE(&PrevYear->"Jan",&Y2->"Dec"), &PrevYear:&Y2->"BegBalance"));

I want the member to be populated with the previous month AAFPU_EOP->SalesChannel_Total. This works for all months except January where it ignores the cross-dim SalesChannel_Total. Why is this and how can I fix it?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center