Aller au contenu principal

Financial dimension sets

The Financial dimension sets configuration allows you to define specific combinations and strict orderings of financial dimensions. These sets are subsequently utilised across various analytical reports and ledger inquiries (most notably the Trial balance) to dictate precisely how financial data is aggregated and presented.

By constructing multiple dimension sets, you empower users to analyse the identical core ledger data from disparate business perspectives—for example, viewing balances primarily by Main Account -> Department versus analysing exclusively by Department -> Cost Center.

Prerequisites​

  • Financial dimensions (You must have active dimensions configured before they can be assigned to a set).

Creating a financial dimension set​

  1. Navigate to General ledger > Dimensions > Financial dimension sets.
  2. Select New from the Action Pane.
  3. In the Financial dimension set field, enter a concise, unique identifier (e.g., MA+DEPT+PROJECT). It is highly recommended to use a standard naming convention that reflects the set's composition.
  4. In the Name field, provide a comprehensive description articulating the set's reporting purpose (e.g., Main Account, Department, and Project dimension set for comprehensive reporting).

Configuring the dimension hierarchy​

The core utility of a financial dimension set lies in its selected dimensions and their specific order. The sequence dictates the grouping hierarchy applied in subsequent reports.

  1. Expand the Financial dimensions FastTab.
  2. Review the Available financial dimensions list (which displays all dimensions configured in the system).
  3. Select a dimension and click the Right Arrow button to move it into the Selected financial dimensions list.
  4. Repeat this process for all dimensions required for your specific reporting view.
  5. Critically, utilise the Up Arrow and Down Arrow buttons adjacent to the Selected list to arrange the dimensions into the desired hierarchical sequence.
    • Note: The topmost dimension represents the primary grouping level on your reports.

Utilising financial dimension sets in reporting​

Once configured, financial dimension sets automatically become available as primary parameters in various Ledger reports.

As an example, when generating a Trial balance:

  1. Navigate to General ledger > Reports > Trial balance.
  2. Within the Report parameters section, locate the Financial dimension set dropdown.
  3. Select your newly created set (e.g., MA+DEPT+PROJECT).
  4. Upon clicking Calculate balances, the resulting financial inquiry will instantly aggregate and group the ledger balances exactly according to the dimensions and hierarchical sequence defined within that set.