Hyperion Planning (MOSC)

MOSC Banner

How to manage calculation within account dimension where calculation is quantity * rate = value

edited Sep 15, 2014 6:52AM in Hyperion Planning (MOSC) 2 commentsAnswered ✓

Hi

There are members in account dimension where calculation is quantity * rate = value.  (Apart from this, other dimensions such as period, entity, version, scenario etc also co-exist)

Account

  Expenses

       Exp 1

       Exp 2

       Exp 3

            Exp 3.1

            Exp 3.2

            Exp 3.3

Calculation of Exp 3.1 to 3.3 is managed by quantity * rate. How do we achieve this calculation.

One way is to create two more children whose calculation is multiplication. But we've 200 such members (3.1 to 3.200). It'll create 400 rate, quantity sub-members. In addition, it'll not be possible to analyse rate or quantity in isolation. So managing this way won't be efficient method of calculation.

For this example, it is as if Exp 3 is product dimension and quantity, rate, value are part of account dimension

Tagged:

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