Creating a Point of View Component

Note:

These components may be used in Oracle Essbase aggregate storage applications and Oracle General Ledger applications only.

You create Point of View component from within a business rule.

To create a Point of View component:

  1. In System View, right-click a rule, and then select Open.

    The business rule is displayed in the Rule Designer.

  2. After you determine where in the business rule's flow chart you want to create the Point of View component, from the New Objects Palette, drag the Point of View component and drop it into that location in the flow chart.

    The Point of View object is displayed as two circles with arrows inside them.

  3. On Point of View, enter a caption to identify the Point of View component. The caption is displayed above the component in the flow chart of any rule that uses it.
  4. Optional: Do one of these tasks to define the Point of View's global range:

    Note:

    If a global range is defined for the business rule for which you are creating the Point of View component, the Point of View tab displays the business rule's member selections by default. To see if a global range is defined for the business rule, select the Begin or End tab in the flow chart. Then click on the Global Range tab to see if any members, functions, or variables are defined.

    • Click Variable Selector to select or create variables to define the point of view. If you select a variable, you can select Link Variable Dynamically to ensure the variable is updated dynamically when changes are made to it.

    • Click Member Selector to select members to define the point of view.

    • Click in the row of a dimension in the Value column to type the names of members that define the point of view.

    • Click in the row of a dimension, click the Actions icon, and select one of these options to enter members:

      • Members (See Working with Members.)

      • Variables (See Working with Variables.)

        You can use a variable to fill the Point of View component. The variable must be defined at the database level and must be of the Member Range type.

      • Functions (See Working with Functions.)

        The functions you enter should return level 0 members only and should include an @ symbol before the function name. You can enter these functions:

        • @Level0Descendant

        • @Sibling

        • @UDA

        • @Attribute

        The Level0Descendant and Sibling functions require a member name as a parameter.

  5. To enter a comment for the members you select for a dimension, click Comment.
  6. Click Reset Grid to clear any entries you made to the grid.
  7. Click Save button.