Show TOC

Reporting Layer Locate this document in the navigation structure

The reporting layer contains the objects that are used to perform queries for analysis.

Reporting on active data only:

With the Reporting on active data only template, the Activate/Compress Data property is selected under Modeling Properties:

Reporting on Active Data and Inbound Table:

With the Reporting on union of active table and inbound queue template, the Activate/Compress Data and All Characteristics are Key, Reporting on Union of Inbound and Active Table properties are selected under Modeling Properties:

This type of modeled object corresponds to a standard InfoCube.

The inbound table corresponds to the InfoCube's F table, while the active data table corresponds to the E table.

Reporting on this type of DataStore object is consistent and provides stable navigation. A query can be executed straight after loading. You do not need to compress it beforehand. You have to load deltas, for example from another DataStore object (advanced). The data is aggregated, thus making it impossible to overwrite key figures for example. As the change log is not filled, you cannot delete any data from the DataStore object.

When a query is executed, the active table and the inbound table are accessed: