Configuring Analytics Link for EPM System Pre-11.1.2.0 Releases

In This Section:

About Apache Tomcat (Internal Web Server)

Starting Oracle Services and Processes

Components to Configure

Configure SSL

Configure Analytics Link Server

Configure Analytics Link Repository

Configure Foundation Services

Configure Data Synchronization Server

Configure Data Synchronization Server Administrator

Configure Analytics Link Services

Configure Financial Management Connector

Configure Financial Management Patch

Summary

End of Installation

About Apache Tomcat (Internal Web Server)

If you are using Analytics Link with pre-11.1.2.0 releases of EPM System, Apache Tomcat is the supported Web application server.

Starting Oracle Services and Processes

Before continuing with configuring Analytics Link Server for deployment to Apache Tomcat, start Shared Services.

Components to Configure

Oracle Universal Installer installs all Analytics Link components on a given computer; however, if you are installing Analytics Link on multiple computers, you can configure only those components that you want to run on any given computer.

  Select the Analytics Link components that you want to configure on this computer and the components that you want to enable with Secure Sockets Layer (SSL) protocol.

  1. Select the Analytics Link components that you want to configure:

  2. In the Enable SSL group, select the components for which you want to enable an SSL connection:

    • Analytics Link Server and Data Synchronization Server—Enables an SSL connection to all Analytics Link components.

    • RDBMS—Enables an SSL connection to the RDBMS repositories to which Analytics Link connects.

    • Shared Services—Enables an SSL connection to Shared Services.

    To configure and activate SSL, see Configure SSL.

Use the configuration worksheets throughout this chapter to plan your configuration and to document the configuration steps for your company if required for disaster recovery.

Note the following about component selection:

  • When running Analytics Link Configuration Tool for the first time on a computer, all Analytics Link components are selected by default. When running the configuration tool subsequent times on a computer, components that have been previously configured on the computer are selected.

  • You can clear components that you either do not want to configure on this computer or that you want to configure later.

  • You can rerun Analytics Link Configuration Tool to reconfigure previously configured components.

  • The order of the configuration screens depends on the components that you are configuring at one time.

Configure SSL

Before you configure SSL, see Secure Sockets Layer (SSL) for Analytics Link.

For a list of the SSL certificates that you must import, see Configuring SSL When Configuring Analytics Link Server and Configuring SSL When Configuring Data Synchronization Server.

  To load certificates into Java Keystore:

  1. Under Analytics Link Server, click Import Certificates.

  2. On the Import Certificates dialog box, navigate to the directory where the required certificate is located.

  3. Select a certificate file and then click Import Certificates.

  4. Click OK.

    The configuration tool imports the certificate into the correct certificate store.

  To load certificates into Oracle Wallet:

  1. Under Data Synchronization Server, click Import Certificates.

  2. On the Import Certificates dialog box, navigate to the directory where the required certificate is located.

  3. Select the certificate file and then click Import Certificates.

  4. Click OK.

    The configuration tool imports the certificate into the correct certificate store.

Configure Analytics Link Server

Before you configure Analytics Link Server, see Analytics Link Prerequisites.

Table 14 describes the options for Analytics Link Server configuration on Apache Tomcat.

Table 14. Configure Analytics Link Server Page

Field

Description

Your Information This image of a space is used for formatting purposes only.

Container

Select Internal Web Server.

Note:

You must select this option if you are using Analytics Link with pre-11.1.2.0 releases of EPM System.

 
Supported Essbase Version

Select 9.3.1 and 11.1.1.

 

Analytics Link Server Port

Specify the port number on which Analytics Link Server listens.

The default port is 5423.

 

Essbase Max Alias Tables

Specify the maximum number of alias tables for the Essbase database that Analytics Link creates.

Essbase releases 9.3.1.x and 11.1.1.3 support 8 alias tables.

 

Analytics Link Shutdown Port

Specify the shutdown port number for Analytics Link Server.

The default port is 5422.

 

Configure Analytics Link Repository

Before you configure the database for the Analytics Link repository, see Analytics Link Prerequisites.

  Specify the settings for the Analytics Link repository database.

Table 15 describes the options for Analytics Link repository configuration.

Table 15. Configure Analytics Link Repository Page

Field

Description

Your Information This image of a space is used for formatting purposes only.

RDBMS

Select a supported relational database type for the Analytics Link repository:

  • Oracle

    Note:

    If you select this option, you must provide information about how Oracle connects to the Analytics Link repository. See Connection Description in this table.

  • Microsoft SQL Server

 

Database Host

Note:

This option is displayed only if you selected Microsoft SQL Server as the Analytics Link repository in the RDBMS field. If you selected Oracle, see Connection Description in this table.

