All system templates are available as wizards in Calculation Manager. Working with system templates in a wizard makes the templates easier to use in a business rule, and reduces potential calculation script syntax errors.
The design time prompts available in system templates are filtered based on the choices you make when following the wizard. For example, the Aggregation system template displays a step for selecting dense dimensions to aggregate, but if there are no dense dimensions available for aggregation, there are no dense dimensions to select from the dropdown list in the step. This can happen when all of the dense dimensions are used in the upper FIX statement.
The template can detect what dimensions are used in the member range of the business rule into which you drop it. For example, if you drop an aggregation template into the member range of a rule, and if this member range includes all dense dimensions, the step for dense dimension aggregation in the template is not displayed. This prevents calculation script errors, since Essbase scripts do not allow aggregation of a dimension within a FIX statement when this dimension is already used. For example, if, in a business rule, the member range is made of children (YearTotal), the aggregation on period is not allowed.
If you include a system template in an upper member range, the system template can detect this. If a system template is dropped into a member range component (that is, a Fix statement), which implies that the dimensions used in that member range should not be used in a formula, then these dimensions are not displayed in the wizard. This reduces the potential for calculation script syntax errors when you are using system templates. For example, if the Allocate system template is used in a member range component that is made of entities, then the Entity dimension is not displayed as a dimension in which an allocation can be performed.
Calculation Manager includes these system templates for Planning and Essbase block storage applications:
Clear Data template: enables you to delete data from a location in the database. You may want to clear data before you allocate it. See Using the Clear Data Template in a Business Rule (Planning and Essbase Block Storage Users Only).
Copy Data template: enables you to copy data from one location in the database to another. See Using the Copy Data Template in a Business Rule (Planning and Essbase Block Storage Users Only).
Amount–Unit–Rate template: enables you to enter any two of three variables and calculate the third variable. For example, if you enter the rate and units of an item sold, Calculation Manager calculates the amount of the item. See Using the Amount–Unit–Rate Template in a Business Rule (Planning and Essbase Block Storage Users Only).
Allocate Level to Level template: enables you to distribute data that is aggregated from members at multiple levels in the database outline. See Using the Allocate Level to Level Template in a Business Rule (Planning and Essbase Block Storage Users Only).
Allocate Simple template: enables you to distribute data from members at one level in the database outline. See Using the Allocate Simple Template in a Business Rule (Planning and Essbase Block Storage Users Only).
Aggregation template: enables you to generate an optimized script for aggregating dimensions according to their density. Dimensions can be aggregated fully or partially and aggregated to descendants, children, or ancestors. See Using the Aggregation Template in a Business Rule (Planning and Essbase Block Storage Users Only).
Export-Import Data template: enables you to export data from, or import data into, a location in the database to a file or to a table in a relational repository. It also enables you to import data that you exported previously using the binary file option. See Using the Export-Import Data Template in a Business Rule (Planning and Essbase Block Storage Users Only).
SET Commands template: enables you to enter script commands that optimize the performance of calculation scripts. You can include data volume, data handling, memory usage, and threading and logging script commands. See Using the SET Commands Template in a Business Rule (Planning and Essbase Block Storage Users Only).