SQL Server Analysis Services Multidimensional Data Type Overflow - by SamHjelmfelt

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 795301 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 7/29/2013 11:59:53 AM
Access Restriction Public

Description

SQL Server Analysis Services running in multidimensional mode should throw an exception or  report an error when a datatype overflow occurs.
Sign in to post a comment.
Posted by Microsoft on 8/26/2013 at 6:30 PM
Hi Sam,

We have checked your suggestion, and unfortunately have to reject it. The reason is that adding overflow checks will substantially affect performance of aggregations. In order to mitigate the overflow issue we suggest you to change your data type to BigInt. With BigInt you can also hit the same issue, but very unlikely.

Thank you,
Analysis Services Engine Development Team
Posted by Microsoft on 7/31/2013 at 7:18 PM
Hi Sam,

Thank you for suggesting this improvement. We will consider it.

Thank you,
Vitaliy