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.- Select Processing > Allocations > Custom Total.
- Click Create.
-
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.
-
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.
-
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.