Star Schema Parameters (IA05.3)

Use Star Schema Parameters (IA05.3) to define the storage and optimization settings for Microsoft Analysis Services.

Data Mart Status

This field displays the status of the data mart. You do not need to specify a value in this field.

Storage Option

M (MOLAP, multidimensional), R (ROLAP, relational), H (HOLAP, hybrid of relational and multidimensional).

Aggregation Option

Select how aggregation will be performed. If you select P (Performance), aggregations are performed until the performance increase reaches the percentage entered. For most data marts, 60% is adequate. If you select S (Storage), aggregations are performed until the storage limit is reached.

Aggregation Limit

In the first field, specify a number for the aggregation limit. This number represents the maximum storage size or minimum performance percentage used to perform aggregations.

In the second field, select the option that matches the aggregation option: % (Percent) for performance, MB (MegaBytes) or GB (GigaBytes) for storage.