May 23, 2006 at 7:11 pm
I have recently added a Processing Task which is just a copy of another task which processes another similar cube but with diffferent measures. I get the following error:
Detected two sibling members with the same name: 100689 Clinical Nurse Mental Health (Community) (Position ID)
Could someone tell me what this is all about? I am more confused because the other cube from which I had copied the second cube processes fine. Its just this NEW cube that doesnt process.
Please Advice.
May 23, 2006 at 8:47 pm
Assuming the error is not 'in error', what this means is that a parent within a dimension has two children with different key values but the same name. As an example, you could have a Hospital that has two positions vacant (ID's 0001 and 0002) but they're for the same type of role, hence the name for each position is identical. You have two options in this type of situation, modify the name/descriptor (e.g. add the position vacant ID to the name) or within the dimension (and level) set the properties to allow the use of duplicate names and make sure that unique names is set to off. Doing this (rather than changing the name) is not overly preferable in that it gives an end user no way to distinguish between the two vacant positions in your dimension.
Alternatively, you may have made a change to your dimension builds that is resulting in two members coming in where you really only wanted one. In this case you need to review your view/table used to build the dimension to ensure that it is doing what you expect.
HTH,
Steve.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply