TM1 Forum

I have created a tm1 websheet and i have publish it. It works fine in TM1 WEB, TM1 PERSPECTIVE, the cells are enable to edit the data and values are ok, but when trying to open it in TM1 application Web, cells seems to be blocked, the background of the cells are grey and I can not edit anything.

the opcion for write back is enable.

This problem was describe before by other user but no one found solution.

https://www.ibm.com/developerworks/comm ... 0014932943

Thanks.
See the attachment for reference.

Have you tried pressing the "take ownership" button (the little blue man symbol)... does pressing that open the cells for write access?

Edit - removed "gumpf" to just highlight key point.

yes, i have try that. nothing happen to these cells.
If you see the image of application, you will see first row is available to write, but the rest of cells are blocked. all of these rows have no rules, so i dont understand.

To be able to help you it would be beneficial if you could provide information surrounding what type of TM1 Application it is (central etc), what dimension the Application security is acting upon and how that dimension fits into each of the cells in question.

Hi,
I met the same issue and fixed it eventually.
ENV: TM1 10.1.1
Application: Central (developed by PM 10.1) published on TM1 applicaiton web
Dimensions: Organization, Location, Fiscal_year. Measurement

The issure was found that user need to have write permission on leaf level of two dimensions (organization and location, both have hierarchies).

In }ElementSecurity_Location and }ElementSecurity_Organization rule

Add []=S:IF((ISLEAF=1), 'WRITE' , 'READ') ;

Then both cube view and websheet properly work on TM1 Application web.