ETL, App Development and other tools > COGNOS Access Manager

How to import User Classes in to Access Manager


Does any one know if there is a way to import the whole security structure for a particular application into Access Manager.
For example, our elist changed so much that we have to redo the whole structure in AM, I would like
to recreate it in Excel (using the information from the Elist, that is also being maintained in Excel)
and just load it somehow into AM.


You could use Access Manager Batch Maintenance:
You need to implement an excel macro to create AM batch commands and then use AM batch maintenance to run them.
Commands are simple, for example
   AddUserClass, "My userclass", "Root User Class"
creates userclass named "My userclass" under "Root User Class".

One word of caution: At least in Cognos 7.3 MR3 there is a bug in Sun LDAP server that might corrupt your namespace:
(document # 1013380.4). Fix is available.

Thanks Prikala,

I am going thru the user guide for AM Batch Maintenance to try to learn to do this.
Will report back.

So now I learned how to load anything that I need into AM by uploading the file thru the Batch Maintanance. ( I test loaded a few users...)

Now, how do systematicaly prepare the input file?
You mentioned excel macros to be used for creating commands for the file... can you explain.


Actually I have newer used excel macros, I am only quessing
macros could be used to create the input file from the data
in your Excel files: Maybe something like this: Loop through appropriate cells and generate commands into commandfile.
(I have not written macros so i can not provide a better example).

If you decide to write macros, you could skip batch maintenance and use accessmanager directly via macros(see AM macro reference, newer used it personally, just realized it exists).

My userdata is on database (oracle) so for example, userclass commands can be generated by spooling the output of asimple sql statement:
   select 'AddUserClass,"'||||'", "Root User Class"'
   from m_userclass;


[0] Message Index

Go to full version