TM1 Web Error: "Cannot locate the active book"

[sjokesson]

Hi,

Created an active form in excel, copied as "public" to TM1 9.5.2 application folder. TM1 portlet in Cognos 8.4.1 displays Excel perfectly, but when I try to change a dimension using SUBNM formula, I get this error message.

Found an IBM technote addressing this specific error:
"Solution 1: If the problem occurs only with only a certain dimension, then the order of the elements in the view can be important :
Open TM1 Architect and edit the view, trying to set some different elements in the top of the list.
Solution 2: You could try the following : In the cube attributes, fill the }ElementAttributes_}Clients and try different values.
Solution 3: Also changing the UniqueID of the TM1RptView-function and modifying the name-variable TM1RPTDATARNG(UniqueID) could solve the problem.
You should take a UniqueID which is still not used. To be safe about the last used UniqueID, perform a sample ActiveForm to the Sheet and then you know the last UniqueID.
Use the next one number for UniqueID and modify the TM1RptView-function and the TM1RPTRNG-name-variable."

Solution #1 doesn't apply, because my error occurs with more than one dimensions. Tried solution #3 (changing unique ID of TM1RptView function) but to no avail. I would try #2 but don't understand it.

One thing that may be possibly related: I had previously deleted a different spreadsheet stored in the same app folder, and now whenever I open the TM1 portlet in 8.4.1 I get an error saying that file is missing.

Thanks!!!

[sjokesson]

I just ran into a post by lotsaram saying "As a best practice when publishing to web all the data range except the first row where the rptrow formulas are should be deleted prior to saving as an application object."

Lotsaram: Thanks!!! This simple "best practice" eliminated the error.

[manoj928]

Hi,

I am running into same issue in websheet, if you could help me in finding the solution for it..As i searched lotsaram post, but didnt find anything .

So need your help.
Thanks
Manoj

[tomok]

The post you are referring to makes the point that when publishing an Excel active form report to TM1Web you should delete all the rows in the form below the first line where the TM1RPTROW formulas are located before publishing. They are completely unneccesary because when a user opens an active form and refreshes it, the rows are going to be re-drawn anyway. Leaving them in when publishing only makes the active form larger, filled with useless rows.