How to run Visualizer via Cognos script ? 1

[Recce]

Hi, is it possible to run Visualizer in Cognos Script and if it is then, where can I get code examples ? :->
Thx

 

[flex13]

What are you trying to do exactly? The only things that you can do via automation are Administrative duties.

Flex

 

[Recce]

Hi Flex, ok, you see, we have problems launching and killing Visualizer via NT scheduler because we would like to automate the proces of bringing up new graphs on a dashboard on an hourly basis. The kill function via NT scheduler brings up an error so, I was hoping I could create an object.application in script and then manage the application by quiting it and then setting it to nothing and then reating the object again.Hope this makes sence. Thanks for your reply :->

 

[CognosProfessional]

The following macro fails in its task to disable a user's access to a Visualization.

Sub Main()

Dim objVizSrvAdmApp as Object
Set objVizSrvAdmApp = CreateObject("VizSrvAdm.dll&quot
varApp = objVizSrvAdmApp.Login("Servername", "&quot
objVizSrvAdmApp.EnableVisualization "Dashboard", false
Set objVizSrvAdmApp = Nothing
End Sub

When the macro is run, the following error occurs:

error code -1003.ERROR exception not handled by program.

Solution:

There are three possible solutions.

- Ensure that when Visualizer was installed, the custom component for Automation was also installed.

- In Cognos Series 7, the VizSrvAdm.dll for this component has to be manually entered into the Registry. Use regsvr32.exe from the command line to perform this task, for example:

regsvr32.exe "c:\Program Files\Cognos\cer1\bin\VizSrvAdm.dll"

- Ensure that the Cognos Visualizer Web Client is installed on the machine the Visualizer installation.

---------------------------------------------
Can I use Cubes from MS OLAP Services as data sources to populate a Visualizer model without using any other Cognos products and making a direct connection?

Solution:

You need to make a Powerplay "stub" cube or MDC file using Powerplay Connect to connect to an external OLAP source. PowerPlay Connect is included with Visualizer.

Here is an extract from the Installation Guide about the tools installed with Visualizer -

Installation Guide 9. Cognos Visualizer Tools. The Cognos Visualizer tools include:

.Configuration Manager
Use to configure any Cognos Series 7 component or to configure multiple components at once. For example, you can stop all your Cognos Series 7 services simultaneously.

.Access Manager Configuration Wizard
Use to specify your authentication source to Access Manager. The default installation automatically specifies the Default namespace in Netscape Directory Server as the authentication source.

.Access Manager Registration Wizard
Use to register a trusted signon plug-in with Access Manager.

.Access Manager Batch Maintenance
Use to automate maintenance tasks required to manage security in Access Manager.

.Cognos Script Editor
Use to write, compile, and run macros in the CognosScript language. You can create a user interface for your macro applications using the CognosScript Dialog Editor.

.PowerPlay Connect
Use to connect to OLAP cubes built with third-party products.

CP