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
Automatic Data Entry in Websheet, TM1 10.2
-
- MVP
- Posts: 3706
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Automatic Data Entry in Websheet, TM1 10.2
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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 132
- Joined: Thu Oct 23, 2014 10:15 pm
- OLAP Product: tm1, cognos bi
- Version: 10.2
- Excel Version: 2010
Re: Automatic Data Entry in Websheet, TM1 10.2
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
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