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
Entering Data in TM1 web on a C level Calc
- 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
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
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- 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
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:
Your question isn't completely clear but this does sound like the issue that you're dealing with.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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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.