Entering Data in TM1 web on a C level Calc

[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

[jim wood]

Moved to the correct forum

[Alan Kirk]

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:

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.

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