Essbase templates

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.

Optional: Click Choose dimension limits to select limits for the dimension to which the member belongs. Members—prompts the user to enter multiple members from a selected dimension in the application.

If you select Members, do these tasks:. Optional: Click Choose dimension limits to select limits for the dimension to which the members belong. Member range—prompts the user to enter a range of members from a selected dimension in the application. If you select Member Range, do these tasks:. Optional: Click Choose dimension limits to select limits for the dimension to which the member range belongs.

Restricted list—prompts the user to enter a member from a restricted list of members. If you select Restricted List, do this task:. Click User Input to define a restricted list of members. Select Prompt It? Select Mandatory if it is mandatory for users to enter information for the design time prompt. Select Read Only if users should read the prompt only and not enter information for it. In DTP Text , enter the text of the design time prompt.

If the design time prompt is a password, enter the password. In Default Value , enter or select a default value for the design time prompt. Click User Input to define the cross dimension selection.

Click Choose DTP as source to select an existing design time prompt. Oracle Analytics Cloud — Essbase can be accessed on an intuitive Web 2. You can easily create and share on-the-fly transient models or deliver enterprise-wide long-established databases. New agile forecasting functionality facilitates collaborative what-if analysis and modeling. A gallery of cube templates provided with Essbase helps you get started — see Exploring the Gallery Templates.

Oracle Analytics Cloud — Essbase is built on the Essbase platform. It leverages the best of the on-premises software and adds new functionality for the cloud. You can now increase the available size and complexity of your models, while reducing the complexity for deploying them.