Creating custom totals

Create custom totals for the GeneralLedgerTotal business class to return balances from the cube. The balances can be used in the source compute statement to calculate the allocated amount or used in the weight compute statement to create ratios.
  1. Select Processing > Allocations > Custom Total.
  2. Click Create.
  3. Specify this information:
    Custom Total
    Specify a name for the custom total.
    Description
    Specify a description for the custom total.
    Effective Date
    Specify the date the custom total goes into effect.
    Business Class
    Specify the GeneralLedgerTotal business class.

    You can specify any other business class to read totals from.

    Definition

    This field is populated as values are selected for each of the dimensions.

  4. To build the Definition field, select a value for each of the applicable dimensions displayed based on the balances to retrieve. The values assigned to each of the dimensions define the custom total address. The data returned is based on the custom total address. Specify a posting, summary, or node value or leave blank. The Definition field is populated when a value is assigned in any of the dimensions. If retrieving all balances for a dimension, specify a top node. This reads all balances for a dimension, including those with a blank value. If the Definition field value is blank, only the balances where the value for a dimension is blank are retrieved. Specify this information to define the custom total address:
    Scenario
    Select the type of transaction amounts to retrieve.
    • 1 = Total Obligations (rollup of 2, 3, and 4)
    • 2 = Actuals
    • 3 = Encumbrances
    • 4 = Commitments
    Accounting Entity
    Select the accounting entity to retrieve balances from.
    Currency
    Specify the currency balance you want to retrieve. Leave this field blank if you are retrieving the functional amount.
    Accounting Unit
    If accounting unit is part of the finance structure, you must specify a value for this dimension.
    Account
    Select the account to retrieve balances from.
    Project
    Select the project to retrieve balances from.
    User Dimensions
    Select a value for FinanceDimension1 through FinanceDimension10 as applicable.
    Period
    Select the period for which to retrieve the balance. This period must belong to the allocation calendar. Each global ledger calendar period in a calendar is uniquely identified by a prefix.
    Ledger
    Select the ledger to pull balances from.
    System
    Specify a system from which to retrieve balances from. Leave this field blank to retrieve all balances.
  5. Click Save.
    Test the connection. If zero is returned, then verify balances exist for the account in the cube by running account analysis.

    See Viewing an account analysis.

    If zero is returned by the account analysis, then try refreshing the cube.