Show TOC

Flat InfoCubeLocate this document in the navigation structure

Flat InfoCubes only consist of one fact table and the table for the package dimension. The SIDs of the characteristics in the dimensions are saved directly in the fact table. Therefore no dimension tables are needed, apart from the table for the package dimension.

Flat InfoCubes can be compressed. The compressed data is saved in the fact table. The uncompressed data is deleted from the table.

Flat InfoCubes can also contain non-cumulative key figures.

Converting InfoCubes

You can convert standard InfoCubes into flat InfoCubes using the program RSDU_REPART_UI. InfoCubes containing data can also be converted. Flat InfoCubes can also be converted back to standard InfoCubes.

Prerequisites

You have installed DB2 10.5 Cancun.

You have also implemented SAP Note 2038632.