BUG: ROLAP Cube Processing Fails with Big Numbers in Measures Columns (219272)


The information in this article applies to:

  • Microsoft SQL Server OLAP Services 7.0
  • Microsoft SQL Server 2000 (all editions)
This article was previously published under Q219272
BUG #: 208 (PLATO7x)

SYMPTOMS

Cube processing fails when all of the following conditions apply:
  • OLAP Services uses SQL Server (6.x or 7.0) as the underlying data source.
  • The cube contains a measure from an integer column with large enough values that the aggregated values can exceed the valid integer range.
  • The measures aggregate function is SUM.
  • The Storage mode of one or more of the cube's partitions is ROLAP.

CAUSE

The SUM is performed on the column of integers, and when the value exceeds SQL Server's valid integer range (-2147483648 to +2147483647), an arithmetic overflow occurs during internal SQL Server calculations.

WORKAROUND

Before adding the integer values in this column, first convert the data type to float, or double. This can be done by changing the Source Column property of the measure to convert (float,MyIntegerColumn). The user might also want to use MOLAP or HOLAP storage options when designing the cube. After you perform one of these actions, process the cube.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:2/24/2004
Keywords:kbBug kbpending KB219272
©2004 Microsoft Corporation. All rights reserved.