You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

units * price in FCCS

Accepted answer
31
Views
6
Comments

I'm familiar with Essbase and Planning but now I'm struggling with the setup up a units * price mechanism in FCCS. Both units and price are inputs, the revenue total should come out. This is a management reporting structure, in the main legal section we import the revenue (but more condensed).

What would be the best practice for a setup?

I started with the classic Essbase setup via the Dimension Account with 2 children and 1 parent: Price -> Going as addition to Total Level , Units -> going up with a multiplication.

Works ok but ..

  • My price should go to average when aggregating up the dimensions, including time. But now my prices are simply adding up. How can I achieve this? There is no Average option anywhere available in the line setup. When drilling up, my revenue is obviously wrong because of no average price being used.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!