units * price in FCCS
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.
Tagged:
0