Defining Limits for Design-time Prompts

Note:

Custom templates and design-time prompts are supported in Oracle Hyperion Financial Management, Oracle Hyperion Planning, and Oracle Essbase Block Storage applications.

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:

1. In System View, create or open a custom-defined template.
2. On the Design Time Prompt tab, click , and select where to insert the row.
3. 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.

4. 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.

5. Click OK, and then (Save button).