Hi Moreno, Ben

I have been experiencing a similar problem on a dev box.  The server is a HP585 with 4x AMD Opteron 874 64 Dual Core, Windows 2003 dev edition,...

I haven't experienced the problem with AS2005, but the same thing would happen in AS2000 when there were changes to the underlying Fact table.  eg adding a new column to the fact...

Hi Pat,

How long does it take to retrieve the 8 records when you query the source data directly?  I understand that by setting the storage mode of your fact dimension...

Cheers Steve,  Have done so and am backing up my repository like a maniac.

JeremyalsofromOZ

Thanks Phil,

The post does deal with the same issue, and using Access to repair the repository database worked for me also.

Don't know what caused the corruption in the first instance though.  I...