Removing element level security completely
- wilsonric
- Posts: 15
- Joined: Mon Jan 10, 2011 4:36 am
- OLAP Product: TM1
- Version: 2.0.9
- Excel Version: 365 MSO 16-0-13127
- Location: Sydney, Australia
Removing element level security completely
I would like to remove element level security completely from a dimension.
Can I delete the "}ElementSecurity_fyday.cub" object when the TM1 service is stopped, and then restart without the object?
Is this safe? Is there a better way to do it?
Can I delete the "}ElementSecurity_fyday.cub" object when the TM1 service is stopped, and then restart without the object?
Is this safe? Is there a better way to do it?
Regards,
Richard
Richard
-
- MVP
- Posts: 3654
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Removing element level security completely
A very reasonable question. When it comes to completely removing element and cell security the only way to "safely and reliably" do it is to delete the control cube .cub file when the server is stopped then restart. Just make sure you have removed any downstream dependencies and back up before you go ahead.wilsonric wrote:I would like to remove element level security completely from a dimension.
Can I delete the "}ElementSecurity_fyday.cub" object when the TM1 service is stopped, and then restart without the object?
Is this safe? Is there a better way to do it?
-
- Posts: 33
- Joined: Mon Apr 09, 2012 8:31 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Removing element level security completely
Hello,
I have a similar question.
I want to delete all elements except a few from control dimension "}Clients".
Since its a control object, it cant be done manually. Can we create a subset of the elements we dont want to delete and then delete rest of them?
Which is the best way to do this.
Thanks,
Sukhen
I have a similar question.
I want to delete all elements except a few from control dimension "}Clients".
Since its a control object, it cant be done manually. Can we create a subset of the elements we dont want to delete and then delete rest of them?
Which is the best way to do this.
Thanks,
Sukhen
Suharsh....
-
- Site Admin
- Posts: 1454
- Joined: Wed May 28, 2008 9:09 am
Re: Removing element level security completely
Use DeleteClient in a TI process - see the Reference Guide.
Note you cannot delete Admin - I tried once .
Note you cannot delete Admin - I tried once .
-
- Posts: 33
- Joined: Mon Apr 09, 2012 8:31 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Removing element level security completely
Thanks for your reply David.
But I have a lot of Clients which I need to delete. I was looking for something where I could delete all but a few.
Is there any other way you think I could do it?
Somehting like Delete all......
Thanks,
Sukhen
But I have a lot of Clients which I need to delete. I was looking for something where I could delete all but a few.
Is there any other way you think I could do it?
Somehting like Delete all......
Thanks,
Sukhen
Suharsh....
-
- Regular Participant
- Posts: 164
- Joined: Tue May 04, 2010 10:49 am
- OLAP Product: Cognos TM1
- Version: 9.4.1 - 10.1
- Excel Version: 2003 and 2007
Re: Removing element level security completely
Can you create a subset of all the users you want to delete and use that a source for a TI process that deletes them with DeleteClient? If your problem is that you want to specify those not to delete rather than those to delete, you can look at using Except in MDX to create your subset.Sukhen Sharma wrote:Thanks for your reply David.
But I have a lot of Clients which I need to delete. I was looking for something where I could delete all but a few.
Is there any other way you think I could do it?
Somehting like Delete all......
Thanks,
Sukhen
-
- Posts: 33
- Joined: Mon Apr 09, 2012 8:31 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Removing element level security completely
Hello,
I am trying to create a subset using MDX Query. I created an expression through record Expression and it is working there.
But when I am trying to create a subset by using that MDX in TI process, I am not able to create that.
I want to ask a question. Is is possible to create a subset for control dimension.
I want to delete some clients from }Clients dimension, which is a control object. For this I am trying to create a subset of the elements which I want to delete. But Subset is not getting created.
Please help.
Thanks
Sukhen
I am trying to create a subset using MDX Query. I created an expression through record Expression and it is working there.
But when I am trying to create a subset by using that MDX in TI process, I am not able to create that.
I want to ask a question. Is is possible to create a subset for control dimension.
I want to delete some clients from }Clients dimension, which is a control object. For this I am trying to create a subset of the elements which I want to delete. But Subset is not getting created.
Please help.
Thanks
Sukhen
Suharsh....
-
- Regular Participant
- Posts: 164
- Joined: Tue May 04, 2010 10:49 am
- OLAP Product: Cognos TM1
- Version: 9.4.1 - 10.1
- Excel Version: 2003 and 2007
Re: Removing element level security completely
This could be for a number of reasons but hard to say why without more info. I know of no reason why this shouldn't be possible for a control dim though.Sukhen Sharma wrote:Hello,
I am trying to create a subset using MDX Query. I created an expression through record Expression and it is working there.
But when I am trying to create a subset by using that MDX in TI process, I am not able to create that.
The fact that you managed via the subset editor tells you that is.Sukhen Sharma wrote:I want to ask a question. Is is possible to create a subset for control dimension.
When you say you want to delete from the control dimension I've assumed you just want to delete the users from TM1 - is that right? If you're doing this as a one off, can you not just create the subset manually rather than doing so within the TI process? How many users are we talking about anyway?Sukhen Sharma wrote:I want to delete some clients from }Clients dimension, which is a control object. For this I am trying to create a subset of the elements which I want to delete. But Subset is not getting created.
-
- Posts: 33
- Joined: Mon Apr 09, 2012 8:31 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Removing element level security completely
Yes, I mean to delete the users from TM1. There are around 150 elements in the }Client dimension (150 Users).
I just want to retain 5 of them. Thus what I was intending is that I create a subset of all the elements except for these 5 and delete those elements.
Thus it is not possible for me to create a subset manually.
Thanks
I just want to retain 5 of them. Thus what I was intending is that I create a subset of all the elements except for these 5 and delete those elements.
Thus it is not possible for me to create a subset manually.
Thanks
Suharsh....
-
- Regular Participant
- Posts: 164
- Joined: Tue May 04, 2010 10:49 am
- OLAP Product: Cognos TM1
- Version: 9.4.1 - 10.1
- Excel Version: 2003 and 2007
Re: Removing element level security completely
Sorry but, I don't understand why it isn't possible. Why can't you just create the subset, using MDX if you want/need to, and then set your saved subset as the data source for a TI process?Sukhen Sharma wrote:Yes, I mean to delete the users from TM1. There are around 150 elements in the }Client dimension (150 Users).
I just want to retain 5 of them. Thus what I was intending is that I create a subset of all the elements except for these 5 and delete those elements.
Thus it is not possible for me to create a subset manually.
-
- Posts: 33
- Joined: Mon Apr 09, 2012 8:31 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2003
Re: Removing element level security completely
It looked strange to me even that why was I not able to create a susbset and delete it.
But thanks for the suggestion. I have now used the normal dimensiondeleteelement() function to delete those which I wanted to delete and it is working well.
Initially I thought that I would not be able to use this function to delete elements from Control Dimension, but good news is that It works fine.
Thanks all for your inputs.
Sukhen
But thanks for the suggestion. I have now used the normal dimensiondeleteelement() function to delete those which I wanted to delete and it is working well.
Initially I thought that I would not be able to use this function to delete elements from Control Dimension, but good news is that It works fine.
Thanks all for your inputs.
Sukhen
Suharsh....