DataStore Object

InfoCube

Use

Consolidation of data in the data warehouse layer

Loading deltas that can subseqently be posted and updated in InfoCubes or master data tables

Operative data analysis (when used in the Operational Data Store)

Aggregation and performance optimization for multidimensional reporting

Analytic and stategic data analysis

Type of Data

Non-volatile data (when used in the data warehouse layer)

Volatile data (when used in the Operational Data Store)

Transaction data, Document-related data (line items)

Non-volatile data

Aggregated data, totals

Type of Data Update

Overwriting (addition in rare cases)

Addition only

Data Structure

Flat and relational database tables, semantic key fields

Enhanced star schema (fact table and dimension tables)

Type of Data Analysis

HIghly detailed reporting, flat reporting

The number of query records should be significantly limited by the key field selection

Number of Individual Documents

Less detailed data analysis (OLAP analysis)

Using InfoCube Aggregates

Drill-through is possible at document level (stored in DataStore objects) using the report-report interface