Re: Falied Index

#1

have you set a custom formula for the "All level" in 1 of your dimension ?

Try to change the aggregation model and customize it for your dimension.
You can disallow the aggregation of the top level in your dimensions, in
this case, AS will not aggregate the values at the all level, maybe this
will help you.

"Michael Ritacco" <michael.ritacco (AT) cardinal (DOT) com> a écrit dans le message de
news:385a01c3400b$3bde7b00$a401280a (AT) phx (DOT) gbl...

Quote:

Hello All,

I am testing Real-Time cubes and get the following error
whenever I process a ROLAP cube. Has anyone seen the error
before?

Failed to create index. SQL Server 2000 does not support
indexed views for scalar aggregations based on all levels
of all dimensions.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.495 / Virus Database: 294 - Release Date: 2003-06-30

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Falied Index

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: Falied Index - 07-01-2003 , 09:12 PM