IA05.3
IA05.3 - Star Schema Parameters

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 enter 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 performanceincrease 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, type 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. NOTE If you are entering storage size, do not exceed the amount of storage available.

Updated Files
OLAPDBM - No Description Available.



Referenced Files
APPLICTYPE - No Description Available.



INVOKED Programs
IACP




File created: Thu Jun 09 02:18:09 2016

Nogalis, inc.
Contact Us

All trademarks and registered trademarks are the property of their respective owners.