Hyperion Essbase (MOSC)

MOSC Banner

MDX - for level zero I want the calc but for upper level members do the normal aggregation

edited Jan 16, 2012 3:51AM in Hyperion Essbase (MOSC) 8 commentsAnswered
This is my OnHandRCalc account MDX.

CASE  WHEN IsLevel(Date.CurrentMember, 0)  THEN
CASE WHEN Date.CurrentMember = [&NextDay] THEN 0
ELSE
CASE WHEN IsUda(Date.CurrentMember, "FDOM")  THEN
IIF ([Buying Status-Discontinued]>0,
[OHR_Seed_New_Input] - SLSR + NTRECR + SHRR + TRANSR - DSTR - DSCR - NETMDCLRR - NETMDOTHR,
[OHR_Seed_New_Input] - SLSR + NTRECR + SHRR + TRANSR - DSTR - DSCR - NETMDCLRR - NETMDOTHR - NETMDPROR
)

WHEN NOT IsUda(Date.CurrentMember, "FDOM") THEN
IIF ([Buying Status-Discontinued]>0,
([OnHandRCalc],Date.CurrentMember.PrevMember) - SLSR + NTRECR + SHRR + TRANSR - DSTR - DSCR - NETMDCLRR - NETMDOTHR,
([OnHandRCalc],Date.CurrentMember.PrevMember) - SLSR + NTRECR + SHRR + TRANSR - DSTR - DSCR - NETMDCLRR - NETMDOTHR - NETMDPROR

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