TM1 Forum

Hi all,
we are using Cognos 8 security in our TM1 environment. There are tens of user classes in CAM which are updated on daily base. It will be time consuming to create and update security assignments manually, therefore we want to load security assignments to TM1 automatically from file instead.

Is this possible? If yes, how to do that?

Thanks,
Vladino

vladino wrote:Is this possible? If yes, how to do that?Vladino

Security in TM1 is stored in cubes with the names }CubeSecurity, }DimensionSecurity and }ElementSecurity_NameOfDimension. You can update the data in these cubes with a TI process the same as you can update any other cube. Just make sure you do a SecurityRefresh command afterwards, as well as designate the TI process as having security access.

tomok wrote:Security in TM1 is stored in cubes with the names }CubeSecurity, }DimensionSecurity and }ElementSecurity_NameOfDimension. You can update the data in these cubes with a TI process the same as you can update any other cube. Just make sure you do a SecurityRefresh command afterwards, as well as designate the TI process as having security access.

That's interesting.

And what if user group from CAM hasn't been imported into TM1 yet? Does this mean that we need to create a new member in }Groups dimension first and then update }CubeSecurity cube?

vladino wrote:And what if user group from CAM hasn't been imported into TM1 yet? Does this mean that we need to create a new member in }Groups dimension first and then update }CubeSecurity cube?

How are you going to write values to an element that doesn't exist??????