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. |
File created: Wed Jun 08 20:49:34 2016
Nogalis, inc.
Contact Us
All trademarks and registered trademarks are the property of their respective owners.
