Hyperion Planning (MOSC)

MOSC Banner

How to calculate multiplication with complex dimensions?

edited Oct 30, 2014 2:12PM in Hyperion Planning (MOSC) 14 commentsAnswered ✓

Dear all,

I have an issue about multiplication in Calculation Manager.

I want to calculate required materials quantity for manufacturing. Formula is given below:

RM_RequiredQuantity = FG_WIPQuantity/ 1000 * RM_EstimatedQuantity

with:

RM_RequiredQuantity: required material quantity for manufacturing

FG_WIPQuantity: production quantity of Finish Goods

RM_EstimatedQuantity: estimated material quantity per unit of product

And 3 members above are child members of Statistical, Account Dimension

I have 3 forms:

  • Form A is used to enter FG_WIPQuantity
  • Form B is used to enter RM_EstimatedQuantity
  • Form C is used to calculate RM_RequiredQuantity

POV, Page and Row & Column are designed for 3 forms

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