Selecting alternate off-grid members

You can specify alternate off-grid members for some of the on-grid members. For example, the Version dimension on-grid, with Actual and Budget numbers. You want the Actual member to use the current year values from the Period dimension, while the Budget member uses the next year's values.

  1. On the Dimensions tab, in the AOGM group, click the AOGM button.
  2. Select the on-grid member from the list on the left.
  3. Select a dimension and member to be the alternate off-grid member from the list on the right.
  4. Click Add.
  5. Click OK.
  6. Click Save Changes.

General information

  • Column definitions take precedence over row definitions.
  • Innermost members take precedence over outermost members.
  • AOGM is evaluated for each dimension.