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.
Websheet in TM1 APPLICATION not enable to edit data
-
- 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
- Attachments
-
- grayed cells. Values blocked
- 3. Application.JPG (122.16 KiB) Viewed 4199 times
-
- enable to add or edit values
- 2. Tm1Web.JPG (89.12 KiB) Viewed 4199 times
-
- Enable to add values
- 1. Perspective.JPG (79.45 KiB) Viewed 4199 times
-
- 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
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.
Edit - removed "gumpf" to just highlight key point.
Declan Rodger
-
- 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
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.
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.
-
- 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
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
-
- 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
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.
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.