Skip Headers
Oracle® Argus Insight Cognos Installation Guide,
Release 6.0
E18251-01
  Go To Table Of Contents
Contents

Previous
Previous
 
Next
Next
 

1 Introduction

1.1 Introduction

Argus Insight is a highly optimized reporting module that compliments Argus Safety. The Argus Insight Extract Transfer and Load (ETL) engine extracts data from the Argus Safety database and populates a data warehouse in a format to enable efficient querying. The various query, drill-down, and output features of Argus Insight let you analyze your safety, workflow, or product data from all angles and produce reports that provide immediate business impact and maximum efficiency in decision-making.

The following table describes the conventions that are used in this manual.

Convention Description
Bold User interface elements like Buttons, Dialog boxes, Check boxes, Combo boxes, Drop-down lists, Labels, Option (Radio) buttons, Tabs, Text boxes, etc.
Note: Information that should be noted before proceeding.
Important! Important information that must be noted to ensure accurate, reliable, or safe behavior of the system.
Tip: Information that enables easier completion of the current task or helps in completing other tasks.

This chapter includes the following topics:


Note:

Power Reports has been renamed Argus Insight and the two terms have been used interchangeably in this document.

1.1.1 Argus Insight Product Overview

In Argus Insight, you can generate a report in either of the following ways:

  • Through a query, retrieve a set of specific type of cases (Case Series) from the datamart and then run the report on only those cases.

    Use these Argus Insight components to retrieve the Case Series: Query By Example (QBE), Filters, and Advanced Conditions. Next, run one of these reports on the Case Series: the built-in Standard Reports or the custom reports you create and store in the Report WriterLibrary.

  • Run the report on all the cases in the datamart.

Use these Argus Insight components to directly query the datamart and run reports: Cubes and Report Writer. Another component that directly generates reports from the datamart is Dashboard Indicators. Dashboard Indicators are pre-configured by the administrator.

The following flowchart shows the typical for generating a report.

Surrounding text describes flowchart.gif.

The table that follows describes the various components of Argus Insight:

Component Description
Query by Example (QBE) Lets you create simple queries by entering specific values in fields on a form that looks substantially like the Argus Safety case form
Filters Lets you create queries by selecting a set of predefined fields and specifying multiple values in a field
Advanced Conditions Lets you create complex queries by selecting any of the various different fields in the datamart and applying Boolean and Set operations on them
Case Series A list of cases that match the query criteria
Standard Reports Predefined reports built into Argus Insight

These reports are grouped into these categories:

  • Compliance

  • Management

  • Pharmacovigilance

  • Configuration

  • General

Typically, these reports are run on the Case Series

Report Writer Lets you query the datamart and create custom reports by selecting any datamart fields as report columns. In the report output, you can apply filters, create nested groupings, and perform operations such as sort, total, count, and drill

The custom reports you create can be stored in the Report Writer Library or added to the Argus Insight application; you can run the stored reports on a Case Series.

Cubes Lets you run complex queries on the datamart and statistically analyze, drill-down, and explore the results

Argus Insight has six predefined Cubes: Reporting -Compliance, Workflow, Pharmacovigilance-PV Detail, Pharmacovigilance-PV General, Pharmacovigilance-PV Clinical, and Pharmacovigilance-PV Interaction

Dashboard Indicators Special reports that provide an insight into key parameters that let you monitor product performance and workflow efficiency.

Dashboard Indicator reports are pre-configured by the administrator and are generated directly from the datamart.


1.1.2 Hardware and Software Requirements

The following table summarizes the hardware and software requirements for Argus Insight components.

Hardware and Software Requirements
Argus Insight Web Server Software Requirements:
  • Operating System: Windows 2003/2008 Server - Service Pack 2 (Standard / Enterprise)

  • SOAP Tookit 3.0

  • Oracle v11.1.0.7 (Client) (with SQL Plus, SQL Loader, Oracle and OLEDB Objects)

  • Oracle Data Provider for .Net v11.1.0.7.20

  • Microsoft Internet Explorer 7.0/8.0

  • IIS 6.0/7.0

  • Note: For IIS 7.0, IIS 6.0 compatibility pack should also be installed.

  • Dotnet Framework 3.5 Service Pack 1

  • Microsoft Visual C++ 2008 Redistributable

  • MSXML 6.0

    Note: The Web server should be configured for SMTP.

Hardware Requirements:

  • Up to 5000 cases in the system: 2x2.6 GHz, 4 GB Memory

  • More than 5000 cases in the system: 4x2 GHz, 8 GB Memory

