- Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
- Working with Custom Templates
- Creating Design-Time Prompts for Custom Templates
- Defining Limits for Design-time Prompts
Defining Limits for Design-time Prompts
When you create a cross dimension, dimension, dimensions, member, members, or member range design-time prompt for a custom template, you must specify whether you want the prompt to display for dense and sparse dimensions, dense dimensions only, or sparse dimensions only.
To define limits:
- In System View, create or open a custom-defined template.
-
On the Design Time Prompt tab, click
, and select where to insert the row.
-
In the Create Prompt dialog box on the
Properties tab, select one of these options in
Type field:
-
Cross Dimension
-
Dimension
-
Dimensions
-
Member
-
Members
-
Member Range
-
UDA
When you select one of these options, a Define Limits tab is displayed.
-
-
On the Define Limits tab:
-
In Density, select an option:
-
Show Sparse—Displays only sparse dimensions for the DTP
-
Show Dense—Displays only dense dimensions for the DTP
-
Both—Displays both dense and sparse dimensions for the DTP
-
-
In Dimension Type select a dimension type to restrict the design-time prompt to show only the selected dimension types.
For example, if you only want users to enter a member for Account, Entity, and Year, then select these dimensions in Dimension Type. When users are prompted for input, the only dimensions that will show are those with type Account, Entity, and Year.
-
-
Click OK, and then
(Save button).