Websheet in TM1 APPLICATION not enable to edit data

Post Reply
Jose.Mong
Posts: 4
Joined: Mon Dec 24, 2012 4:09 am
OLAP Product: TM1
Version: 9.52 10.1
Excel Version: 2003 2007
Location: Panama

Websheet in TM1 APPLICATION not enable to edit data

Post by Jose.Mong »

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.
Attachments
grayed cells. Values blocked
grayed cells. Values blocked
3. Application.JPG (122.16 KiB) Viewed 4195 times
enable to add or edit values
enable to add or edit values
2. Tm1Web.JPG (89.12 KiB) Viewed 4195 times
Enable to add values
Enable to add values
1. Perspective.JPG (79.45 KiB) Viewed 4195 times
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Websheet in TM1 APPLICATION not enable to edit data

Post by declanr »

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.
Declan Rodger
Jose.Mong
Posts: 4
Joined: Mon Dec 24, 2012 4:09 am
OLAP Product: TM1
Version: 9.52 10.1
Excel Version: 2003 2007
Location: Panama

Re: Websheet in TM1 APPLICATION not enable to edit data

Post by Jose.Mong »

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.
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Websheet in TM1 APPLICATION not enable to edit data

Post by declanr »

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.
Declan Rodger
Brian_Q
Posts: 9
Joined: Fri Jul 25, 2014 1:08 pm
OLAP Product: Cognos BI & TM1
Version: 9.5+10.1+10.2
Excel Version: 2007+2010

Re: Websheet in TM1 APPLICATION not enable to edit data

Post by Brian_Q »

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.
Post Reply