TM1 Forum

I'm sorry for my "up" but unluckly i haven't yet found a solution... I verified more times that If I comment the CellPutProportionalSpread statement, cells are hold as I exptected. If I use the statement, uncommenting the line, the cell are not more hold. Only the last processed cell, in t...

What is the business problem that you are trying to solve? I need to perform, by a button in a PAW book, so using a TI process, a "copy & paste" of values from a measure to another using hold in order to "lock" values at the top level and using spread on the cells on which I...

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 ...

Hi all, In a budget view I have a %GrossProfit member calculated with a rule as usual as 1- Costs/Revenue*100 In particular, If I'm writing the budget for 2020, Costs refer to 2019 and Revenue to the Revenue of 2020 budget All works well in this scenario. BUT...now, I need to edit the %GrossProfit i...

Hi all, I need to spread a monthly budget in weeks using a proportonial relative spreading method based on the same data distribution related to the same period in the previous year. So, when I put a value at consolidated level of month, data are spread at leaf level (weeks) using equal spread when ...

Thank you so much for your replies.

Hi all, I developed a simple forecast application where I load actual data from data warehouse and I allow users to insert budget data in order to calculate forecast. I know that is possible "lock" cells related to actual data but I can't find how I can obtain this (perhaps I don't know th...