Configure Batch Processes to Create Monthly Aggregates and Snapshots
You can configure Customer Cloud Service (CCS) batch processes to aggregate financial transaction data and financial transaction general ledger data by month. This allows you to improve the query performance of visualizations that use monthly aggregates.
You can also configure batch processes to do the following:
- Take monthly snapshots of service agreement arrears. This enables you to capture arrears data at a specific point in time.
- Populate the C1_BI_BILL_OVERVIEW table. This is required to view data in the Billing Overview workbook.
In this section:
Aggregate Financial Transactions by Month
Aggregate Financial Transaction General Ledges by Month