Page 1 of 1
Entering Data in TM1 web on a C level Calc
Posted: Thu May 03, 2018 1:25 am
by hpansar
Hi Everyone
Has anyone had any issues where in TM1 web you enter a value in a C level calculated field and it goes back to its original number? It happens on a few lines but some take the value in TM1 web. its very odd. Any insight would be greatly appreciated.
thanks
Hiten
Re: Entering Data in TM1 web on a C level Calc
Posted: Thu May 03, 2018 1:26 pm
by jim wood
Moved to the correct forum
Re: Entering Data in TM1 web on a C level Calc
Posted: Thu May 03, 2018 6:41 pm
by Alan Kirk
hpansar wrote: ↑Thu May 03, 2018 1:25 am
Has anyone had any issues where in TM1 web you enter a value in a C level calculated field and it goes back to its original number? It happens on a few lines but some take the value in TM1 web. its very odd. Any insight would be greatly appreciated.
The default behaviour for entering into a consolidated cell in Web
changed in 10.2.2 FP1. In the 9.5 days by default you could not enter a value into a consolidated cell and you couldn't do data spreading (other than Clear) on it. In 10.2.2 then as long as the correct }Capabilities cube value is set, then the spread will occur across the underlying consolidation. The operations manual speaks thusly:
TM1 Operations Manual wrote:Consolidation TypeIn Spreading grants or denies the ability to perform data spreading by typing directly in a consolidated cell in the TM1 web-based clients, including TM1 Web and TM1 Application Web. If this capability is set to Deny, users are prevented from typing in a consolidated cell to initiate a data spread.
However, when Consolidation TypeIn Spreading is set to Deny, users can still use the right-click menu to perform data spreading on a consolidated cell.
Note: This capability does not apply to the Cube Viewer in Architect or Perspectives, as typing directly in a consolidated cell is not allowed in these
clients.
This capability cannot be set to Deny for the ADMIN user group.
A blank setting is equivalent to Grant.
Your question isn't completely clear but this does sound like the issue that you're dealing with.
Re: Entering Data in TM1 web on a C level Calc
Posted: Thu May 03, 2018 8:26 pm
by hpansar
thanks Alan, I solved the issue. It was a spreadprecision parameter missing from the CFG file. I set it from 1e-8 to 1e-2 and my issue is now resolved.