Alpha numeric dim elements not getting loaded through TI

[anoops81]

Hi All ,

I have a TI process which loads elements to a dimension hierarchy from a csv file . Every thing is working fine except some alpha-numeric elements given below .

80.1.6 All Other Service Fees
80.1.5 AESS
80.1.4 Facilities & Security
80.1.3 HR
80.1.2 FRC/Finance Svce Fee
80.1.1 Procurement
80.2.4 SWC
80.2.3 Variable SQP
80.2.2 Fixed SQP

These elements are not getting loaded and I am getting "process successfully completed" message.

Anybody knows why these elements are ignored by TI ?

Anoop

[mattgoff]

How long is a piece of string?

[anoops81]

Hi Matt ,

This is a dimension hierarchy which i tried to load through a TI and the elements in the hirearchy looks as below

table.JPG (47.11 KiB) Viewed 7218 times

The last column is not getting loaded into the dimension structure because of the numbers I believe.

Regards
Anoop

(Edited to include the dimension hierarchy structure as a table)

[asutcliffe]

Hi Matt ,

This is a dimension hierarchy which i tried to load through a TI and the elements in the hirearchy looks as below

Functional Packs WS WS Other WS Other Service Fees 80.1.6 All Other Service Fees
Functional Packs WS WS Other WS Other Service Fees 80.1.5 AESS
Functional Packs WS WS Other WS Other Service Fees 80.1.4 Facilities & Security
Functional Packs WS WS Other WS Other Service Fees 80.1.3 HR
Functional Packs WS WS Other WS Other Service Fees 80.1.2 FRC/Finance Svce Fee
Functional Packs WS WS Other WS Other Service Fees 80.1.1 Procurement
Functional Packs WS WS Other WS Tech Service Fees 80.2.4 SWC
Functional Packs WS WS Other WS Tech Service Fees 80.2.3 Variable SQP
Functional Packs WS WS Other WS Tech Service Fees 80.2.2 Fixed SQP

The last column is not getting loaded into the dimension structure because of the numbers I believe.

Regards
Anoop

I don't think it's to do with the numbers. As much as I avoid "special" characters in element names, something like "80.1.6 All Other" should be a perfectly acceptable.

Are any elements from that last column getting added at all? How is your file delimited? You could perhaps post the code from the metadata tab of your process too.

Cheers,
Alex

[Duncan P]

A screenshot of the preview pane and the Variables tab would also be most helpful.

[anoops81]

Hi Alex,

No element with number & string together is getting loaded.

Please find the metadata code

Code: Select all

if(l7@<>'');
if(dimix('Test_Func',l7)>0);
parent=elpar('Test_Func',l7,1);
    if(parent@<>l8);
    DimensionElementComponentDelete('Test_Func', parent,l7);
    DimensionElementComponentAdd('Test_Func', l8,l7, 1);
    endif;
else;
DimensionElementComponentAdd('Test_Func', l8,l7, 1);
endif;
endif;

The level check is repeated for all the levels.


Regards
Anoop

[Duncan P]

Without knowing how the variables l8 and l7 map to the columns of the data it is difficult to work out what it going wrong. You have shown only five columns in your sample data and yet the variable names seem to indicate at least 8.
From the naming it also appears that level 8 is the parent of level 7. Does that mean then that level 0 is the leaf? If so where is the code for that?

Why not just attach the .PRO file and the source data file then we can see exactly what is happening, rather than drip-feeding us only what you think we need to know?

[asutcliffe]

Code: Select all

if(l7@<>'');
if(dimix('Test_Func',l7)>0);
parent=elpar('Test_Func',l7,1);
    if(parent@<>l8);
    DimensionElementComponentDelete('Test_Func', parent,l7);
    DimensionElementComponentAdd('Test_Func', l8,l7, 1);
    endif;
else;
DimensionElementComponentAdd('Test_Func', l8,l7, 1);
endif;
endif;

The level check is repeated for all the levels.


Regards
Anoop

The code above will remove l7 from it's first parent (if any) and add l7 as a child of l8.

As Duncan suggested, a screenshot of your variables and the preview pane would help. Which column is l7 and which is l8? Or are these variables set/manipulated somewhere else on the metadata tab?

edit: Duncan beat me to it.

[anoops81]

Hi All ,

I was able to load the data with out the parent check . Checking on the file to see what is happening .

Keep you posted soon .

Thanks & Regards
Anoop

[anoops81]

Hi All ,

The elements are getting added only once as per the TI . Hence I got a feeling that some elements are ignored by TI .

Changed the TI so that it will check for parent and delete the element from the parent consolidation .

Sorry that I could not provide all the needed information for you guys.

Thanks a lot for replying very fast & I really appreciate it .

Anoop