Entering Data in TM1 web on a C level Calc

Post Reply
hpansar
Posts: 17
Joined: Fri Apr 19, 2013 6:50 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2013

Entering Data in TM1 web on a C level Calc

Post 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
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Entering Data in TM1 web on a C level Calc

Post by jim wood »

Moved to the correct forum
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Entering Data in TM1 web on a C level Calc

Post 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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
hpansar
Posts: 17
Joined: Fri Apr 19, 2013 6:50 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2013

Re: Entering Data in TM1 web on a C level Calc

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