Page 1 of 1
Can TI write to Consolidation level cell?
Posted: Thu Oct 11, 2012 6:05 pm
by jbcraigs
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.
Re: Can TI write to Consolidation level cell?
Posted: Thu Oct 11, 2012 6:10 pm
by mvaspal
Have a look at CellPutProportionalSpread
Re: Can TI write to Consolidation level cell?
Posted: Thu Oct 11, 2012 8:24 pm
by jbcraigs
Thanks Mvaspal
Re: Can TI write to Consolidation level cell?
Posted: Tue Oct 16, 2012 9:10 pm
by jbcraigs
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.
Re: Can TI write to Consolidation level cell?
Posted: Wed Oct 17, 2012 6:01 am
by Andy Key
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.