Data source types: Planning
Note: | For detailed information about spreading data, see the Oracle Hyperion Planning User's Guide. |
In Excel, you can spread, or distribute, values in several ways:
Spread the value of a summary time period to its base time periods or to the first parent or first child of the parent time period
Spread values among children and parents proportionally, based on existing distribution
Spread values based on the weekly distribution of a quarter, which could be 4-4-5, 5-4-4, 4-5-4, or None (as set up by the budget administrator)
Temporarily lock the values of certain cells while spreading data over time periods
You cannot spread data in a summary time period that includes members with mixed currency types.
Note:
Excel formulas in child cells are ignored during spreading.
To spread data for time periods: