To roll up upper-level entities (for example, Division on the page drop-down of the data form 8. Headcount and FTE), create a new business rule similar to the predefined Rollup business rule and associate it with the data form. In the new business rule, include an additional rollup of the Entity dimension. If your application is multicurrency, create a new rule in Oracle Essbase Administration Services, copy and paste the following text, then save the new business rule:
SET AGGMISSG ON;
FIX ([Scenario], [Version], [Year], "Local", "HSP_InputValue")
CALC DIM ("Account", "Period", "Employee", "Entity");
ENDFIXNote: | If your application uses a single currency, remove “Local” from the FIX statement. If you renamed dimensions, the CALC DIM statement should list those dimension names instead. |
Run the Rollup business rule instead of the Calc Data on Form calc script on Workforce Planning data forms that contain accounts with member formulas (such as 7. Employee Expenses Summary form, or 8. Headcount and FTE form). These data forms already have the Rollup business rule associated with them. For customized data forms, you may need to associate this rule with the data form during data form design.