Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Sales Analytics > Process of Aggregating Siebel Enterprise Sales Analytics Tables > About Configuring the Sales Invoice Lines Aggregate TableThe Sales Invoice Lines aggregate table (IA_SALES_IVCLNS_A1) is used to capture information about the invoices issued for your sales orders. You need to configure the Sales Invoice Lines aggregate table in order to run initial ETL and incremental ETL. For your initial ETL run, you need to configure the GRAIN parameter for the time aggregation level in the Sales Invoice Lines aggregate fact table. For the incremental ETL run, you need to configure the time aggregation level and the source identification. The source identification value represents the source system you are sourcing data from. You need to configure two parameters to aggregate the Sales Invoice Lines table for your incremental run: The GRAIN parameter has a preconfigured value of Month. The possible values for the GRAIN parameter are: Table 41 lists the values for the SOURCE_ID parameter. The value of this parameter is preconfigured to reflect the ETL mapping's folder. NOTE: You can change the default value for the Source_ID parameter if you use multiple instances of the same source system. For example, you can run multiple instances of SAP R/3 and use separate Source IDs for each instance. You can name the first instance SAPR3_1, the second instance SAPR3_2, and so on. The Sales Invoice Lines aggregate table is fully loaded from the base table in the initial ETL run. The table can grow to millions of records. Thus, the Sales Invoice aggregate table is not fully reloaded from the base table after each incremental ETL run. Siebel Customer-Centric Enterprise Warehouse minimizes the incremental aggregation effort, by modifying the aggregate table incrementally as the base table is updated. This process is done in four steps:
|
![]() |
![]() ![]() |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide |