In SSAS, If you have measure type as int, in some cases you can see cube aggregated results in negative.
Source:
This is because of the limitation of data type.Integer will support -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647). If the aggregated data was falls out of this range, then it shows wrong data or data in negative values.
Solution:
To resolve this issue, select the SSAS Cube measure in the BIDS and change the measure DataType property and Source DataType property to BigInt. Reprocess the cube and check the result.
Source:
This is because of the limitation of data type.Integer will support -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647). If the aggregated data was falls out of this range, then it shows wrong data or data in negative values.
Solution:
To resolve this issue, select the SSAS Cube measure in the BIDS and change the measure DataType property and Source DataType property to BigInt. Reprocess the cube and check the result.
No comments:
Post a Comment