TM1 Forum

Thank you very much for your helpful suggestions!

Thanks for your fast Reply. I think the answer to this will be no in a single cube, TM1 holds data at the N level so if you somehow made this zero then the C level value would be lost as well since there would be nothing to add up. Off the top of my head something like this should work. 1. Create a ...

Hi, I've one more challenge. My cube has two dimensions, measures and items with some c and n elements. One measure per example is "rebates", which should be planned for all items. The other measure "budget" is only planned on c element level. The requirement is, that the budet v...

Hi, thank you for your fast reply. What if I've already done this? I've attached my TM1web_config.xml and Excel settings (sorry, it's in german). I've restarted the tm1 Service and uploadet the Excel sheet into tm1 Web - but the automatic recalc is still enabled. Do you have any ideas why? Thanks

Hi community, how can I deactivate the automatic Recalc in TM1 Web? Typing data in consolidated elements in TM1 causes an immediate calculation (breakback on the children). I want TM1 Web to wait with the calculation until I press the recalc button. Is this possible? I already tried to set the param...

Hi, thanks for your help. I tried to build a small demo case in the way you described below, but I'm not sure whether I did this in the right way. I've created a very small cube (Cube_Price) with only two dimensions products (Sum, Prod1, Prod2) and price (Price). Then I've created a second cube with...

Hi, I have a question about calculations in TM1. In Enterprise Planning we have the possibility to type values in calculated measures, which is not possible in TM1. e.g. Quantity * Price = Revenue In EP and TM1 I can change the Quantity and the Price to get a new Revenue - in EP I can change the Rev...