Enabling Level Of Detail (LOD) Rollup

When you set up a data row with grouping that includes the Account ID (AID) or Object Account (OBJ) in the grouping element, you can select the Enable Level of Detail Rollup check box to specify whether the system summarizes balances to the level of detail that you specify in the version that you run.

When you select the Enable Level of Detail Rollup check box and specify a level other than 9 in the version, the system does not display in the financial statement the levels that are more detailed than the level specified. Instead, the system combines the amounts of the more detailed levels and provides a total of the aggregated amounts for each level of detail that is above the one requested on the statement version. For example, if you enter 5 in the Account Level of Detail field on the Revise Statement Version form, the system calculates totals for levels 4 and 3.

The system provides the LOD sequence number and LOD total flag in the elements that you can use in your financial statement layout when you select the Enable Level of Detail Rollup check box. These additional elements enable you to sort and sequence the accounts in the statement layout. The LOD total flag identifies which lines are the lines that have the rolled-up totals of the accounts. For example, if you enter 5 in the Account Level of Detail field on the Revise Statement Version form, then the system assigns the LOD total flag to the total lines for levels 4 and 3.

You can also use the levels to indent account balances in the layouts that you create in the BI Publisher Layout Editor.