Hi All,
I need to be able to lock a group of elements in a dimension so they can't be deleted/removed/added to but grant edit access to other groups of elements within the same dimension.
So i need to give a user group admin access to the dimension so they can edit the parts of the dimension they are using but protect the other parts of the dimension, ive tried setting a lock on the dimension elements but that doesn't seem to work. If i make the group a dimension admin that means the group can still edit the locked elements of the dimension.
Is it possible to have a dimension secured in this way?
cheers
Is it possible to secure part of a dimension
-
- MVP
- Posts: 214
- Joined: Tue Nov 11, 2008 11:57 pm
- OLAP Product: TM1, CX
- Version: TM1 7x 8x 9x 10x CX 9.5 10.1
- Excel Version: XP 2003 2007 2010
- Location: Hungary
Re: Is it possible to secure part of a dimension
Hi,
Admin can edit any element of the dimension regardless of locking.
A workaround could be to double your dimension:
1. Productive (your original dimension)
2. Developing: this would be edited by your user and the changes would be transferred to the productive dimension via a TI process which could check the locking and could prevent unwanted changes in your productive dimension.
Maybe others have better and more easy to maintain solution.
Regards,
Peter
Admin can edit any element of the dimension regardless of locking.
A workaround could be to double your dimension:
1. Productive (your original dimension)
2. Developing: this would be edited by your user and the changes would be transferred to the productive dimension via a TI process which could check the locking and could prevent unwanted changes in your productive dimension.
Maybe others have better and more easy to maintain solution.
Regards,
Peter
Best Regards,
Peter
Peter
-
- Community Contributor
- Posts: 126
- Joined: Sun Jun 29, 2008 9:33 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2016
- Location: Karlsruhe
Re: Is it possible to secure part of a dimension
I would not give users control to edit dimensions. The process has to be controlled by an administrator. There could be a template where users enter the elements in a structured way (leaf element, according parent element). The admin would integrate this template as a meta data source into the dimension build TI process.
Re: Is it possible to secure part of a dimension
Thanks for the replies,
experimenting some more it looks like there is no way you can lock a section of a dimension, we have a number of ideas of how to control the dimensions and are going to propose a system where you edit a copy of the dimension and then request those changes are made in the original dimension after those changes were accepted so im glad that has been echoed here, shows that we are thinking along the same lines.
Many Thanks
Greg
experimenting some more it looks like there is no way you can lock a section of a dimension, we have a number of ideas of how to control the dimensions and are going to propose a system where you edit a copy of the dimension and then request those changes are made in the original dimension after those changes were accepted so im glad that has been echoed here, shows that we are thinking along the same lines.
Many Thanks
Greg