The Oracle ATG Web Commerce data warehouse includes aggregated data that is calculated based on the data stored in the transaction fact tables. Components running on the data warehouse loader server refresh the calculated data at regular intervals so that it is available for reports. Performing intensive calculations before they are needed improves the speed of the queries that use the calculated data.

The aggregated data calculations are presented as virtual tables by materialized views in Oracle Database schemas. Other supported database products provide views or other comparable functions to make aggregated data available. See Aggregated Data Tables.

The views that contain aggregated data include columns that group the data according to related dimensional information. For example, the ARF_SITE_VISIT_MV view includes a DAY_ID column. Each value in this grouping column represents one calendar day. The calculations in each row are restricted to data associated with the calendar day in the DAY_ID column. Multiple grouping columns in a view restrict the calculations to the data that is associated with the dimensional information in each grouping column.

See information about the data warehouse loader server components that refresh the aggregated data in Refreshing Aggregated Data.