Arul's.TEG Blog

Create a .txt file with comma separated values with the following parameters for each user class : Parameter 1 : A, C or D. A is for add a user, C is for changing existing user parameters and D is for deleting a user. Parameter 2 : User Name [required] Parameter 3 : User Name Description [required] Parameter 4 : Basic Signon Name [optional] Parameter 5 : Basic Signon Password [optional] Parameter 6 : OS Signon Domain [optional] Parameter 7 : OS Signon User Name [optional] Parameter 8 : User Class [required] Parameter 9 : User Class Description [optional] Example: A, Batch, This is user 1, Batch, Batch, EUROPE, myname, BatchTest, Created from Notepad A, User, , , , EUROPE, myname, OSOnly, D, User, Call up AccessAdmMaint.exe or perform Start/Programs/Cognos BI/Access Manager Batch Maintenance. Specify the namespace to make modifications to. Enter a valid Administrator ID. Enter password. Select your input file : NewClassFile.txt Select the add User Class File radio...

How to extract the Namespace data: Refer blog >> How can you extract all user information from Cognos Access Manager Namespace Report Utility and create Cognos Report out of it? After import xml file into spread sheet, this is the way to interpret. About the data: - You will see multiple rows for each user, example, if the user associated with 4 user class 2 Data source then you will see 4 rows for user class, 2 for data source and additional 5 more rows o one for public o one for roles either - Administrator, Author , Consumer etc o one for Basic Signon (Note – NO BasicSigon Included in access manager – No rows appears) o one for OsSignon o one for Description – if its filled in - Use name2 column and filter on Administrator, Author , Consumer etc - When you apply filter on name2, you may get additional rows with name2 column empty and name3 column filled, this means they have access to those data source. The Access Manager Administration Guide (Appendix A) contain...

The AM_NamespaceReport Utility allows you to extract the namespace to an XML file. 1. Use the AM_NamespaceReport Utility to extract all users from the namespace to an XML file. am_namespacereport -h > -p > -r > -n > -D > -w > -f all -o > e.g am_namespacereport -h cognoscamsevr -p 4004 -r o=cognos.com –n devcam -D admin -w admin -f all -o c:\temp\usrlst.xml 2. This will extract all user information to an XML file 3. Import the xml file into XLS spread sheet 4. Create ODBC connection using the ms-excel spread sheet driver 5. Create Data Source Connection and proceed creating FM Model & Publish 6. Create Report using Report Studio. 7. Save & Share the report The Access Manager Administration Guide (Appendix A) contains further information on this functionality.