Defining Dimension Limits for Cross Dimension, Dimension, Dimensions, Member, and Member Range Design Time Prompts (Financial Management, Planning, and Essbase Block Storage Application Users Only)

When you create a cross dimension, dimension, dimensions, member, or member range design time prompt for a custom defined template, you must specify whether you want the prompt to display for dense and sparse dimensions, dense dimensions only, or sparse dimensions only.

  To select the type of dimensions for which cross dimension, dimension, dimensions, member, or member range design time prompts should display:

  1. In the System View, expand the Financial Management, Planning, or Essbase application type, the application, the calculation type (for Financial Management), the plan type (for Planning), or the database (for Essbase), and Templates.

  2. Right-click the custom defined template for which you want to create limits, and select Open.

  3. In the design time prompt table, select one of these design time prompt types:

    • Cross Dimension

    • Dimension

    • Dimensions

    • Member

    • Member Range

  4. In the column to the right of the Type column, click the Choose Dimension Limits icon.

  5. In Define Dimension Type, select one of these options:

    • Show Sparse: to display only sparse dimensions

    • Show Dense: to display only dense dimensions

    • Both: to display both dense and sparse dimensions

  6. Click OK.

  7. Select File, Save.