Essbase formula at aggregated period level
SummaryEssbase formula at aggregated period level
Is it possible to enter data at base period members(Jan,Feb etc) and calculate using a formula at aggregated period members(Q1,Q2, etc)
Account and period are dense in my database
Jan Feb Mar Q1
A1 100 200 100 400
A2 .1 .1 .2 .125 (Calculated)
A3 10 20 20 50
In the above example, A2 is an entry field for Base periods, but it should be calculated at aggregated period level.
Please suggest a way to achieve this.