Extracting Security

Post Reply
nmiller
Posts: 18
Joined: Tue Jul 02, 2013 1:32 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2010

Extracting Security

Post by nmiller »

Is there a way to extract the Security Clients/Group information to be placed in Excel?

***Running Cognos TM1 9.1.4***
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Extracting Security

Post by declanr »

Depends exactly what you want to see and what you want to do with it but if you just want the total users and their group assignments you can just do an asciioutput on the }ClientsGroups cube. Pretty much any other user/security info you want with also be in the control cubes.
Declan Rodger
Post Reply