Hyperion Essbase (MOSC)

MOSC Banner

Calculation Script

edited Feb 27, 2012 2:45AM in Hyperion Essbase (MOSC) 2 commentsAnswered
How do I write a calc script that will take "Total SGA", a parent account, and allocate it by a percent to another level 0 account, by department, entity, month, etc...   What this is doing is populating as a % different from the % in ALLOCATION_PCT.

FIX("Jan":"Dec",&BudYr,"System","Dollars","Input","79400", "100","6100","Budget")
      UHC = ("Tot_SGA_Exp_Less_Const_&_Dontn" -> "AMC" -> "000") * 
                 ("ALLOCATION_PCT" -> "100" -> "BegBalance");
ENDFIX

79400 is the level 0 account.
100 is the level 0 line of biz.
000 is the level 0 line of biz.
2150 is the level 0 department
AMC is the level 0 entity

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