Bookshelf Home | Contents | Index | PDF |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Workforce Analytics > About Aggregating the Payroll Table for Siebel Enterprise Workforce AnalyticsYou can aggregate the Payroll table to a different time levels, and aggregate levels of Employees, Jobs, and Payment Types dimensions. There are two time grain parameters to configure for this aggregate table and these parameters need to have the same value. The GRAIN parameter has a preconfigured value of Month. The possible values for the GRAIN parameter are: The Payroll aggregate table is fully loaded from the base table in the initial ETL run. The table can grow to millions of records. The Payroll aggregate table is not fully reloaded from the base table after an ETL run. Siebel Customer-Centric Enterprise Warehouse minimizes the incremental aggregation effort, by modifying the aggregate table incrementally as the base table is updated. Siebel Customer-Centric Enterprise Warehouse looks for new records in the base table during the incremental ETL. This process is done in two steps:
|
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide |