cancel
Showing results for 
Search instead for 
Did you mean: 

Can't process dimension because of duplicated member that can't be removed.

Former Member
0 Kudos

Hello experts,

I don't how it happens, but I have for my dimension "Material" a duplicated record.

When I "maintain dimension" I can see my correct material line with all properties and description filled, and another line with only the ID filled, it is prefixed with a space ' '.

I can't delete the line : when I process the dimension I get the error message :

Delete and insert member '0001' in one transaction is NOT allowed!

Duplicated member ID '0001' detected!

Error in Admin module.

This thread as the same error and is "Answered" but no precision on the way to solve the problem :

I precise that my BW cube contains both loaded data and data coming from input schedules, so I can't delete all data.

When I manage the infoobject Material from the backend I can't delete the problematic line.

Thanks in advance for your help.

Guillaume P.

Accepted Solutions (1)

Accepted Solutions (1)

former_member200327
Active Contributor
0 Kudos

Hello Guillaume,

First question would be: what do you want to do with records that have all members same and only material different, i.e.one of those two members. Do you want to add those records or override with the latest?

Lets' assume for simplicity that you don't have such records.

Can you find out if that member that you want to delete is in loaded data or in Input schedule data? If it's in loaded data that you can reload, then you can selectively delete that data fix MD and reload corrected Transaction Data.

Another option would be to export those records into a flat file, fix that member, delete wrong records from the Application and load those records back.

One more option, is to write a simple script that moved data from 0001 to some other member and makes 0001 values zeroes; than run Light Optimization with zero elimination, fix 0001 from MD and than similar script that moved data back to corrected 0001.

Please let me know if none of this works for you,

Gersh

Former Member
0 Kudos

Hello Gersh,

first of all thanks for your time.

I think few points are not clear :

- I'm not trying to load anymore additional transactionnal data. Datas in the cube are correct

- I just want to manually add few materials in the list. I don't want to fix any transactionnal data.

- when I do a "display data" on my BPC cube, I found data for Material = '0001', I don't find any for ' 0001' (with the leading space) (so I don't see any reason to prevent me from deleting the useless line at the master data level)

- I already tried a full optimize and get a message saying there was no need to

- I already tried the UJA_REFRESH_DIM_CACHE program

To answer you, I have both loaded and inputed data in the cube for this material.

Regards

Guillaume P.

former_member200327
Active Contributor
0 Kudos

Hello Guillaume,

Ok, you can't process Dimension because you have to congruent members: '0001 and ' 0001' - they are indistinguishable from the back-end side point of view. Hence you have to remove one of them.

To remove a member you can't have any Transaction data on that member, but you said that you already have TD on both those members.

What I was describing is how to remove data from one of the members, so you would be able to remove it from MD. Issue is how to remove TD without loosing it.

Does this make my prev posting more clear?

Regards,

Gersh

Former Member
0 Kudos

No I only have TD on my correct member (which is '0001').

I don't have any TD on the member with the leading space (' 0001')

This is the reason why I don't understand the system prevent me from deleting this problematic (duplicated) member, it should not.

I said my TD on '0001' are coming from both processes :

- loaded from another cube,

- and manually inputed through an input schedule.

Thanks for your help.

former_member200327
Active Contributor
0 Kudos

I'd guess you have access to the back-end. Can you go to the definition of Material InfoObject and check the SID table if both of your members are in that table? If both of them are, check please is both of them has X value in 'Used in Cube' column.

Could you please also confirm that you don't have ALPHA conversion in that InfoObject.

Based on this we can decide further actions.

Former Member
0 Kudos

Hello,

answer is Yes, I have both members in the SID table of my Material InfoObject (with the leading space and the correct one)

I can't see the column 'Used in Cube' in this table.

I have columns :

SID

OBJVERS

/B28/S_FADJK6P

CHANGED

/B28/S_FAPPMT3

/B28/S_CALC

/B28/S_FAPW6HQ

/B28/S_FAPCMHQ

/B28/S_FAP8KTO

/B28/S_FAPMWBU

/B28/S_FAPGHD6

/B28/S_FAP59ZI

and for both lines I don't have a 'X' value anywhere

Finally, in back-end / RSA1 / infoobject Material / 'general' tab

--> there is no Convers. Rout. at all (the field is empty

Thanks for your help.

Guillaume P.

Former Member
0 Kudos

Hi

As per my understanding you have 0001 member in duplicate (twice) in a particular Materials dimension, which you want to delete right? You can do one thing here you can copy all the members in one more new dimension and paste them in that and delete the duplicate 0001 member (Which is not required) save and process that. And delete the original dimension (Which is containing the duplicate record-earlier dimension) and rename the existing (newly created) dimension to the earlier dimension name.

Regards,

Raghu B.S.

Edited by: Raghu B.S. on Jul 5, 2011 1:40 PM

Edited by: Raghu B.S. on Jul 5, 2011 1:41 PM

Former Member
0 Kudos

Hello Raghu,

Right for your understanding of my need (members are no exactly the same, one have a leading space).

I don't think I will be able to delete an entire dimension without empying my cube, and my goal if possible is to keep my transactionnal datas as they are.

My opinion is since I have no transactionnal data for the material ' 0001' (with the leading space), I should delete this member, but here I can't.

I guess a solution could be to copy the BPC cube from BW, copy the material IO, replace the material IO by its copy in the new cube, transfer all data from my first cube to its copy and delete data from my first cube : then I may be able to maintain my material dimension.

After that copy back my datas into my first cube from the new one.

But it is using a machine-gun to kill a fly, I hope there is something easier and faster to do.

Thanks for you help

Guillaume P.

Former Member
0 Kudos

Hi,

As we are all knows that the dimension data will be stored in Info object at back end BI, so please delete that particular

record from info Object and Optimize the Application and check please. Take a backup and delete.... and your 0001 which

you want delete the member should not have any hirarchy

Regards,

Raghu B.S.

Former Member
0 Kudos

Those actions you are proposing to me, are exactly actions I can't perform.

On the admin side, I get the error message described in my first post.

On the BW side, the system refuses to delete the member with the leading space.

former_member200327
Active Contributor
0 Kudos

Hi Guillaume,

This doesn't look like structure of a SID table. SID table has fields SID, CHCKFL, DATAFL and INCFL. DATAFL is the fields I'm talking about.

Former Member
0 Kudos

My mistake,

I was watching the SID table for attribute.

Yesterday I used the solution I was thinking about (saving data / emptying BPC cube) and I could then remove the problematic record.

I can't say how was the SID table before my deletion, but now I have only one record in this table, and all columns (CHCKFL DATAFL INCFL) are populated with an 'X'

My issue is solved, not by the way I wish, but solved

I hope it will not happen too often.

I keep the thread open for a while, in case you want me to check something else.

thanks a lot for your time.

Regards

Guillaume p.

former_member200327
Active Contributor
0 Kudos

HI Guillaume,

Nice to hear that you solved your problem. There is nothing to check now:).

I thought that you can save just part of the data based on that analysis. This would make sense if you have a lot of data in that Application, but if it's relatively small full back up is fine as well.

Regards,

Gersh

Former Member
0 Kudos

I know Guillaume solved his problem, but I experienced the exact problem today, and I could find myself an easier workaround to solve it, and want to share for those who aren't able to download data cube/rebuild cube.

First of all, you need access to BW. Once that, do:

1. Go to the RSA1 -> Select any cube that has the broken dimension attached. -> Right Click, "Change Real-Time Load Behavior" -> Select "Real-Time Data Target Can Be Loaded With Data; Planning Not Allowed" option and OK.*

  • Repeat step 1 for ALL cubes that have attached the broken dimension. (this is mandatory)

2. In the RSA1, look for the broken InfoProvider (dimension) -> Select Mantain Master Data -> Filter the ID of the wrong element in the dimension and execute -> Select member, delete and save.

You'll be able to process the dimension again as normal. I hope this helps other people with this annoying issue.

Best regards

Former Member
0 Kudos

Hi

I have the same problem

But the situation is a little different

I donot have T data in the me to be delted

nor

i could save the data of the infoobject after deleting the particular member with or without sids

any suggestions how to delete from the backend

so i can process the dimension successfully

thanks

Answers (0)