Hi All,
I have a form that I can enter into as Admin, but users cannot. I have looked to ensure the users are in the proper write group, there is proper cube security, there is no dimension or element security on any of the dimensions or measures, there is no locks or holds, and the users are not set to read only.
I basically went through all the steps outlined in Wim Gielis's blog post and the users still can't enter in data. (https://www.wimgielis.com/tm1_cellchange_EN.htm)
Any advice on where to look next?
Thanks
Users unable to direct enter into a form
-
- Posts: 32
- Joined: Mon Jul 19, 2021 2:15 pm
- OLAP Product: TM1
- Version: 2.0.0
- Excel Version: 365
- Steve Rowe
- Site Admin
- Posts: 2460
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Users unable to direct enter into a form
Hi,
There's really only a couple of options here.
1. It is security and you've missed something in your analysis. It can't be locking as that would be impacting Admins too.
2. The view you're using as admin and as end user is different (i.e. consolidated / not at the lowest level) and so the cell is not updateable.
I don't think there are any other options really.
There's really only a couple of options here.
1. It is security and you've missed something in your analysis. It can't be locking as that would be impacting Admins too.
2. The view you're using as admin and as end user is different (i.e. consolidated / not at the lowest level) and so the cell is not updateable.
I don't think there are any other options really.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Regular Participant
- Posts: 443
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: Users unable to direct enter into a form
Hi,
I guess the only other thing is to run Security Refresh in case you haven't.
Maren
I guess the only other thing is to run Security Refresh in case you haven't.
Maren
-
- Posts: 32
- Joined: Mon Jul 19, 2021 2:15 pm
- OLAP Product: TM1
- Version: 2.0.0
- Excel Version: 365
Re: Users unable to direct enter into a form
Thank you for the responses. I will keep digging
-
- Regular Participant
- Posts: 230
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: Users unable to direct enter into a form
Don't know if this setting applies to admins or not and whether it would fit what about the "Allow Write Back from tm1web" setting per the screenshot attached. It might be set to disallow
- Attachments
-
- Screenshot_20250807_174835.jpg (225.54 KiB) Viewed 208744 times
-
- Posts: 123
- Joined: Mon Jul 29, 2019 5:02 am
- OLAP Product: Planning Analytics
- Version: 2.0.9.x
- Excel Version: Office 365 16
Re: Users unable to direct enter into a form
Cell security?M1ndbender wrote: ↑Wed Aug 06, 2025 7:05 pm I have looked to ensure the users are in the proper write group, there is proper cube security, there is no dimension or element security on any of the dimensions or measures, there is no locks or holds, and the users are not set to read only.
Any advice on where to look next?
Thanks
Do you have a test environment where the users have access and where you can remove security stepwise (Refreshing security after each removal)?