TM1 right question

Post Reply
mrdauduong
Posts: 52
Joined: Mon Sep 26, 2022 11:10 am
OLAP Product: Planning analytics
Version: PA 2.0.74.23
Excel Version: Excel 2016

TM1 right question

Post by mrdauduong »

hi,

my client have this trouble when i try to enter a value in this cell (this is a consolidated cell)
tm1 right question.png
tm1 right question.png (115.76 KiB) Viewed 800 times
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.
User avatar
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

Post by Steve Rowe »

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.
Technical Director
www.infocat.co.uk
MarenC
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

Post by MarenC »

Under capabilities, Is anything set against Consolidation Typein spreading?

Personally, I sleep better at night if this is set to deny :)
mrdauduong
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

Post by mrdauduong »

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.
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!
mrdauduong
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

Post by mrdauduong »

MarenC wrote: Wed Oct 12, 2022 11:04 am Under capabilities, Is anything set against Consolidation Typein spreading?

Personally, I sleep better at night if this is set to deny :)
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). :mrgreen:
Post Reply