Duplicate elements with _1 suffix

[late.vaibhav]

Hi

I want to merge two dimension into one new dimension, But there are some elements are common between both two dimensions and when i run my TI i get both dimension merged but along with that I also get new elements with suffix _1, and the elements with that suffix are common in both dimensions...

[declanr]

Hi

I want to merge two dimension into one new dimension, But there are some elements are common between both two dimensions and when i run my TI i get both dimension merged but along with that I also get new elements with suffix _1, and the elements with that suffix are common in both dimensions...

What's the question? Can you also provide the code of your process.

A guess would be that you need to check if the element exists in both and then decide on some method of differentiation via concatenation etc.

[late.vaibhav]

Actually while pulling from SAP to Cognos I am getting this type of errors.
Suppose i have manually created "SLVR" and if it is in SAP it will create "SLVR_1"

Prolog:
#****Begin: Generated Statements***
NULLV1='#';
DIMENSIONELEMENTINSERT('sapcapthreadtype', '', NULLV1,'N');
#****End: Generated Statements****

Metadata:
#****Begin: Generated Statements***
TrimmedV1=TRIM(V1);
V1_Mod = IF(TrimmedV1 @='', '#', TrimmedV1);
DIMENSIONELEMENTINSERT('sapcapthreadtype', '', V1_Mod,'N');
linkNode = IF(TRIM(V5) @='X', 1,0);
IF(TRIM(V6)@<>'');
DIMENSIONELEMENTINSERT('sapcapthreadtype', '', V6,'C');
DIMENSIONELEMENTCOMPONENTADD('sapcapthreadtype', V6, V1_Mod,1,linkNode);
ENDIF;
#****End: Generated Statements****


& Data:
#****Begin: Generated Statements***
TrimmedV1=TRIM(V1);
V1_Mod = IF(TrimmedV1 @='', '#', TrimmedV1);
SETELEMENTGROUPSSECURITY('READ', 'sapcapthreadtype', V1_Mod);
#****End: Generated Statements****


All codes are autogenerated

[tomok]

According to this code you are inserting the variable V6 into the dimension sapcapthreadtype. I don't see anything in the code that does anything to V6 so either 1) you haven't shown us all the code or 2) the "_1" is already part of the data source. Look in the data source to find out why you have the "_1" because it doesn't appear to have anything to do with TM1.

[late.vaibhav]

Hi Sir,

I have created two servers server 1 and server 2. In server one i have created two dimensions with some common elements.
And in server 2 i try to pull these dimension into one by different ti processes.
Now you can see the duplicate elements with _1 suffix for common elements...