Secured cube build thru VB

[spicysudhi]

hi

Dim objTransApp As CognosTransformer.Application
Dim objModel As CognosTransformer.Model
Dim objCubeItem As CognosTransformer.Cube
Set objModel = objTransApp.OpenModel("test.pyi")
Set objCubeItem = objModel.Cubes.Item("myCube")
objCubeItem.CreateMDCFile

The above code works fine when the model has not inherited the access manager security. My model has got user classes inherited and the script is prompting the Common Logon screen for user name and password.

Is there anyway, I can set the username and password automatically using script?

I think this would be by assigning the objModel.signon; but I am not able to do this.

thanks in advnc.

regards,
Sudhi

 

[drlex]

Sudhi,
I think that you need to .Login; the .signon displays the signon objects in Access Manager (e.g. for the .iqds).
Do you need to have the server authenticated in access manager when it boots so that secured models build ok? If so, you could add the logon details as an OS signon in Access Manager and then hack the Registry so that the server logs on OK on reboot.

soi la, soi carré

 

[spicysudhi]

sorry, i am confused by the second part of your reply.

wht i am trying to achive is to set the access manager signon properties to the model using code.

regards,
sudhi

 

[drlex]

sudhi,
Didn't mean to confuse you; I thought that by your question, you were trying to run cube build scripts which were hanging for want of entry of a valid cognos common logon. A way around such is to add the system logon details to access manager as an OS log on and to hack the system registry to include the system log on details. In this way, a cognos server can be rebooted and log in to Access manager automatically. This saves the need to add log-on details into each script.

As for what you are trying to do, will AccessManagerConfiguration property not assist? Object.Login property would seem to be for scripts that create a new model.

lex

soi la, soi carré

 

[spicysudhi]

thanks.

I think i solved it. I can pass the username, password and userclass while opening the model.

regards,
sudhi