What is a Rollup Ledger?
Under the multi-ledger concept, different ledgers contain different levels of detail and/or different dimensions. For some high-level reports, a ledger may contain too much detail or may contain dimensions that need to be summarized into other dimensions. To make the running time of certain reports and inquiries more efficient, the FI-SL System uses rollup ledgers.
If a report will only be run once, it is more efficient for the Report Writer to summarize the data. However, if you must select the data for your report more than once, the report data should be summarized into a rollup ledger.
A rollup ledger is the summarization of information from one or more ledgers (source ledgers) into a single ledger.
The following graphic shows the data from several source ledgers being combined into one rollup ledger.
When you create a report in the FI-SL System, the Report Writer must read the ledgers that contain the data for your report. If the ledgers are detailed and contain many records, system performance is adversely affected. To improve system performance, you can create one rollup ledger that contains summarized and condensed data from one or more other ledgers.
If you want to create a report that only uses account data from a source ledger containing 100 different accounts and 100 different cost centers for each account, the system must read at least 10,000 records (100 accounts * 100 cost centers). Because the system reads so many records, the report takes longer to run. The solution is to summarize the account data from the source ledger into a rollup ledger that contains only 100 records (one record for each account). The rollup summarizes the cost center values for each account into one record.
The following graphic shows the summarization of a source ledger with 100 accounts and 100 cost centers (10,000 records) into a rollup ledger with only 100 accounts (100 records).
You summarize data in a rollup ledger using a rollup. A rollup is the definition of how data is rolled up into a rollup ledger. A rollup consists of:
The rollup header contains header information such as the rollup title, rollup authorization, the sender and receiver tables, the reset set, rollup header set, and default values for rollup execution.
Rollup sequences are the basic unit of rollup activity and allow you to execute multiple rollup actions within one rollup. By using sequences, you eliminate having to create and execute separate rollups when you want to execute a series of different rollups.
Rollup sequences contain information such as the sequence set, a selection condition for selecting data, the field grouping code, and the ledger.
Before you can create a rollup, you must first define a ledger as a rollup ledger. In Customizing for Special Purpose Ledger, you activate the Rollup allowed indicator in the ledger definition to define if you can rollup data into the ledger. For more information about defining a ledger, see the Maintain Ledgers step in the Implementation Guide (IMG) for Special Purpose Ledger.
You can also roll up data from FI-SL into Consolidation (FI-LC). To roll up data into FI-LC, the companies into which data is rolled must have the data transfer indicator O (rollup from FI-SL; you set this indicator in FI-LC Customizing). For more information about setting these parameters in Customizing, see the Implementation Guide for Special Purpose Ledger and the FI-LC Implementation Guide.