hi,
my client have this trouble when i try to enter a value in this cell (this is a consolidated cell)
right now, the only thing that i can do is give him a admin right, if not, he can not write in this cell.
i need to solve this probleme as soon as possible. and i have no idea why. any help will be appreciated !
List of my check :
- }CubeSecurity : ok
- }CellSecurity_CUBE : ok
- }DimensionSecurity : ok
- }ElementSecurity_DIMENSION : ok
- }ClientProperties : ReadOnly : empty
- No holds, lock of reservation
- Allow write back in workspace : yes
- no Security overlay
- Capabilities : Allow Spreading for all groups
what iam missing? thank!
thank a lot.
TM1 right question
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
- Steve Rowe
- Site Admin
- Posts: 2417
- 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: TM1 right question
Looks like you are trying to do a spread, i.e. data entry at the C level. Judging from the error message the user doesn't have write access at the C level intersections in the view.
So I'd say recheck the security model but make sure you consider that they need WRITE access at the C level to do so.
I couldn't see anything in the cfg that might be blocking this.
So I'd say recheck the security model but make sure you consider that they need WRITE access at the C level to do so.
I couldn't see anything in the cfg that might be blocking this.
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- Regular Participant
- Posts: 350
- Joined: Sat Jun 08, 2019 9:55 am
- OLAP Product: Planning Analytics
- Version: Planning Analytics 2.0
- Excel Version: Excel 2016
Re: TM1 right question
Under capabilities, Is anything set against Consolidation Typein spreading?
Personally, I sleep better at night if this is set to deny
Personally, I sleep better at night if this is set to deny
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: TM1 right question
thanks for the help Steve, i check again in }ElementSecurity_DIMENSION and i found the probleme, i dont have write acces at the C level. i add this and it worked!Steve Rowe wrote: ↑Wed Oct 12, 2022 10:56 am Looks like you are trying to do a spread, i.e. data entry at the C level. Judging from the error message the user doesn't have write access at the C level intersections in the view.
So I'd say recheck the security model but make sure you consider that they need WRITE access at the C level to do so.
I couldn't see anything in the cfg that might be blocking this.
-
- Posts: 52
- Joined: Mon Sep 26, 2022 11:10 am
- OLAP Product: Planning analytics
- Version: PA 2.0.74.23
- Excel Version: Excel 2016
Re: TM1 right question
Thank Maren, i have the same opinion as you, the reason that i allow the user to type in C element is : they are typing in a cube Reporting that have only static data (sended by TI from another cube).