Cognos Server Software Requirements:
  • Operating System: Windows 2003/2008 Server - Service Pack 2 (Standard / Enterprise)

  • Oracle Client v11.1.0.7 (with SQL Plus, SQL Loader, Oracle and OLEDB Objects)

  • Oracle Data Provider v11.1.0.7.20

  • Microsoft Internet Explorer 7.0/8.0

  • IIS 6.0/7.0 (With ASP.Net)

  • Note: For IIS 7.0, IIS 6.0 compatibility pack should also be installed.

  • SOAP Toolkit 3.0

  • Cognos 8.4.1 BI Server (Default installation with all components except Cognos Content Database)

  • Cognos 8.4.1 BI Modeling (Default installation with all components)

  • Cognos 8.4.1 SDK (Default installation with all components)

Note: Argus Insight 6.0 does not support Cognos 8.3.

Software Requirements for Cubes with Cognos 8:

  • Cognos 8.4.1 Transformer (For Cubes other than Cognos Series 7.4) (Default installation with all components)

Software Requirements for Cubes with Cognos Series 7.4:

  • Directory Server for Cubes 7.4 (supplementary software)

  • Power Play Enterprise Server 7.4 MR2 (Default installation with all components)

  • Power Play Transformer 7.4 MR2 (Default installation with all components except Architect)

Hardware Requirements:

  • Up to 5000 cases in the system: 2x2.6 GHz processors, 4 GB Memory

  • More than 5000 cases in the system: 4x2 GHz processors, 8 GB Memory

Database Server Software Requirements:
  • Operating System: Windows 2003/2008 - Service Pack 2 (Standard/ Enterprise)

  • Oracle Server v11.1.0.7 (Enterprise)

Hardware Requirements:

  • Up to 5000 cases in the system: 2x2 GHz, 4 GB Memory

  • More than 5000 cases in the system: 4x2 GHz, 16 GB Memory

Argus Insight Client Software Requirements:
  • Microsoft Excel 2003 SP2/2007

  • Adobe Acrobat Reader v7.0/8.1.0/9.0

  • Windows XP Professional - Service Pack 3/ Windows Vista Service Pack 1

  • Microsoft Internet Explorer 6.0 SP3 (XP) / 7.0 SP3 (XP and Vista)/8.0

Hardware Requirements:

  • 2.0 GHz Minimum, 1 GB Memory


1.1.3 Important Installation Information

Before installing Argus Insight you need to be aware of the following:

  • All softwares must be installed using the language as English. For example, if Oracle is installed in a language other than English, the registry entries are created with different names. Hence, to avoid errors, install all softwares in English.

  • Ensure that you have disabled the firewall on the Cognos Web Server. If the firewall is enabled, ensure that Cognos is accessible from other machines on the network.

  • Ensure that either you have disabled the firewall on the Argus Insight Web Server or you have added the Argus Insight Port Number in the Windows Firewall Exception list. The default Port Number for Argus Insight is 8084.

  • Cookies must be enabled to the lowest possible security level on Argus Insight client to run the Argus Insight.

  • Single Sign-on will work only if the password for all the applications (Argus, Console, Argus Insight etc.) is same.

  • All the servers used should be in the same time zone.

  • Single Sign On (through SiteMinder) in Argus Safety does not work if Cognos is LDAP enabled. In this scenario, you will be presented with the Argus Insight Login screen.

  • Windows 2003 Service Pack 2 should be executed after the IIS installation. If Windows 2003 Service Pack 2 is already installed before the IIS installation, then make sure to re-run the Windows 2003 Service Pack 2 after the IIS installation.

  • Oracle client should be installed with the default Oracle Home Name, provided by the Oracle installer. Failure to do so can display an error message, stating that the Oracle OLE DB provider was not found during installation.

  • Javascript must be enabled on Argus Insight Client machine.

  • Make sure that the Internet Explorer setting Allow script-initiated windows without size or position constraints is enabled on the client machine at the following location:

  • Internet Explorer -> Tools -> Internet Options -> Security Tab -> Custom Level -> Miscellaneous.

  • Argus Insight URL must be added to the trusted sites on the Client machine.

  • On the Argus Insight Web Server, Oracle Client installation should be done after the installation of the Dotnet Framework.

  • All the servers must have the default language settings enabled for US English.

  • During installation verification, the system shows that files from Cognos 8 folder are missing. Users can ignore this error.

  • If you are unable to open the Cognos Report Writer from Argus Insight using Internet Explorer 8, execute the following steps on each Argus Insight client machine where this issue is encountered:

    Open Internet Explorer and go to Tools -> Internet Options.

    Click the Security tab and add the Argus Insight URL under Trusted Sites -> Sites.

    Within the Security tab, go to Trusted Sites and click Custom Level -> Scripting -> Enable XSS Filter.

    Select the Disable radio button and click OK.

    Click OK in Internet Options to save the changes and exit.

  • Execute the procedure below to enable this feature.

    Run regedit in the run command

    Go to HKEY_USERS -> .DEFAULT -> Control Panel-> International

    Select sCountry from the right pane. Set this entry as United States.

    Press OK to overwrite.

    Reboot the server.

    These settings will set the language for the default user profile as U.S. English.