Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cube process error

Status
Not open for further replies.

berdron1

IS-IT--Management
Apr 21, 2008
1
CZ
Hello,

I have created new cube on Analysis Services 2005 and receiving this error durning its procesing:

OLE DB error: OLE DB or ODBC error: Cannot create the clustered index "Agg_ILOC_39_66_65_73_73_0" on view "cube.dbo.Agg_ILOC_39_66_65_73_73_0" because the view references an unknown value (SUM aggregate of nullable expression). Consider referencing only non-nullable values in SUM. ISNULL() may be useful for this.; 42000.

I have also set these options on database:
ARITHABORT, CONCAT_NULL_YEILDS_NULL, QUOTED_IDENTIFIER, ANSI_NULLS, ANSI_PADDING, and ANSI_WARNING
but even this not help.

Can someone help what is wrong?

Thanks in advance for any help.

Jan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top