In contributor, it is possible to manually enter data at a consolidated level cell. Data automatically breaksback to the child elements proportionally.
Can TI be used to write values to a consolidated cell through CELLPUTN or any other function?
Thanks.
Can TI write to Consolidation level cell?
-
- Community Contributor
- Posts: 341
- Joined: Wed Nov 03, 2010 9:16 pm
- OLAP Product: tm1
- Version: 10 2 2 - 2.0.5
- Excel Version: From 2007 to 2013
- Location: Earth
Re: Can TI write to Consolidation level cell?
Have a look at CellPutProportionalSpread
-
- Posts: 24
- Joined: Thu Nov 11, 2010 4:38 am
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Can TI write to Consolidation level cell?
Thanks Mvaspal
-
- Posts: 24
- Joined: Thu Nov 11, 2010 4:38 am
- OLAP Product: TM1
- Version: 9.5.1
- Excel Version: 2007
Re: Can TI write to Consolidation level cell?
The CellPutProportionalSpread works great. But if I try to run it in TM1 Contributor through an action button embedded in Websheet, the function does nothing. If I open the same websheet in Perspective or TM1 Web, the process works fine.
Is there any additional configuration I need to do for it to work in Contributor interface?
Thanks.
Is there any additional configuration I need to do for it to work in Contributor interface?
Thanks.
-
- MVP
- Posts: 352
- Joined: Wed May 14, 2008 1:37 pm
- OLAP Product: TM1
- Version: 2.5 to PA
- Excel Version: Lots
- Location: Sydney
- Contact:
Re: Can TI write to Consolidation level cell?
I think you would need to be making sure that the TI is running against the appropriate sandbox. My guess would be that the action button is trying to run against Base, but from within Contributor you don't have direct access to it.
Andy Key