Defining Dependencies 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.

You can define inclusive and exclusive dependencies for cross dimension, dimensions, dimension, member, members, and member range design-time prompts. If you designate a prompt (for example DTP1) as inclusive of another prompt (for example DTP2), when a user is prompted for DTP1, only the dimensions from DTP2 will display. If you designate a prompt (for example DTP3) as exclusive of another prompt (for example DTP4), when a user is prompted for DTP3, only the dimensions that are not used in DTP4 will display.

Note:

Design-time prompts can only be inclusive or exclusive of the design-time prompts that come before them in the design-time prompt grid, so the order of the design-time prompts is very important.

To define dependencies:

  1. In System View, create or open a custom template.
  2. On the Design Time Prompt tab, click Add button, and then select one of these types:

    • Cross Dimension

    • Dimension

    • Dimensions

    • Member

    • Members

    • Member Range

    • UDA

  3. On the Dependencies tab, select a design-time prompt, and then select a dependency option:

    • Exclusive—Makes the design-time prompt (for example, DTP2) exclusive of another design-time prompt (for example DTP1). When you are prompted for DTP2, only the dimensions that are not used in DTP1 are displayed.

    • Inclusive—Makes the design-time prompt (for example, DTP4) inclusive of another design-time prompt (for example, DTP3). When you are prompted for DTP4, only the dimensions that are used in DTP3 are displayed.

    • None—No dependencies are defined for the design-time prompt.

  4. Click OK, and then Save button.