Page 1 of 1
Alpha numeric dim elements not getting loaded through TI
Posted: Wed May 02, 2012 5:56 pm
by 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
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Wed May 02, 2012 10:56 pm
by mattgoff
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Thu May 03, 2012 8:57 am
by 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 7222 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)
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Thu May 03, 2012 9:18 am
by asutcliffe
anoops81 wrote: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
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Thu May 03, 2012 9:25 am
by Duncan P
A screenshot of the preview pane and the Variables tab would also be most helpful.
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Thu May 03, 2012 9:43 am
by 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
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Thu May 03, 2012 10:11 am
by 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?
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Thu May 03, 2012 10:15 am
by asutcliffe
anoops81 wrote:
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.
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Thu May 03, 2012 10:49 am
by 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
Re: Alpha numeric dim elements not getting loaded through TI
Posted: Thu May 03, 2012 11:10 am
by 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