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. The balances can also be used in the weight compute statement to create ratios.
  1. Select Processing > Allocations > Custom Total.
  2. Click Create.
  3. Specify this information:
    Business Class
    Specify the GeneralLedgerTotal business class. You can specify any other business class from which to read totals.
    Definition
    This field is automatically filled as you select values for each of the dimensions.
  4. Build the definition field.
    1. Select a value for each of the applicable dimensions based on the balances to retrieve.

      The values that are assigned to each of the dimensions define the custom total address. The data returned is based on the custom total address.

    2. Optionally, specify a posting, summary, or node value.

      The Definition field is filled when a value is assigned in any of the dimensions. To retrieve all balances for a dimension, specify a top node. The balances for a dimension are read, including those with a blank value.

      If the Definition field value is blank, only the blank dimension balances are retrieved.

  5. To define the custom total address, specify this information:
    Scenario
    Select the type of transaction amounts to retrieve.
    • 1 = Total Obligations. A rollup of 2, 3, and 4
    • 2 = Actuals
    • 3 = Encumbrances
    • 4 = Commitments
    Accounting Entity
    Select the accounting entity from which to retrieve balances.
    Currency
    Specify the currency balance to retrieve. This field must be blank to retrieve 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 from which to retrieve balances.
    Project
    Select the project from which to retrieve balances.
    User Dimensions
    Select a value for FinanceDimension1 through FinanceDimension10.
    Period
    Select the period for which to retrieve the balance. This period must exist in the allocation calendar. Each global ledger calendar period in a calendar is uniquely identified by a prefix.
    Ledger
    Select the ledger from which to pull balances.
    System
    Specify a system from which to retrieve balances. This field must be blank to retrieve all balances.
  6. Click Save.
  7. Test the connection.

    If zero is returned, then verify that balances exist for the account in the cube.

    See Viewing an account analysis.

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