TM1 Forum

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...

late.vaibhav wrote: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.

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

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.

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...