sql server data warehouse: I am using one cubes for my sales analysis.
When I try to redesign storage and Process the cube from MOLAP to ROLAP, it
create error with something related to fail to create index.

I didn't change the cube design.

Hi Kam.

This error is usally related to Real-Time OLAP. Are you trying to re-design
the storage mode of your cube as a Real-Time? This feature requires special
settings in the relational database.

You may find more information here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmad/agcubevarieties_0o4z.asp

Hope that helps.



[quoted text, click to view]