This is caused by the entry of 0.00 in the ExtendedAmount column in the OpportunityProductBase table in CRM. The solution to this problem is to convert the zeroes to NULL. You can do this by writing a T-SQL script.

When the error occurs, do not cancel the installation. Instead, simply open the SQL Server Management Studio and use the following script to identify the records that have 0.00 in the ExtendedAmount column:

 SELECT * FROM dbo.OpportunityProductBase
 WHERE ExtendedAmount = 0

Once you have identified the records, use an UPDATE statement to change the 0.00 value to NULL:

 UPDATE OPB
 SET ExtendedAmount = NULL
 FROM OpportunityProductBase OPB
 WHERE ExtendedAmount = 0

Once you've done this, you can proceed with the cube installation. Just click the Retry button to continue with the cube installation.

The cube should process successfully.

Tony Bell
Product Support
BI Analytics for Dynamics CRM

c360 Solutions
2 Concourse Parkway Suite 800
Atlanta, GA 30328
678.259.8678 Desk
678.274.7789 Cell
tony.bell@c360.com
www.c360.com