Skip Headers
Oracle® Argus Insight Installation Guide
Release 7.0.1

E28479-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

1 Introduction

Argus Insight is a highly optimized reporting module that compliments Argus Safety.

The Argus Insight Extract Transform 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.

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 Argus Insight Product Overview

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

You can use the Report Writer to query the data mart directly and run reports.

The following flowchart shows the typical workflow for generating a report.

Surrounding text describes flowchart.gif.

Table 1-1 describes the various features of Argus Insight:

Table 1-1 Argus Insight Features

Features 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 data mart 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:

  • Case Processing (for use with BusinessObjects only)

  • Compliance

  • Configuration

  • General

  • Management

  • Pharmacovigilance

Typically, these reports are run on the Case Series.

Report Writer

Lets you query the data mart and create custom reports by selecting any data mart 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.


1.2 Software and Hardware Requirements

Table 1-2 lists the software and hardware requirements for the following components in an Argus Insight installation:

Table 1-2 Argus Insight Software and Hardware Requirements

Component Requirements

Argus Insight Web Server

Supported Operating Systems:

  • Windows 2008 Server (32-bit or 64-bit), Service Pack 2, Enterprise (English version)

  • Windows 2008 Server (32-bit or 64-bit), Service Pack 2, Standard (English version)

Oracle Database Software:

  • Oracle Client 11.2.0.1 or 11.2.0.3 (with SQL Plus, SQL Loader, Oracle and OLEDB Objects)

  • Oracle Data Provider for .Net 11.2.0.1 or 11.2.0.3

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

Additional Software Requirements:

  • Dotnet Framework 3.5 Service Pack 1

  • IIS 7.5 (IIS 6.0 compatibility pack should also be installed)

  • SOAP Tookit 3.0

  • Microsoft Internet Explorer 7.0, 8.0, or 9.0

  • Adobe Reader 9.0.3

  • Microsoft Visual C++ 2008 Redistributable

  • MSXML 6.0

Note: The Argus Insight Web Server should be configured for Simple Mail Transfer Protocol (SMTP) for email support.

BusinessObjects XI Requirements:

If you are using BusinessObjects XI (BOXI) with Argus Insight, you need a BusinessObjects XI, Release 3.1, Service Pack 4 client on the Argus Insight Web Server.

Cognos or Business Objects Server

You can use either IBM Cognos 8 or SAP BusinessObjects as your Business Intelligence tool with Argus Insight.

Supported Operating Systems: Same as the Argus Insight Web Server

Oracle Database Software: Same as the Argus Insight Web Server

Hardware Requirements: Same as the Argus Insight Web Server

Additional Software Requirements:

  • Dotnet Framework 3.5 Service Pack 1

  • IIS 7.5 (IIS 6.0 compatibility pack should also be installed)

  • Microsoft Internet Explorer 7.0, 8.0, or 9.0

Reporting Tool (if you are using Cognos):

  • 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)

  • SOAP Tookit 3.0

Reporting Tool (if you are using BusinessObjects):

  • BusinessObjects XI, Release 3.1, Service Pack 4 (for single tenant installations only). The server should be installed with both IIS and JSP enabled.

  • Apache Tomcat 5.0.27 (default installation on BOXI) / WebSphere 6.0

Database Server

Supported Operating Systems:

  • Windows 2008 Server (32-bit), Service Pack 2, Enterprise, (English version)

  • Windows 2008 Server (32-bit), Service Pack 2, Standard, (English version)

  • Oracle Enterprise Linux x86 (Version 5.5.0.0.0, English)

  • Oracle Enterprise Linux x86-64 (Version 5.5.0.0.0, English)

  • Oracle Solaris 10 (English version)

Oracle Database Software:

  • Oracle Database 11.2.0.1 or 11.2.0.3, Enterprise

Note: Cognos Content Store for Argus Insight is not supported by Cognos on Oracle Database 11.2.0.3 database when installed on the Oracle Enterprise Linux operating system.

Hardware Requirements:

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

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

Argus Insight Client

Supported Operating Systems:

  • Windows Vista, Service Pack 1, (English version)

  • Windows XP Professional, Service Pack 3, (English version)

  • Windows 7, (English version)

Hardware Requirements:

  • 2.0 GHz Minimum, 1 GB Memory

