1. Administering Financial Consolidation and Close
  2. Working with Dimensions
  3. Adding Custom Dimensions
  4. Aggregation Options

Aggregation Options

You can define calculations within dimension hierarchies using aggregation options. Aggregation options determine how child member values aggregate to parent members:

  • + Addition

  • - Subtraction

  • * Multiplication

  • / Division

  • % Percent

  • ~ Ignore

  • Never (do not aggregate, regardless of hierarchy)

Note:

For aggregation options for Intercompany Entities, see Aggregation Options for Intercompany Entities.

All immediate children of the dimension name member must be set with an aggregation option of Ignore or Never. Seeded dimension members should already have the Consolidation Operator set as Ignore. Use the top dimension member rather than the dimension name in forms and reports.

Financial Consolidation and Close has a consolidation script that performs the consolidation of one entity into another. Do not change the consolidation operator on Entities. If this Entity property is anything other than Ignore, the results are incorrect.

You can change the Consolidation Operator for seeded members of the Account dimension to customize them as needed. You can only change the members in the Consol cube. Ensure that you run Metadata Validation after making the changes to confirm that the changes are valid.

When you make changes to the seeded members, you cannot export or import them using a dimension export CSV file. You must use the Module Customization Migration artifact. Exporting and then importing CSV files will not retain your attribute changes for seeded members.

Label Only Members

The Consolidation Operator for Label Only dimension members must be Never. This has been set correctly for seeded Account and View Label Only members. If you create any custom Label Only Members, be sure to set the Consolidation Operator to Never, so that the members aggregate to parent members properly.

System Members in the Account Dimension

The Consolidation Operator is set to Never for all the system members in the Account dimension under FCCS_System Account, Exchange Rates, and FCCS_Drivers.