Start a Cognos Report on Command Line without entering user/password 1

[sevendays]

I would like to be able to run a cognos report from the command line for use with our current scheduler. Management wants to use the current scheduler rather than adding the Cognos scheduler into the mix.

The command line that I am using is as follows:
"C:\Program Files\Cognos\cer3\bin\ImpUser.exe" "\\Apps1\Cognos\Reports\TestCommand.imr"

My problem and question is that the report starts but the Catalog Logon for MyTables.cat pops up on the screen. Is there any way, or what is the best way, to either pass the user/password on the command line or have the report get started without the need to enter the user/password?

I want the reports to be able to run without manually entering into the logon. Any help would be appreciated.

Can a report macro be used to run when the report starts to supply the user/password info? If so I would appreciate some further info on how the macro would be written.

Thanks

 

[drlex]

sevendays,
It is possible to acheive 'auto-logon' by adding the OS sign-on(s) to the required user in Access Manager. I needed to do this as our servers are rebooted automatically at 3 a.m. and need to start Cognos builds straight after.
Post back if you need exact details.
lex


soi la, soi carre

 

[GJParker]

Hi drlex

Could you elaborate further on this technique please.

Thanks in advance

Gary Parker
Systems Support Analyst
Manchester, England

 

[drlex]

Gary,
No problem. It's bound to be in one of the pdfs, but 'fraid I can't point to it right now.

In Access Manager Administration, expand out the security method you use (Directory Server or LAE) to get to the Users Folder. Open the Properties of the User that you wish to give OS sign on to. Under the User Signons tab, there is a OS signon area. Click on 'Add' button to the right and enter the relevant format of your OS user profile - domain/userid or just userid. In my case, I have added both our (Network) Administrator and my personal userid to the Namespace Administrator User setting.

Now, when our Cognos server runs under our Adminstrator Network OS signon, it automatically is identified as the Namespace administrator. Therefore, it clears Cognos Common Windows log-on on the first time it runs a secured cognos product after reboot.

Hopefully the use of the word Administrator for both our Windows Network and Cognos products doesn't make the foregoing too confusing!

(For automatic rebooting of the server, it uses a batch file and a registry tweak to retain the OS log-on password.)

lex

soi la, soi carre

 

[GJParker]

Thanks Lex

Been looking for a way to do that for ages.

Top Tip

Gary Parker
Systems Support Analyst
Manchester, England

 

[drlex]

Thanks; you're welcome.

You'd think it would be made a bit more obvious by Cognos, but then perhaps User classes linked to Active Directory/corporate LDAPs dispense with the need for such. 'Twas one of those experimenting moments here .

soi la, soi carre