Specify the host name of the database server on which the relational database is located.

 

Database Port

Note:

This option is displayed only if you selected Microsoft SQL Server as the Analytics Link repository in the RDBMS field. If you selected Oracle, see Connection Description in this table.

Specify the port number on which the database server listens.

  • Oracle default port—1521

  • Microsoft SQL Server default port—1433

 

Database Name

Note:

This option is displayed only if you selected Microsoft SQL Server as the Analytics Link repository in the RDBMS field. If you selected Oracle, see Connection Description in this table.

  • Oracle—Specify the Oracle database SID.

  • Microsoft SQL Server—Specify the SQL Server database name.

 

Database User

Specify the name of the Analytics Link repository user.

 

Database Password

Specify the password of the Analytics Link repository user.

 

JDBC Path

Note:

This option is displayed only if you selected Microsoft SQL Server as the Analytics Link repository in the RDBMS field.

Click Browse or enter the full path to the Microsoft SQL Server JDBC 2.0 driver (Type 4) that is installed on the computer where the Data Synchronization Server is installed.

Note:

You must obtain the SQL Server JDBC driver from Microsoft.

 

Connection Description

Note:

This option is displayed only if you selected Oracle as the Analytics Link repository RDBMS. See RDBMS in this table.

When Oracle is selected as the Analytics Link repository RDBMS:

  • The following fields are disabled on screen:

    • Database Host

    • Database Port

    • Database Name

  • In this field, you must provide the following information about how Oracle RDBMS connects to the Analytics Link repository:

    (DESCRIPTION =
       (ADDRESS_LIST=
          (ADDRESS=(PROTOCOL=TCP)(HOST=oracleserver)(PORT=1521))
       )
       (CONNECT_DATA=
          (SERVICE_NAME=ORCL)
       )
    )
 

Clear DB

Click to clear data from an existing Analytics Link repository. When prompted, click Yes to start the process and then click OK when the process is completed.

Caution!

If you are upgrading Analytics Link from a previous release, you must select Clear DB to clear the Analytics Link repository that was created in the previous Analytics Link release before you can use the Analytics Link repository in the release that you are currently installing.

 

Configure Foundation Services

Before you configure Foundation Services, see Analytics Link Prerequisites.

  Specify the settings for Foundation Services.

Table 16 describes the options for Foundation Services configuration.

Table 16. Configure Foundation Services Page

Field

Description

Your Information This image of a space is used for formatting purposes only.

Shared Services Host

Specify the host name of the computer on which Shared Services Server is installed.

 

Shared Services Port

Specify the port number on which Shared Services Server listens.

The default port:

  • 11.1.1.3 and later—28080

  • 9.3.1—58080

 

Shared Services User

Specify the name of a Shared Services administrator.

 

Shared Services Password

Specify the password of the Shared Services administrator.

 

Unregister Product from Shared Services

Click if you want to unregister this instance of Analytics Link Server from Foundation Services (Shared Services).

Caution!

If you are upgrading Analytics Link from a previous release, you must select Unregister Product from Shared Services to unregister the Analytics Link Server project from the previous release of Analytics Link before you can use Analytics Link Server in the release that you are currently installing. In Oracle Hyperion Shared Services Console, the Analytics Link Server project is listed as LiveLink@server_name under Application Groups.

 

Configure Data Synchronization Server

Before you configure Data Synchronization Server, see Analytics Link Prerequisites.

  Specify the settings for Data Synchronization Server.

Table 17 describes the options for Data Synchronization Server configuration.

Table 17. Configure Data Synchronization Server Page

Field

Description

Your Information This image of a space is used for formatting purposes only.

Log File

Specify the full path where the Data Synchronization Server log file (dss.log) should be written.

 

Data Store Dir

Specify the path to the directory where Data Synchronization Server stores data related to the Data Synchronization Server database.

 

Data Store Size

Specify the maximum size (in MB) of disk space allocated to the Data Synchronization Server storage directory.

Note:

The store size must exceed the maximum memory size allocated to the Data Synchronization Server.

 

Job Units

Specify the number of threads that Data Synchronization Server can use to process data.

Note:

The number of threads cannot exceed the number of CPU cores.

 

Query Units

Specify the number of threads that Data Synchronization Server can use to process queries.

Note:

The number of threads cannot exceed double the number of CPU cores.

 

Max Memory Size

Specify the maximum amount of memory (in MB) allocated to Data Synchronization Server processes.

Note:

The maximum memory size must be less than the store size.

If the Data Synchronization Server is installed on a 32-bit Windows operating system, the maximum memory limit is 2600 MB. This is a limit of 32-bit Windows operating systems.

 

DSS Port

Specify the port number on which Data Synchronization Server listens.

