Unable to update attribute of large dimension
Posted: Fri Jun 16, 2017 1:43 pm
Hi,
I have a dimension with around 320,000 elements (transaction references) and need to update a dimension attribute depending on whether the element contains a specific text string e.g. 'AB'.
I have created a TI process with the dimension level 0 subset as the data source. On the data tab I have used the SCAN function and if it returns non-zero I wish to add the attribute text. Simple code is as follows:
I have tried using AttrPutS and CellPutS but both completely freeze the server and never finish (left TI process to run for half an hour). The records processed/progress bar also does not update. I tried using an ASCIIOutput after each attribute is updated but this did not produce anything so it seems the process simply hangs at the start of the Data tab.
I don't usually work with such large dimensions however I understand TM1 should be able to handle processing a dimension of this size.
Please could someone advise if there is a way to complete the above task more efficiently and shine any light on why I may be experiencing this issue/how to troubleshoot?
Many thanks,
Oli
I have a dimension with around 320,000 elements (transaction references) and need to update a dimension attribute depending on whether the element contains a specific text string e.g. 'AB'.
I have created a TI process with the dimension level 0 subset as the data source. On the data tab I have used the SCAN function and if it returns non-zero I wish to add the attribute text. Simple code is as follows:
Code: Select all
IF(SCAN('AB', vRef) <> 0);
ATTRPUTS('AB',sDim,vRef,'Type');
ENDIF;
I don't usually work with such large dimensions however I understand TM1 should be able to handle processing a dimension of this size.
Please could someone advise if there is a way to complete the above task more efficiently and shine any light on why I may be experiencing this issue/how to troubleshoot?
Many thanks,
Oli