BUG: Disabling Level May Cause Error When Designing AggregationID: Q199186
|
An error occurs when designing aggregations in the Storage Design Wizard or the Usage-Based Optimization Wizard if any level in a multiple-table dimension of a cube is disabled. The error received is:
Error occurred during design initialization: Subscript out of range.
To work around this problem, check that all levels in multiple-table dimensions in the cube are enabled.
Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0.
This problem only occurs if you disable a level of a dimension that is based on multiple-dimension tables (as in a snowflake schema -- for example, any level of the 'Product' dimension in the sample cube 'Sales'). It does not happen on a dimension that is based on only one dimension table (as in a star schema -- for example, the 'Time' dimension in 'Sales').
After the error in the Storage Design Wizard or the Usage-Based Optimization Wizard, the cube will still process with 0 aggregations.
Note that disabling a level disables all levels below it. However, enabling a level does not automatically enable all the levels below it. You can enable each level individually or enable the bottom-most level, which automatically enables all the levels above it.
To enable a level, perform the following steps:
Additional query words:
Keywords : SSOSmgr kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug
Last Reviewed: February 16, 1999