TM1 Forum

Hi,

I have a few websheets with active forms, where users will adjust data, and then I have an Action Button which will perform some calculations and move data to a Reporting cube. For some of the intersections, the active form returns lots of rows ( and columns ), and eventhough the execution time of TI on the back end is only 5-6 seconds, the overall time ( including the Websheet recalc time ), exceeds 15 seconds. The reason why is because it takes time to recalculate the websheet. And In the Action Button settings I have selected "Automatically Recalculate Sheet", on both settings ( Under Calculate Tab and also Under Process Options ).
Do I have to Select both these options? All I want to do is, commit the data entered by users before the TI runs because this data is being used as data source in my TI, but after the TI runs, I don't need to refresh, so one refresh would be enough.
I am having trouble to figure out which one of these options should I set to "Automatically Recalculate Sheet" and which one to "None".

I am using TM1 version 10.2.2, which is extremely slow. My View in Architect builds in a second, and I don't know what the heck TM1Web is doing.

Thanks

Usually I just select the option to Recalculate only under the first Tab ( Calculate ). This way you make sure that the data is committed before the TI kicks in. You can leave the other option unselected if the TI is not changing any of the data displayed in the websheet. I AGREE that this is very confusing and the TM1 documentation is not very helpful.

I am also dealing with large websheets used for data entry and it's slow

The first calculate option on the Calculation tab is to calculate before running the TI. Usually this is unnecessary unless there are parameters for the TI that are in formula driven cells which might need to have recalculation forced to ensure that the TI runs with the correct params.

The 2nd calculate option on the TI process tab is for after the TI has executed. This is only necessary if data to be presented in the sheet is changed by the process.

lotsaram wrote:The first calculate option on the Calculation tab is to calculate before running the TI. Usually this is unnecessary unless there are parameters for the TI that are in formula driven cells which might need to have recalculation forced to ensure that the TI runs with the correct params.

The 2nd calculate option on the TI process tab is for after the TI has executed. This is only necessary if data to be presented in the sheet is changed by the process.

If the websheet has an active form and if the user has entered adjustments in the active form and has not manually recalculated the sheet yet, then if I don't select the option on Calculation Tab, the TI process will not be able to see the updated date in the underlying cube. So for that reason, in all the action buttons that RUN a TI which will use the websheet data as datasource, I set that option to calculate the sheet.