Page 1 of 1

Automatic Data Entry in Websheet, TM1 10.2

Posted: Fri Nov 28, 2014 4:50 pm
by tm123
Hi,

I am having issues with TM1 10.2, I have a websheet with an active form to capture data entry. Also I have an Action Button which runs a TI to copy/recalculate into another cube. The issue is that the cells that have been changed stay in "green" and they are not saved in the cube, so my TI process does not find the updated data in the cube. In Perspectives this is working fine, but not in TM1 web. Is there any way to commit the data into the cube before running my TI.
If the User Clicks the "Recalculate" button of TM1Web, data gets committed but I am trying to avoid that step.

Thanks

Re: Automatic Data Entry in Websheet, TM1 10.2

Posted: Fri Nov 28, 2014 9:43 pm
by lotsaram
The action button properties can calculate the sheet both before and after running a process. So this should allow any data entry to be committed before the process runs.

Re: Automatic Data Entry in Websheet, TM1 10.2

Posted: Fri Nov 28, 2014 10:23 pm
by tm123
Thank you lotsaram,

Can you please elaborate more in this one?
In my action button properties, i have selected "Automatically Recalculate Sheet" under Calculate Tab, and also I have selected the same under Process tab / Options ( just next to where you specify the TI process name) . I dont really know the difference of those 2, but both are selected. And when user runs the TI from TM1 web, it does not do the data commit. I never had this issue in 10.1 but in this version this is how it's working and its driving me crazy. Thanks again