Hold and Proportional Spread
Posted: Fri Mar 13, 2020 5:22 pm
Hi all,
In my cube with Customers , Year/Month dimensions and measures(revenue ,cost and others) I would like, by a simple TI process, copy values from a generic measure A and paste it into Cost measure.
So, I wrote a process which uses as data source a view for the Measure A where a few values are different by null or zero and, for each iteration in the Data tab, perform a CellPutProportionalSpread on the Cost measure.
Because I don't want modify the Year consolidated value, I hold by process, the year consolidated cell
But, when, after hold the year consolidated cell, i perform the first spread on January, for example, I noticed, logging with ASCII output using the hold cube created for my user, that Year consolidation is deleted!
(the cell in the hold cube is not 'C' but it is null)
If I comment the CellPutProportialSpread line I find all the cells exptected as hold (so, it is good)
If I uncomment that line, cells are not hold and values is incorrect because the year value is changed (because the hold is lost)
Have you experience with this strange behavior?
Below I put my simple code:
Thanks in advance for you precious advices
Regards
In my cube with Customers , Year/Month dimensions and measures(revenue ,cost and others) I would like, by a simple TI process, copy values from a generic measure A and paste it into Cost measure.
So, I wrote a process which uses as data source a view for the Measure A where a few values are different by null or zero and, for each iteration in the Data tab, perform a CellPutProportionalSpread on the Cost measure.
Because I don't want modify the Year consolidated value, I hold by process, the year consolidated cell
But, when, after hold the year consolidated cell, i perform the first spread on January, for example, I noticed, logging with ASCII output using the hold cube created for my user, that Year consolidation is deleted!
(the cell in the hold cube is not 'C' but it is null)If I comment the CellPutProportialSpread line I find all the cells exptected as hold (so, it is good)
If I uncomment that line, cells are not hold and values is incorrect because the year value is changed (because the hold is lost)
Have you experience with this strange behavior?
Below I put my simple code:
Code: Select all
CUB = 'My CUBE';
Dim = 'Time';
Hold = '}Hold_' | TM1User() | '_}}_' | CUB;
# Copy the value
v=CellGetN(CUB, Customer, Time, 'Measure A');
# Remove the possible hold on the destination
CellPutS('', Hold, Customer, Time, 'Cost', 'HoldStatus');
# Proportional Spread on the destination
CellPutProportionalSpread( v, CUB, Customer, Time, 'Cost');
#Hold the Cost value
if(DTYPE(Dim, Time)@='N');
s='H';
else;
s='C';
endIF;
CellPutS(s, Hold, Customer, Time, 'Cost', 'HoldStatus');
Regards
