TM1 Forum

I just resolved an issue yesterday on our test environment that might be related. I found a fix IBM released in June 2010 for API developers. The issue is related to java and the applix cert. I emailed IBM support to let them know. I'm guessing they will be seeing more of it. I was getting this erro...

I just had the same issue when I opened a multisheet workbook on the server. I noticed autocalc was on when I opened it. I killed the workbook without saving changes (so I didn't save it with autocalc on). Then, I turned off autocalc, reopened the workbook and pressed F9. It calculated without cycli...

Using TM1Web 9.4 on test server 64bit (vmware) Zooming: When zooming out on Excel reports with frozen panes, the frozen panes (columns and rows) show only white space where the extra viewable area should be. The areas not frozen display correctly. Exporting: When exporting to Excel or PDFs the colum...

Can you select the cell and then use sendkeys.

SendKeys "{F2}"
SendKeys "{ENTER}"

Maybe you could you have 3 variables: v1 = dimnm('your dimension',dimsiz('your dimension')+if you need to add anything to get the last element); v2 = 1+stringtonumber(v20)*1; v3 = if(long(numbertostring(v2))=1,'0000000'|numbertostring(v2),if(long(numbertostring(v2))=2,'000000'|numbertostring(v2),if(...

I use cell references in subnms to update the default months on my tm1web files. For example subnm("months","dashboard_months",D4) where D4 is the referenced cell that dynamically changes to the last closed month. They can still pick a different month, but the sheets always defau...

Maybe you could write some vba to do a find and replace of =d with '=d on the hidden rows. If you insert the single quote it won't calculate and then you can remove it when you want it to calculate.