BPM Admin Guide

Other Setup

This section discusses other setup procedures for Maconomy.

This section includes these additional procedures:

  • Install the Oracle Instant Client Drivers (Windows)
  • Set Up an ODBC Connection for SQL Server
  • Enable Unicode
  • Increase the Number of WebI Connections
  • Configure Characterset Settings if Using Oracle
  • User Setup and Single Sign-On
  • Configure Logon Token on BusinessObjects
  • Localization
  • Handling BusinessObjects Services
  • Use a Non-Standard Web Server Port
  • Set Templates for Web Intelligence
  • Burst Publishing
  • Materialized Views on Oracle

Install the Oracle Instant Client Drivers (Windows)

If your Maconomy system uses Oracle DBMS, and the BPM server is different from the one that has the Maconomy database, you must install Oracle drivers to allow BusinessObjects access to the database and to prevent the following warning.

To install the Oracle Instant Client Drivers, follow these steps:

  1. Navigate to: http://www.oracle.com/technology/software/tech/oci/instantclient/index.html.
  2. Select your operating system.
  3. Review and accept the license agreement and click Next.
  4. Download either Instant Client Package-Basic or Instant Client Package-Basic Lite.
  5. Unpack the drivers to a folder (for example, C:\Program Files\Oracle).

  6. Add the path to the drivers to the PATH variable.

  7. Create the variable TNS_ADMIN with the path to the same folder.
  8. Create tnsnames.ora in the folder, for example:

    maconomy =
        (DESCRIPTION =
           (ADDRESS_LIST =
             (ADDRESS = (PROTOCOL = TCP)(HOST = MACONOMYSERVER)(PORT = 1521))
           )
           (CONNECT_DATA =
            (SERVICE_NAME = maconomy)
           )
       )

    In this example, MACONOMYSERVER is the server that hosts the Maconomy database, and maconomy is the SID of that database.

Set Up an ODBC Connection for SQL Server

To set up the ODBC connection, follow these steps:

  1. Run Data Sources (ODBC) using the appropriate path:
    • For 32-bit Windows - Click Control Panel » Administrative Tools » Data Sources (ODBC).
    • For 64-bit Windows - Click All Programs » BusinessObjects XI 3.1 » BusinessObjects Enterprise » 32-bit Data Source (ODBC).
  2. Click Add.

  3. Select SQL Server and click Finish.

    The Create a New Data Source to SQL Server wizard is displayed.

  4. Enter the Name, Description, and Server information, and click Next.

  5. Select the method to use for authentication and click Next.

  6. Enter the default database and ANSI information and click Next.

  7. Click Finish to complete the process.

    The following dialog box is displayed.

Enable Unicode

Beginning with version 16.0 (2.1), the Maconomy database and BPM must be Unicode-enabled. You do this as part of the installation or upgrade.

To set up BPM for supporting Unicode, follow these steps:

  1. After you enable the Maconomy database for Unicode, follow the same steps for enabling the BPM Datawarehouse database for Unicode. See the documentation for information about how to enable Unicode on the Maconomy database.
  2. If you are upgrading BPM Analysis, perform the upgrade steps as described in the Upgrade section.
  3. If this is a new installation, perform the installation steps that are described in the BPM Analysis Installation Guide. Note that the database for the data warehouse must be Unicode-enabled.
  4. If you have BusinessObjects installed on Windows, perform the following steps:
    1. In the Windows registry set the following key:

      HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1\NLS_LANG

      to

      AMERICAN_AMERICA.AL32UTF8

    2. Create a system variable NLS_LANG and assign it the value:

      AMERICAN_AMERICA.AL32UTF8

  5. If you have BusinessObjects installed on Linux or AIX, perform the following steps:
    1. Set up an environment variable NLS_LANG with the value AMERICAN_AMERICA.AL32UTF8.
    2. Restart the BusinessObjects services.

      Ensure that universes have the parameter UNICODE_STRINGS set to YES (this is the default value).

Increase the Number of WebI Connections

In the solutions, the Workspace Client embeds various BPM Reporting reports. To support this, you must increase the default number of parallel connections.

To increase the number of parallel connections, follow these steps:

  1. Log in to BusinessObjects Enterprise Central Management Console (CMC).
  2. Click Servers.
  3. Expand Server Categories and click Web Intelligence.
  4. Under Server name, double-click WebIntelligenceProcessingServer.

    The Properties window appears.

  5. In the Properties window, under Web Intelligence Processing Service, enter the appropriate number of parallel connections.

    The default value is 50. It is recommended that you increase the value to at least 100.

Alternatively, add more servers. Adding one more server with the default of 50 parallel connections yields the same number of connections (100) as the preceding steps.

On large production systems, it is recommended that you increase the number of servers and then lower the number of parallel connections on each of those servers. However, note that each user who runs the Workspace Client occupies a number of WebI connections.

Note: It is recommended that you not have more than one Web Intelligence Report server per available CPU core.

Configure Characterset Settings if Using Oracle

BusinessObjects needs to know the characterset of Oracle to correctly display characters. You should set the environment variable NLS_LANG on the BO server.

To configure characterset settings, follow these steps:

  1. Determine the NLS_LANGUAGE and NLS_CHARACTERSET using the following statement:
    SELECT * FROM NLS_DATABASE_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE','NLS_CHARACTERSET')
    Tip: For the default setup, the result is AMERICAN, WE8ISO8859P1.
  2. Set the environment variable NLS_LANG to the concatenation of these two strings separated by a dot, for example, AMERICAN.WE8ISO8859P1.