TI Process Error Warnings

[davekerby]

Hi,

I've build my cube using TI process, however, once it completes it completes with error warnings and im not entirley sure what they mean. Could you help me understand why these are occuring. Listed below are just a few examples coming from log file.

"4.09","1.","4.09","4.7","0.61","112771","67557","726",Data Source line (23869904) Error: Data procedure line (9): Invalid key: Dimension Name: "Original Suppliers", Element Name (Key): "112771"
Error: Data procedure line (9): error repeats 4 times
"10.07","1.","10.07","10.07","0.","112772","67589","726",Data Source line (23872225) Error: Data procedure line (9): Invalid key: Dimension Name: "Original Suppliers", Element Name (Key): "112772"
Error: Data procedure line (9): error repeats 4 times

Any help would be appreciated
Dave

[Paul Segal]

Hi Dave,

This is saying that there is an error in line 9 of your Data tab. If line 9 is trying to add data to a cube you have built either via TI or manually, then it can't find the relevant element in the Original Suppliers dimension. Could you post all or some of your Data tab code?

Regards

[Steve Rowe]

Dave
It's saying that 112771 is not in the Original Suppliers dimension so TM1 cannot reference the cube or dimension correctly on line 9.

It's normal to process a data file once through the meta data and update dimensions as required and then process the data into the cube on the data tab.

(Side point : If its not too late consider making any numeric only element names alpha numeric by adding a prefix. This will avoid potential for issues that can only crop up long term. Like what happens when through random chance you happend to have customer and product codes with the same number, the formula wizard in Excel picking up numbers in the report as element references and making life difficult for your users, some TM1 excel functions in some versions seem to require an element name to be a string....)

HTH

[davekerby]

Thanks, Please find below the Data script. You mentioned that it might not be able to find the element with in the Original Suppliers dimension, this is what i orignially thought so i check and it is in there.


#****Begin: Generated Statements***
vTVRegion=MEMID;
vMangers=MEMID;
vNisaCategories=PROID;
vNisaAccountGroup=MEMID;
vOriginalSuppliers=PROID;
vDepartments=PROID;
CellPutN(NET_AMOUNT,'TwoFacts',CAPID,vMangers,vTVRegion,MEMID,vNisaAccountGroup,PROID,vOriginalSuppliers,vDepartments,vNisaCategories,'Net Amount');
CellPutN(QUANTITY,'TwoFacts',CAPID,vMangers,vTVRegion,MEMID,vNisaAccountGroup,PROID,vOriginalSuppliers,vDepartments,vNisaCategories,'Quantity');
CellPutN(UNIT_AMOUNT,'TwoFacts',CAPID,vMangers,vTVRegion,MEMID,vNisaAccountGroup,PROID,vOriginalSuppliers,vDepartments,vNisaCategories,'Unit Amount');

CellPutN(TOTAL_AMOUNT,'TwoFacts',CAPID,vMangers,vTVRegion,MEMID,vNisaAccountGroup,PROID,vOriginalSuppliers,vDepartments,vNisaCategories,'Total Amount'
);
CellPutN(VAT_AMOUNT,'TwoFacts',CAPID,vMangers,vTVRegion,MEMID,vNisaAccountGroup,PROID,vOriginalSuppliers,vDepartments,vNisaCategories,'VAT Amount');
#****End: Generated Statements****

Regards
Dave

[davekerby]

Sorry my mistake you were right and its not in the dimension, however im not sure why it not in there as im creating my dimension through a TI process to and it should be picking all the products up from the product table but it not. Any ideas why this might be happening?

[Paul Segal]

Dave,

That's tricky to diagnose without seeing the code and the table. One suggestion is that if you are creating consolidated elements as part of the TI process that creates the dimension, then trying to load to the consolidated elements would throw this kind of error. Another would be that the process to create the dimension is throwing these lines out for another error, and therefore not creating the elements that can't be loaded (and are therefore causing the error you originally posted about).

Regards