Dimension Processing Error

I am using following configuration

Server:-SQL Server 2000

Database :-Oracle

MSOLAP :-Cubes

But while processing dimension We are getting follwing error

Analysis Server Error: Processing error [Attempt to delete member that is in use] '27-08-2005' ; Time:3/17/2006 1:04:01 PM

The mentioned date is already there in database ,Pl let me know what causing this error

Thx and regards

Pankaj

Are you using Process Update for you dimension?

The situation could be that dimension table ( tables ) dont have a particular member anylonger. Analysis Server compares new copy of the dimension to the old one. It sees it needs to delete some members. This particular member has some data associated with it and it cannot delete it.

You need to make sure if you are using Process Update for your dimension, you have full copy of the data in the underlying tables.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi

Thx for your reply.

There are no changes in structure and underlying data.The strange thing is i get this error only sometimes.If i make a copy of this dimension and if i try to process the dimension then sometimes it will not give issue,Pl advise

Thx and regards

Pankaj

|||I don't see any issue in it...coz we usually delete data from datawarehouse and process that particular dimension which is being affected by the DML operation....use Service Pack 4 of Analysis Services..it might remove this bug....|||

What could be happening is:

You fully process your dimensions. The default Error Configuration settings on the processing command are set to ignore processing errors like duplicate keys.

This is the main reason for your situaion. Once duplicate key error is ignored, next time you run Process update for your dimension, the records could come in the different order and Analysis Server is going to see another memeber coming in first. The member used to be first at the peviouse processing, coming and getting ignored. As a result stucture of your dimension might apper different.

You should look at the configuration options and change them to catch all errors.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hello,

I have the same issue as mentioned above; [attempt to delete member that is in use] on a changing dimension when performing an incremental update. Strange is, the mentioned member is in the dimension table. So it should not be deleted.

The value for member keys unique is has always been true.

I use AS 2000 SP4

Someone any idea why AS gives this error mesage?