Show TOC

Definition of ClusteringLocate this document in the navigation structure

Use
Prerequisites

Note: You can only change the MDC dimensions if the InfoCube does not contain any data. If data has already been loaded you must perform Reclustering.

For more information, see Reclustering.

Features

In InfoCube maintenance, select Start of the navigation path Extras Next navigation step DB Performance Next navigation step Clustering End of the navigation path and specify the MDC dimensions.

Selecting Clustering

You can choose between Index Clustering and Multidimensional Clustering on the selecting clustering screen.

Multidimensional Clustering

You can select MDC dimensions for the InfoCube on the Multidimensional Clustering screen.

Under Time Dimension, under a selected column, you can select a time dimension field as an MDC dimension. As long as they are contained in the InfoCube, you can select either the key field of the time dimension, the additional SID field of the Calendar Month (0CALMONTH) time characteristic, the additional SID field of the Fiscal Year/Period (0FISCPER) time characteristic or, if you do not want to select the time dimension as an MDC dimension, no field at all.

The system automatically assigns sequence number 1 to the time dimension field. The sequence number shows whether a field has been selected as an MDC dimension, and determines the order of the MDC dimensions in the combined block index.

Note

In addition to block indexes for the different MDC dimensions within the database, the system creates the combined block index. The combined block index contains the fields of all the MDC dimensions. The order of the MDC dimensions can slightly affect the performance of table queries that are restricted to all MDC dimensions and those that are used to access the combined block index.

Under Characteristic Dimensions you can select additional MDC dimensions and assign them consecutive sequence numbers. You can select the key fields of the unit dimension and the key fields of all customer dimensions, as long as they contain characteristics.

For more information about selecting dimensions, see Selecting MDC Dimensions.