TM1 Forum

Hi,

When using TM1web the way I understand it works is as follows:
(in the web) a user clicks on the workbook in a particular application folder > example screenshot below:
The server knows which excel workbook to use in the }Externals folder by referencing the "SalesPlan.xlsx.blob" file in the "Sales" sub-folder under the }Applications folder on the file system.
When TM1Web renders this workbook in the web it creates the web version of this workbook in xml form and stores it here (default location)
C:\Program Files\ibm\cognos\tm1_64\tm1webex\ExcelSheet
My question is how do I know which xml file in this folder is being used for a particular workbook?
Sometimes the websheet is outdated and by updating the workbook using perspectives and checking on the web it seems the web is not updating the xml version of the (now updated) workbook - so I'm thinking I should remove the offending xml file and let TM1web recreate it?

Any ideas?
thanks guys.

You can delete all of them if you want. TM1 will just re-create the XML file in the fly if it doesn't exist when a user opens the websheet.

Thanks Tomok,

This means the websheets will take longer to open for all new views that need to then be created cause all XML files have to recreated. I was hoping to just target the appropriate file and not have to delete the whole lot, but thanks for your suggestion.

I can't ever recall seeing a situation where TM1 Web rendered an out of date Excel application file. IMO TM1 Web seems to do a pretty good job of keeping track of whether it has the most up to date xml to html or whatever of the Excel file.

HI Lotsaram,

Normally it does, but the specific instance I was dealing with was this:
The blob file pointed at a file (say sales_201301011234567.xlsx) and I updated the workbook to sales.xlsx and edited the blob file to point to this new workbook - using perspectives I picked up the new workbook no problems, but the xml version of this file was not refreshing in the web (it was still the old workbook). So I wanted to force TM1web to recreate the xml version of the file.
I know this is not the normal way of doing things but it was a time saving step rather than going through a change request process that takes over a week to complete.
I appreciate your inputs though, thanks.