Failed to create index

[Tooraj]

I'm trying to build a ROLAP cube, which must be available for real-time
updates. During processing of the cube in Analysis manager I get a 'Failed
to create index'.
I am using SQL Server 2000 Enterprise edition.

[Yuan Shao]

Hello,

I learned you got the error message "Failed to create index" when you
process the Real-Time ROLAP cube using Analysis Manager.

Please try the following steps to see if they are able to fix your problem.

1. Set the following SQL Server options to ON:
ARITHABORT
CONCAT_NULL_YEILDS_NULL
QUOTED_IDENTIFIER
ANSI_NULLS
ANSI_PADDING
ANSI_WARNING

2. Set the following Source SQL Database settings to ON:
QUOTED_IDENTIFIER
ANSI_NULLS

In order to be able to process Real-Time cubes, that has aggreagations, the
settings described in the Book On-Line Topic "Indexed Views for ROLAP
Partitions" have to be implemented.

Indexed Views for ROLAP Partitions
http://msdn.microsoft.com/library/de...us/olapdmad/ag
advpart_3jzn.asp

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Yuan Shao]

Hello,

I learned you got the error message "Failed to create index" when you
process the Real-Time ROLAP cube using Analysis Manager.

Please try the following steps to see if they are able to fix your problem.

1. Set the following SQL Server options to ON:
ARITHABORT
CONCAT_NULL_YEILDS_NULL
QUOTED_IDENTIFIER
ANSI_NULLS
ANSI_PADDING
ANSI_WARNING

2. Set the following Source SQL Database settings to ON:
QUOTED_IDENTIFIER
ANSI_NULLS

In order to be able to process Real-Time cubes, that has aggreagations, the
settings described in the Book On-Line Topic "Indexed Views for ROLAP
Partitions" have to be implemented.

Indexed Views for ROLAP Partitions
http://msdn.microsoft.com/library/de...us/olapdmad/ag
advpart_3jzn.asp

I am looking forward to hearing from you soon.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Yuan Shao]

Hello,

I noticed you open a new thread in microsoft.public.sqlserver.olap. Because
this problem is related with Analysis Services. if you have follow up
questions, please post there and I will work with you. Thanks.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Yuan Shao]

Hello,

I noticed you open a new thread in microsoft.public.sqlserver.olap. Because
this problem is related with Analysis Services. if you have follow up
questions, please post there and I will work with you. Thanks.

Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.