TM1 Forum

Hi Experts,

I am new to TM1. TI process is aborted and when see in the log it is saying wrong number of dimension element.Please check the attatchements and do the needful.

cherry4 wrote: I am new to TM1. TI process is aborted and when see in the log it is saying wrong number of dimension element.Please check the attatchements and do the needful.

I very much doubt that it was aborted from the code that you've shown in the Prolog; not from that error message.
What is the actual error message (copied and pasted from the error log file) that you're getting, including the tab that it occurs on, and the code in that tab? (Copying and pasting the code would be better than providing a screenshot of it, especially if it's long.)

"Buildings","GO Americas","Budget version 1","Depreciation on Existing Items","240685.89","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88",Data Source line (2) Error: Data procedure line (7): Wrong Number of Dimension Elements.

This is the error i am getting i have double clicked the error in error log file from then if i execute i am not getting Ti Error log file .Through path i went to this log
and i found this error


Thanks.

cherry4 wrote:"Buildings","GO Americas","Budget version 1","Depreciation on Existing Items","240685.89","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88","240685.88",Data Source line (2) Error: Data procedure line (7): Wrong Number of Dimension Elements.

This is the error i am getting i have double clicked the error in error log file from then if i execute i am not getting Ti Error log file .Through path i went to this log
and i found this error

Yes, it's not much of a surprise that it's coming from the data tab. What exactly is the code on that tab? (Especially the code on line 7.)

Parameter tab: i have given parameter:Pyear type:string and prompt question :load year

Prolog tab: CUBECREATE('Depreciationplan1','year','Assets','Division','Versions','Measure_Depreciation','month');

metadata: TotalAssests='Total Assests';
DIMENSIONELEMENTINSERT('year','',Pyear,'n');
DIMENSIONELEMENTINSERT('Assets','',TotalAssests,'c');
DIMENSIONELEMENTCOMPONENTADD('Assets',TotalAssests,V1,1.000000);

datatab:

TotalAssests='Total Assests';
CellPutN(Jan,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Jan');
CellPutN(Feb,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Feb');
CellPutN(Mar,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Mar');
CellPutN(Apr,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Apr');
CellPutN(May,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'May');
CellPutN(Jun,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Jun');
CellPutN(Jul,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Jul');
CellPutN(Aug,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Aug');
CellPutN(Sep,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Sep');
CellPutN(Oct,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Oct');
CellPutN(Nov,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Nov');
CellPutN(Dec,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Dec');

cherry4 wrote:Parameter tab: i have given parameter:Pyear type:string and prompt question :load year

Prolog tab: CUBECREATE('Depreciationplan1','year','Assets','Division','Versions','Measure_Depreciation','month');

metadata: TotalAssests='Total Assests';
DIMENSIONELEMENTINSERT('year','',Pyear,'n');
DIMENSIONELEMENTINSERT('Assets','',TotalAssests,'c');
DIMENSIONELEMENTCOMPONENTADD('Assets',TotalAssests,V1,1.000000);

datatab:

TotalAssests='Total Assests';
CellPutN(Jan,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Jan');
CellPutN(Feb,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Feb');
CellPutN(Mar,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Mar');
CellPutN(Apr,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Apr');
CellPutN(May,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'May');
CellPutN(Jun,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Jun');
CellPutN(Jul,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Jul');
CellPutN(Aug,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Aug');
CellPutN(Sep,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Sep');
CellPutN(Oct,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Oct');
CellPutN(Nov,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Nov');
CellPutN(Dec,'Depreciation cube',Pyear,V1,V1,V2,V3,V4,'Dec');

You've got a few issues happening here.

The first is that in the Prolog you create a cube called 'Depreciationplan1'. Yet in the Data tab you seem to be writing to a different cube, which is called 'Depreciation cube'. This may of course be your intention and the creation of the 'Depreciationplan1' cube is unconnected with the upload of data to a different, pre-existing cube called 'Depreciation cube', but it doesn't strike me as probable.

The next thing is that you have V1 twice in your CellPutNs. Again this may be valid since we don't know the structure of the cube named 'Depreciation cube', but it again seems unlikely. Assuming that 'Depreciation cube' has the same structure as 'Depreciationplan1' then based on the data row shown in your error log you'd have:
V1 as Buildings which equates to both the Assets dimension and the Division dimension;
V2 as GO Americas which equates to the Versions dimension (the problem becomes apparent at this point)
V3 as Budget Version 1 which equates to the Measure_Depreciation dimension,
V4 as Depreciation on Existing Items which equates to the Month dimension; and then
The month code, which doesn't equate to anything because you've run out of dimensions and hence generated the error message that you saw.

You may want to get rid of the double appearance of V1 in your formulas.

Also I do believe that the word that you're looking for is Assets rather than Assests.

Hi Alan Kirk,

Thanks alot for you patience.I really made stupid mistakes.It completed successfully.