Bookshelf v7.8.2: Automatic Configuration of Advanced Reporting Edition

Siebel Analytics Platform Installation and Configuration Guide > Installing Siebel Analytics Ancillary Client Programs > Roadmaps for Installing and Configuring the Advanced Reporting Edition >

Automatic Configuration of Advanced Reporting Edition

This topic is part of the Configuration Steps for Advanced Reporting Edition. It describes the configuration steps performed by the Advanced Reporting Edition installer. The main process is similar for all supported platforms. In some cases, the specific file names or values vary according to the operating system. These variations are indicated in tables for each step.

In general, the installer performs the following steps:

Installs libraries and DLLs.
Registers the security extension library or DLL for use by iServer.
Backs up and modifies $ACTUATE_ISERVER_INSTALL_DIR/etc/acserverconfig.xml.
Copies the Analytics.rol file to allow eReports Designer to be used with this iServer.

These steps are described in more detail in the following topics:

Configuring Actuate iServer (All Platforms)

Operating Systems: All.

This topic is part of Automatic Configuration of Advanced Reporting Edition.

The Advanced Reporting Edition installer performs the following configuration steps under all operating system platforms.

Installs the following libraries or DLLs to $ACTUATE_ISERVER_INSTALL_DIR/bin:


Platform	DLL or Library
Windows	nqsawodbcrsse2r.dll
Solaris	libnqsawodbcrsse2r.so
	libsawstlport_sunpro_55.so.4.5
	libstlma.so
	libssatomic.so
AIX	libnqsawodbcrsse2r.so
	libsawstlport_xlC60.a
	libstlma.so
	libssatomic.so
HPUX	libnqsawodbcrsse2r.sl
	libsawstlport_aCC.sl
	libstlma.sl

Backs up the file $ACTUATE_ISERVER_INSTALL_DIR/etc/acserverconfig.xml.

On the machine where iServer is installed, adds the DLL or library shown in the following table to the file acserverconfig.xml.


Attribute	Platform	Security Extension Value
RSSELibrary	Windows	nqsawodbcrsse2r.dll
	Solaris	libnqsawodbcrsse2r.so
	AIX	libnqsawodbcrsse2r.so
	HPUX	libnqsawodbcrsse2r.sl
EnableOpenSecurity	All	"true"
RSSEMultiThreadSafeLibrary	All	"true"

NOTE: The user-specified volume name is case-sensitive. It must match exactly, or the volume name cannot be located and the attributes are not added.

Modifies the acserverconfig.xml file according to the specified volume name. This registers the security extension library or DLL for use by iServer.
The tag <Volume> in the following code example configures authentication between the iServer and the Siebel Analytics Server:

...
   <Volumes>
     <Volume>
       Name="[volume_name]"
       RSSELibrary="[library or DLL—see the Security Extension Value in the
                     preceding table]"
       EnableOpenSecurity="true"
       RSSEMultiThreadSafeLibrary="true"
     ...
     </Volume>
   ...
   </Volumes>

Configuring Actuate iServer (Windows Platforms)

Operating System: Windows only.

This topic is part of Automatic Configuration of Advanced Reporting Edition.

The Advanced Reporting Edition installer performs the following configuration steps under Windows platforms:

Copies the Analytics.rol file to the folder $ACTUATE_ISERVER_INSTALL_DIR/etc, to permit the Siebel Advanced Reporting Workbench to publish Siebel Analytics-compatible reports to this iServer.
NOTE: The Administrator should make sure that the Analytics.rol file is copied to every machine running Siebel Advanced Reporting Workbench in the directory $ACTUATE_INSTALL_DIR\eRDPro\lib.

Configuring Actuate iServer (UNIX Platforms)

Operating System: UNIX only.

This topic is part of Automatic Configuration of Advanced Reporting Edition.

The Advanced Reporting Edition installer performs the following configuration steps under UNIX platforms:

Sets the Siebel Analytics system settings and variables in the Actuate iServer.
Modifies $ACTUATE_ISERVER_INSTALL_DIR/bin/start_srvr.sh:

Following the line
#!/bin/sh

the installer inserts the line
. $ANALYTICS_INSTALL_DIR/setup/sa.sh

Sets Actuate iServer to use the Siebel Analytics ODBC drivers and data sources.

In $ACTUATE_ISERVER_INSTALL_DIR/bin/pmd8.sh, modifies the following variables:


Variable	Platform	Value
ODBC_MGR_PATH	All	$ANALYTICS_INSTALL_DIR/odbc/lib
ODBCINI		$ANALYTICS_INSTALL_DIR/setup/odbc.ini
ODBCINST		$ANALYTICS_INSTALL_DIR/setup/odbcinst.ini
ODBC_LIB_PATH		$ANALYTICS_INSTALL_DIR/odbc/lib
AC_ODBC_HOME		$ANALYTICS_INSTALL_DIR/odbc/lib
LIBPATH	AIX	Prepends $ANALYTICS_INSTALL_DIR/odbc/lib
SHLIB_PATH	HPUX	Prepends $ANALYTICS_INSTALL_DIR/odbc/lib

Creates a symbolic link for the ODBC library.
In $ANALYTICS_INSTALL_DIR/odbc/lib, creates a symbolic link:

Platform

Link Name

Link To

Solaris

ODBC32.so

libodbc.so

AIX

ODBC32.sl

odbc.so

HPUX

ODBC32.sl

libodbc.sl

If you are deploying under AIX or HPUX, the installer performs the following additional steps.

Additional iServer Configuration for AIX

Installs the Siebel Analytics ODBC wrapper library libnqsodbcwrapper.so to $ANALYTICS_INSTALL_DIR/Bin.
Modifies the AnalyticsWeb data source to use the Siebel Analytics ODBC wrapper library.
In $ANALYTICS_INSTALL_DIR/setup/odbc.ini, sets the following variable:

Driver=$ANALYTICS_INSTALL_DIR/Bin/libnqsodbcwrapper.so

Additional iServer Configuration for HPUX

Enables the Actuate iServer executables to use more memory with the command
chatr +q3p enable:


Directory	Executable Name
$ACTUATE_ISERVER_INSTALL_DIR /bin	acacfconvert
	acdbutil
	acexport
	acextern
	acintern
	acimport
	acimport5
	acmode
	actoc
	acupgrade
	acverify
	cachesrvr8
	cdocutils
	encycsrvr8
	fontutils
	intsrvr8
	pmd8
$ACTUATE_ISERVER_INSTALL_DIR /operation	fctcmd8
	fctsrvr8
	font_mapping
	prtcmd8
	viewsrv8
	xfont_mapping

Configuring Actuate Active Portal

Operating Systems: All.

This topic is part of Automatic Configuration of Advanced Reporting Edition.

The installer makes the following changes in order for the Active Portal user interface to match the look and feel of Siebel Analytics:

Backs up and copies the following files:
- $ACTUATE_ACTIVE_PORTAL_JSP_INSTALL_DIR/login.jsp
- $ACTUATE_ACTIVE_PORTAL_JSP_INSTALL_DIR/viewer/viewnavigation.jsp
- $ACTUATE_ACTIVE_PORTAL_JSP_INSTALL_DIR/private/common/errors/error.jsp
- $ACTUATE_ACTIVE_PORTAL_JSP_INSTALL_DIR/WEB-INF/skin-access.config
Copies the folder SiebelAnalytics to $ACTUATE_ACTIVE_PORTAL_JSP_INSTALL_DIR/private/skins.

Siebel Analytics Platform Installation and Configuration Guide