BUG: Disabling Level May Cause Error When Designing Aggregation

• Microsoft SQL Server OLAP Services version 7.0

SYMPTOMS

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.

WORKAROUND

To work around this problem, check that all levels in multiple-table dimensions in the cube are enabled.

STATUS

Microsoft has confirmed this to be a problem in SQL Server OLAP Services version 7.0.

MORE INFORMATION

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:

1. Start the OLAP Manager.



2. Right-click the cube containing the dimension, and then click Edit on the shortcut menu. This action opens the Cube editor.



3. Expand the tree to reveal the level you want to enable, and then click to select it.



4. If the Properties pane is closed, click the Properties button to open it.



5. Click the Advanced tab.



6. For the Disabled property, select No.



7. On the File menu, click Save.

Additional query words:

Keywords : SSOSmgr kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug