1 Introduction

Argus Insight is a highly optimized reporting module for querying, case series management and reporting that compliments Argus Safety.

The Argus Insight Extract Transform and Load (ETL) engine extracts data from the Argus Safety database and populates Argus Insight data mart in a format to enable efficient querying. The query, drill-down, and output features of Argus Insight let you analyze your safety data from a scientific angle and produce queries, case series and reports that provide medical and scientific understanding of your aggregated adverse event information.

Argus Insight also supports Argus Mart as an additional data source. If you are using Argus Mart as a data source in a multi-tenant environment, then you may create Argus Mart Advanced Condition that queries Argus Mart database.

Note:

Power Reports has been renamed Argus Insight.

1.1 Argus Insight Product Overview

In Argus Insight, you can generate a report through a query. The query retrieves a set of specific type of cases (Case Series) from the data mart (Insight Mart/Argus Mart) and then runs 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 reports using any of the supported reporting tools (BIP/BusinessObjects/Cognos) on these Case Series.

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

Surrounding text describes flowchart.jpg.

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 (Insight Mart/Argus Mart) and applying Boolean and Set operations on them. You may use Advanced Conditions to query data on Argus Mart.

Case Series

A list of cases that match the query criteria with revisions (applicable only for Argus Mart).

1.1.1 Argus Insight Architecture

Surrounding text describes arc3.jpg.

1.2 Software and Hardware Requirements

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

  • Argus Insight Web Server

  • Database Server

  • BusinessObjects Server, Cognos, or OBIEE/BI Publisher (depending on which Business Intelligence tool you are using with Argus Insight)

    Note:

    Argus Insight can be used together with a reporting tool, which can be BusinessObjects, Cognos, OBIEE/BI Publisher, or any combination of these.

  • Argus Insight Client

Table 1-2 Argus Insight Software and Hardware Requirements

Component Requirements

Argus Insight Web Server

Supported Operating Systems:

  • Windows Server 2012 Standard

  • Windows Server 2012 R2 Standard

Note: Make sure that you install the English versions of these operating systems.

Oracle Database Software:

  • Oracle Client 12c Release 1 (12.1.0.2)

    Note: Make sure, only one version of Oracle Client is installed on the server. Argus Insight Installer will not work in case there are multiple versions of Oracle Client are installed on the same machine.

  • Oracle Data Provider 12c Release 1 (12.1.0.2) for .Net

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 8 (Windows 2012)

  • IIS 8.5 (Windows 2012 R2)

  • Java Development Kit (JDK) version 1.8

  • Microsoft Visual C++ 2005 SP1 Redistributable Package MFC Security Update

  • Microsoft Visual C++ Redistributable for Visual Studio 2012 Update 4 (x86)

  • MSXML 6.0

  • WebGate 10.1.4.3 (optional)

  • WebCenter (deprecated)—While upgrading, in the Components List, if this option appears, then uncheck it.

Note: Argus Insight Supports SMTP and SMTPS with TLS 1.2 (Forced). SMTPS Supports both Implicit and Explicit Modes..

Database Server

Operating System as certified by the Oracle Database version.

Oracle Database Software:

  • Oracle Database Server (Enterprise Edition/Standard Edition 2 (SE2)) 12c Release 1 (12.1.0.2)

    (both CDB/PDB and Non-CDB formats)

    Oracle Advanced Security Transparent Data Encryption* (Optional)

    Oracle Advanced Security Network Encryption (Optional)

    *Note: Oracle Database TDE feature is part of the Oracle Advanced Security option available for Oracle Database Enterprise Edition 12c

    http://www.oracle.com/technetwork/database/options/advanced-security/index.html

    TDE provides the capability to encrypt sensitive data in the Oracle Database in a manner that is transparent to applications.

    Argus Insight product has been functionally certified with tablespace level encryption using the Oracle Database TDE feature.)

  • Oracle RAC 12c Release 1 (12.1.0.2)

  • Exadata 12c Release 1 (12.1.0.2)

Note: Oracle database Standard Edition 2 (SE2) is supported for single tenant deployment only.

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

Oracle Business Intelligence Enterprise Edition (OBIEE)

or

BI Publisher (BIP)

Operating System as certified by the OBIEE/BIP.

Oracle Database Software:

  • Same as Database Server.

Tool Version:

  • OBIEE or BIP 12c (12.2.1.0)

Note: You can either install OBIEE or the stand alone BI Publisher (Dashboards are not available with standalone BI Publisher).

Additional Software Requirements:

  • Java Development Kit (JDK) version 1.8

  • OBIEE Administrator Tool 12c (12.2.1.0) must be installed for configuring the repository file (RPD).

    Note that if you install OBIEE on a Linux machine, you need to install Oracle Business Intelligence Developer Client tools on a Windows machine. It will include the BI Administration tool.

    Refer to the Oracle OBIEE Installation Manual for further hardware and software requirements.

  • WebGate 11.1.2.2 (optional)

BusinessObjects Server

Operating System as certified by the BusinessObjects.

Oracle Database Software: Oracle Client 12 c Release 1 (12.1.0.2) (with SQL Plus, SQL Loader, Oracle and OLEDB Objects)

Hardware Requirements: Same as the Argus Insight Web Server

Reporting Tool:

  • BusinessObjects XI Release 4.0 Service Pack 6 (only for single tenant installations)

Cognos Server

Operating System as certified by Cognos.

Oracle Database Software: Oracle Client 12 c Release 1 (12.1.0.2) (with SQL Plus, SQL Loader, Oracle and OLEDB Objects)

Hardware Requirements: Same as the Argus Insight Web Server

Reporting Tool:

  • Cognos 10.2.x BI Server (default installation with all components except Cognos Content Database)

  • Cognos 10.2 BI Modeling (default installation with all components)

Additional Software Requirements:

  • WebGate 10.1.4.3 (32 bit) (optional)

Argus Insight Client

Supported Operating Systems:

  • Windows 10

  • Windows 8.1

  • Windows 7

(Supports both 32 and 64 bit)

Hardware Requirements:

  • 2.0 GHz Minimum, 1 GB Memory

Additional Software Requirements:

  • Adobe Acrobat Reader 11 or DC

  • Microsoft Excel: Any version of MS Office. Preferred versions: 2016, 2013 or 2010.

  • Microsoft Internet Explorer 11 (32 or 64 bit)

Note:

Argus Insight also supports:

  • Oracle Identity Manager 11.1.2.2

  • Oracle Virtual Machine Server 3.2.10 (64 bit)

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, BI Publisher, BusinessObjects Server, or Cognos 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. Enter 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, enter United States.

      2. Click OK to save changes.

    4. Exit from the Registry Editor.

    5. Restart the server to reflect the changes.

Additional Notes:

  • For 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.

  • For BI Publisher:

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

  • For 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.

  • For 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.

1.3.2 Installation Requirements for the Argus Insight Client

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

  • Add the Argus Insight URL to the trusted sites.

  • Enable Cookies to the lowest possible security level.

  • Enable Javascript.

  • Enable the Allow script-initiated windows without size or position constraints setting in Internet Explorer.

    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 changes.

1.3.3 General Installation Notes and Information

  • 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. In the Argus Safety Load Balancer Server text box, enter either the Argus Safety URL or the Argus Safety Load Balancer URL.