Populate Data for the Billing Overview Workbook

You can run a batch process to populate data in the C1_BI_BILL_OVERVIEW table, which is required to view data in the Billing Overview workbook.

• Batch Control: C1-BOVR

• Batch Name: Capture Billing Overview

• Required Parameter: horizon

Example Steps and Execution

1. Run a one-time batch process responsible for loading data into the Billing Overview table. This process handles both daily and historical loads (based on the horizon parameter). For example, if the current month is April 2022 and historical bills exist for the past two years, set the horizon to 730 days—either as a batch parameter or through an extendable lookup. The system will prioritize the batch parameter if both are provided. This will load billing data by day, covering the period from April 2019 to April 2022. All bills within this range will then be inserted into the Billing Overview table.

2. Use a batch scheduler of your choice to run the batch process on a recurring basis. The frequency you choose will depend on how often you need to reference the Billing Overview workbook. For example, if you need to reference the workbook on a daily, weekly, or monthly basis, then configure the batch scheduler to run the batch process on one of those frequencies if the system load allows for it.