Dimension Intersection Considerations

If you do not specify the dimension intersections from which Exp gets data and into which Exp places data, the source and destination intersections are determined by these factors:

  • Destination. If no member of the Intercompany partner dimension or of a Custom dimension is specified on the left side of the equal sign, Exp places data into each valid intersection of the account and the dimension. If you do not specify a destination account, Oracle Hyperion Financial Management will insert data into all accounts that are valid for the current point of view. See Simultaneously Setting Several Accounts.

  • Source. If a member of a dimension is not specified on the right side of the equal sign, there are several possibilities:

    • If a dimension has only one member, then Exp gets data from the intersection of this member and the source account.

    • If a dimension has only one valid intersection with the source account, then Exp gets data from this intersection.

    • If a dimension has several intersecting members with the source account, then the source intersection of the data is determined by the left side of the equation:

      • If a member is specified on the left side, then Exp attempts to get the data from the intersection of this member and the source account.

      • If a member is not specified on the left side, then Exp attempts to put data into each valid intersection of the destination account and the dimension’s members. Exp gets the data for the destination intersections from the corresponding intersections of the members and the source account.

        Note:

        If a source intersection is invalid, then Exp does not change the data in the corresponding destination intersection.

For detailed examples that illustrate these considerations, see Exp and Dimension Intersection Considerations.