Microsoft KB Archive/199186

{|
 * width="100%"|

-

The information in this article applies to:


 * Microsoft SQL Server OLAP Services version 7.0

-

BUG #: 7590 (platovn)

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.

If the dimension is shared, you must repeat this procedure for other cubes that include the dimension before designing aggregations for them. Additional query words:

Keywords : SSOSmgr kbbug7.00

Version : winnt:7.0

Platform : winnt

Issue type : kbbug
 * }