1. Designing with Calculation Manager for Oracle Enterprise Performance Management Cloud
  2. Working with Custom Templates
  3. Creating a Custom Template
  4. Creating a Graphical Custom Template
  5. Example of Creating a Graphical Template that Uses an UpperPOV Design-Time Prompt

Example of Creating a Graphical Template that Uses an UpperPOV Design-Time Prompt

The following steps show you how to create a graphical template that uses an UpperPOV design-time prompt. The steps in this example use the sample Planning application.
  1. In System View, right-click Templates, and then select New.
  2. In New Custom Defined Template, enter the requested information, and then click OK.
  3. In the Design Time Prompt tab, click Add button, and then select Insert Row at End.
  4. In the Create Prompt dialog box, do the following:
    1. In the Properties tab, enter the following information:

      • Name—Enter "MR1".

      • Type—Select "Member Range"

      • Select Prompt It?

      • DTP Text—Enter a member range

    2. In the Dependencies tab, click the drop down for UpperPOV, and then select Exclusive.
    3. Click OK.
  5. In the Template Designer flow chart, drag in a member range component.
  6. In the Member Range tab, click Variable Selector button.
  7. In the DTP Selector dialog box, select the "Member Range" design-time prompt created in Step 4, then click OK, and then verify that Link Variable Dynamically is selected.
  8. Create a step in the template, and then add a new DTP named "MR1" to the step.
  9. Save the template.
  10. In a rule, drag in a member range, and then enter members for "Entity" and "Product".
  11. Drag the new graphical template into the member range in the rule.

Notice the step for the member range type DTP is displayed, and notice that the "Entity" and "Product" dimensions are not displayed. This is because we made the DTP of type member range exclusive of the UpperPOV, and the UpperPOV (the member range we dragged into the rule) is using the dimensions "Entity" and "Product".

If you change the dependency on the DTP of type member range to inclusive, in the rule, only the dimension "Entity" will be displayed, and in the template’s step, only the dimension "Product" will be displayed.

You can also use the UpperPOV system DTP in a graphical template in a DTP condition to determine if the UpperPOV has members (Is Not Empty) or does not have members(Is Empty), and if there is a member range component in which the template has been dragged (Is Available), or not (Is Not Available)