Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 More than 15 Digits, data round up...

Author  Topic 

westsider
Starting Member

1 Post

Posted - 2006-01-17 : 03:36:54
hi,

when i load data from table into cube, the data will round up if the data is more than 15 digits.
Is it any way to correct the problem?

For example:
Data in table
-53595900.32816513

when process the cube, the data became
-53595900.32816510

Notes: It also occur when i do calculation(esp. large value multiply with larger value)

I've try to use different data type(Numeric, Double, Currency) in cube but the problem still occur.
FYI: i'm using MS analysis services 8.0.760 (sp3)

Thanks a lot
   

- Advertisement -