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
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