Product:
Cognos TM1 10.3 on the cloud
Microsoft Windows 2012 R2
Problem:
How update a cell in cube with added values from file?
Solution:
You can use a formula in the TI process Data tab where you get the value in the cell and then add the new value and put it back. Will be a long line something like this;
CellPutN(CellGetN( sCube ,vDim1,vDim2,vDim3,vDim4,vDim5,vDim6,’Gross Order Intake’)+vGrossOrder, sCube ,vDim1,vDim2,vDim3,vDim4,vDim5,vDim6,’Gross Order Intake’);
In newer version you can use incremental update with this kind of line;
if(cellisupdateable(sCube, Dim1, Dim2, Dim3, Dim4, Dim5, Dim6, measure)=1);
cellincrementn(units, sCube, Dim1, Dim2, Dim3, Dim4, Dim5, Dim6, measure);
endif;
The CellIsUpdateable function allows us to test if a cell in a cube can be written to. If true, the function returns a 1, if false a 0.
CellIncrementN inserts a number into a specific intersection of a cube, adding onto any value that is already there. It does not overwrite that value, rather it increases it.
CellIncrementN can be used in TM1 Turbo Integrator Processes only.
More Information: