TM1 Forum

Hi I found the problem, as so often it was in front of the computer, not inside (i.e. it was my fault) ;). In the source view I included with my regular BU dimension elements some elements which are filled via rules, so TI was trying to spread on rule calculated values, which cannot work. What surpr...

Hi Lotsaram Thanks for your reply! I am actually testing this with fairly simple values, I was trying to spread the value '2'. I found the function works fine when I delete all the rules in the cube, although I am sure no rule is touching the target area into which I want to spread (not even on C-Le...

Hi, I am trying to adjust some consolidated real values in my cube by using the CellPutProportionalSpread Function in TI. The formula looks like this: CellPutProportionalSpread( NewConsol, 'Sales', pVersion, pYear, vMonth, pCountry, vBU, 'All Solution Groups', 'All Verticals','All Segments','All End...

Hi I am wondering, if I run a TI process that amends figures on N-level in my cube, when would TI commit the changed values? For example, let's say I loop through all N-level real values of my cube and increase each of them by 10% using a CellPutN formula in TI, immediately after the CellPutN I read...

Hi I just read this thread because I am also wondering if TM1 9.4 FP3 would show increased write-back performance if I disabled hyperthreading on our quad core TM1 server. Cube-load and read performance is not the problem in our model, our bottleneck is write-back of values from excel and TI process...

Hi John, I am struggling with that exact same problem at the moment and haven't got a handle on it yet, unfortunately I am not sure if I understand the solution steps you propose. Would you explain a little more in detail please? thanks! Marc Cryptic Error Error: Prolog procedure line (8): Cell is n...