The default port is 5024.

 

Essbase Port

Specify the port number for the Analytics Link port that simulates the Essbase Server port.

The default port is 5025.

 

Analytics Link Server Port

Specify the port number on which Analytics Link Server listens.

The default port is 5423.

 

Analytics Link Server Host

Specify the name of the server on which Analytics Link Server component is located.

 

Reset Data Synchronization Server

Click to clear data from Data Synchronization Server.

When prompted, click Yes to start the process and then click OK when the process is completed.

Caution!

If you are upgrading Analytics Link from a previous release, you must select Reset Data Synchronization Server to delete all Data Synchronization Server databases that were created in the previous release of Analytics Link before you can use Data Synchronization Server in the release that you are currently installing.

 

Configure Data Synchronization Server Administrator

  Specify the settings for the Data Synchronization Server Administrator.

Table 18 describes the options for the Data Synchronization Server Administrator configuration.

Table 18. Configure Data Synchronization Server Administrator Page

Field

Description

Your Information This image of a space is used for formatting purposes only.

UserSpecify the name of the Data Synchronization Server administrator. 
Password

Specify the password of the Data Synchronization Server administrator.

 

Configure Analytics Link Services

The components that are configured as Windows services depends on the components that you selected on the Components to Configure page:

  • If you selected Analytics Link Server but did not select Data Synchronization Server, only Analytics Link Server is configured as a Windows service.

  • If you selected Data Synchronization Server but did not select Analytics Link Server, only Data Synchronization Server is configured as a Windows service.

  • If you selected Analytics Link Server and Data Synchronization Server, both components are configured as Windows services.

Windows service names:

  • Oracle Essbase Analytics Link

  • Oracle Analytics Link Data Synchronization Server

  Specify the settings for configuring Windows services.

Table 19 describes the options for Windows services configuration.

Table 19. Configure Analytics Link Server and Data Synchronization Server Windows Services Page

Field

Description

Your Information This image of a space is used for formatting purposes only.

Run as Service

Select Run as Service to configure the Windows service.

 

Log on As:

If you are configuring Analytics Link Server only, or are configuring Analytics Link Server and Data Synchronization Server, select This Account.

  • Enter the name of the user who installed Analytics Link Server. Only this user has the proper permissions for all Analytics Link Server configuration files. This user must have permission to run Windows services.

    The user name must be formatted as:

    domain\user_name
  • Enter the user password.

If you are configuring Data Synchronization Server only, you can enter the name and password of any user who has permission to run Windows services. Or you can select Local System Account.

 

Configure Financial Management Connector

Before you configure Analytics Link Financial Management Connector, see Analytics Link Prerequisites.

Analytics Link creates Microsoft IIS (Internet Information Services) Web site to connect to Financial Management Server.

  Specify the settings for Analytics Link Financial Management Connector.

Table 20 describes the options for Analytics Link Financial Management Connector configuration.

Table 20. Configure Analytics Link Financial Management Connector Page

Field

Description

Your Information This image of a space is used for formatting purposes only.

Anonymous Access

Select Anonymous Access, if the user wants to use the anonymous access method for accessing the Microsoft IIS Web site that Analytics Link creates to connect to Financial Management Server.

Note:

If you select Anonymous Access and you want to use the predefined credentials, do not specify a user and password.

 

User

Define the operation system user that will be used for anonymous access. The user name must be formatted as:

domain\user_name

Note:

If you want to use the default IIS user, leave this field blank.

 

Password

Define the password of the operation system user that will be used for anonymous access.

Note:

If you want to use the default IIS user, leave this field blank.

 

Configure Financial Management Patch

Automatic conversion of Financial Management Dynamic Accounts into Essbase is supported for the following versions of Financial Management:

  • Financial Management 11.1.2.0 and later—Supported by default. No patch is required.

  • Financial Management 11.1.1.3—Requires that you install Financial Management Patch 9450270.

  Specify the setting for the Financial Management patch.

  • 11.1.1.3-32-bit—Select this option if you are using:

    • Financial Management 11.1.1.3 and you have installed Financial Management Patch 9450270

    • Financial Management 11.1.2.0 or later

  • None—Select this option if you are:

    • Using a Financial Management pre-11.1.1.3 release

    • Unsure whether a patch has been installed

Note:

Analytics Link Configuration Tool does not install Financial Management patches for you. You must install Financial Management patches yourself.

Summary

  To complete the configuration process:

  1. On the Summary page, review the information for the components that you configured in this session.

    User passwords are encrypted for security.

  2. Click Finish.

  3. Review the HFS_HOME\Work\config.log file for error or exception messages.

  4. On the next page, click OK.

End of Installation

To exit the installation program, click Exit, and then Yes.