Is there a way to extract the Security Clients/Group information to be placed in Excel?
***Running Cognos TM1 9.1.4***
Extracting Security
-
- 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
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