Additional Software Requirements:

  • Adobe Acrobat Reader 9.0.3

  • Microsoft Excel 2007 or 2010

  • Microsoft Internet Explorer 7.0, 8.0, or 9.0


1.3 Important Installation Information

Before installing Argus Insight, review the information in this section carefully. You may need to modify several settings or install required software before you install the Argus Insight application.

1.3.1 Installation Requirements for the Servers

For the Argus Insight Web Server, Cognos Server, or BusinessObjects Server:

  • Installation Language — You must install all software with the language setting configured to English. For example, if Oracle is installed in a language other than English, the registry entries are created with different names. Therefore, to avoid errors, install all software in English.

  • Oracle Client — You must install the Oracle client with the default ORACLE_HOME name, provided by the Oracle Universal Installer. Failure to do so will display an error message, stating that the Oracle OLE DB provider was not found during installation.

  • Time Zone — You must set all servers to the same time zone.

  • Default Language Setting — All the servers must have the default language setting enabled for US English.

    To enable US English as the default language setting:

    1. Open the Microsoft System Registry Editor.

      1. Click Start.

      2. Select Run.

      3. Type regedit and then click OK.

    2. Navigate to the following folder:

      HKEY_USERS\.DEFAULT\Control Panel\International

    3. Double-click the sCountry key in the right pane.

      1. In the Value data field, type United States.

      2. Click OK to save your changes and close the dialog box.

    4. Exit from the Registry Editor.

    5. Restart the server. Your changes will not take effect until you restart the server.

1.3.1.1 Additional Notes for the Argus Insight Web Server

  • Install the Oracle client after you install the Dotnet Framework.

  • Ensure that either you have disabled the firewall or you have added the Argus Insight port number in the Windows Firewall Exception list. The default port number for Argus Insight is 8084.

1.3.1.2 Additional Notes for the Cognos Server

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

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

1.3.1.3 Additional Notes for the BusinessObjects Server

  • Ensure that you have disabled the firewall. Alternatively, if the firewall is enabled, ensure that BusinessObjects is accessible from other machines on the network.

  • If you are not being authenticated in BusinessObjects through the Argus Insight application, run the following command on the BusinessObjects Server before you open a web intelligence document through Argus Insight:

    C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727>aspnet_regiis-ga "NT AUTHORITY\NETWORK SERVICE"

    Alternatively, you can assign the required rights to IIS users.

1.3.2 Installation Requirements for the Argus Insight Client

To be able to run the Argus Insight application, you must configure the following settings on the Argus Insight client machine:

  • The Argus Insight URL must be added to the trusted sites.

  • Cookies must be enabled to the lowest possible security level.

  • Javascript must be enabled.

  • The Allow script-initiated windows without size or position constraints setting in Internet Explorer must be enabled.

    To enable this setting:

    1. Start Internet Explorer.

    2. Open the Tools menu and select Internet Options.

    3. Select the Security tab.

    4. Click Custom level.

    5. Scroll to the Miscellaneous settings.

    6. Enable the Allow script-initiated windows without size or position constraints setting.

    7. Click OK to save your changes.

1.3.2.1 Troubleshooting Problems with the Cognos Report Writer

Note:

The information in this section applies only if the following two conditions are true:
  • You are using Cognos as your Business Intelligence tool.

  • You are using either Internet Explorer 8 or 9.

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

  1. Start Internet Explorer.

  2. Open the Tools menu and select Internet Options.

  3. Select the Security tab.

  4. Select Trusted Sites and then click Sites.

  5. Enter the URL for Argus Insight and then click Add.

  6. Click Close to return to the Security tab.

  7. Select Trusted Sites and then click Custom level.

  8. Scroll to the Scripting settings.

  9. Disable the Enable XSS Filter setting.

  10. Click OK to save your changes.

1.3.3 General Installation Notes and Information

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

  • All the information about LDAP, Single Sign-On Header, and SMTP configuration will be synchronized in real-time and also by ETL.

  • Ensure that you have configured the Argus Safety URL in the Argus Safety Load Balancer Server.

    To do so:

    1. Navigate to Argus Console, System Management (Common Profile Switches), and select Network Settings.

    2. Enter either the Argus Safety URL or the Argus Safety Load Balancer URL in the Argus Safety Load Balancer Server text box.