Showing posts with label Business Intelligence. Show all posts
Showing posts with label Business Intelligence. Show all posts

Friday, May 1, 2009

Business Objects XI R2 SDK Functional Mapping

The BusinessObjects Enterprise SDK allows you to build web applications that interface directly with your BusinessObjects Enterprise system.

Start.jsp: page has login textbox
Logon.jsp: check the BO Enterprise to verify username and password.

ISessionMgr sm = CrystalEnterprise.getSessionMgr();

// Log on to BusinessObjects Enterprise
enterpriseSession = sm.logon(username, password, cms, auth);


Friday, March 27, 2009

Cognos 8 Architecture




















The architecture presented above reflects the Cognos 8 architecture.

Presentation Service
The presentation service handles requests for Cognos Connection, Query Studio, and Event Studio.

Report Service
The report service handles interactive requests to run reports and provides output for a user in Cognos Connection or a studio.

Report Data Service
The report data service handles requests to import Cognos report data to Microsoft Office workbooks and presentations through Cognos Office Connection.

Batch Report Service
The batch report service handles background requests to run reports and provides output on behalf of the monitoring service.

Job Service
The job service runs jobs by signaling the monitoring service to run job steps in the background. Steps include reports, other jobs, import, exports, and so on.

Monitoring Service
The monitoring service assigns a target service to handle a scheduled task. For example, the monitoring service may ask the batch report service to run a report, the job service to run a job, or the agent service to run an agent. The monitoring service will monitor the running of the task and collect and save history information for the task. The monitoring service can also take control of asynchronous service conversations on behalf of the client, such as if a user asks to run an interactive report in the background.

Log Service
The log service manages all logs generated by the dispatcher and other services. The log service can be configured to record log information in a file, a database, a remote log server, Windows Event Viewer, or a UNIX system log.

Content Manager Service
The Content Manager Service performs object manipulation functions in the content store, such as add, query, update, delete, move, and copy.

Metrics Manager Service
The Metrics Manager Service provides the Metric Studio user interface for monitoring and entering performance information.

Data Integration Service
The data integration service controls the loading of metrics data and the calculation of metrics status for scorecarding in Metric Studio.

Delivery Service
The delivery service sends emails on behalf of other services, such as the report service, job service, agent service, or data integration service.

Event Management Service
The event management service manages scheduled tasks. When a scheduled task begins to run, the event management service asks the monitoring service to begin running the task.

Agent Service
The agent service runs agents. If the conditions for an agent are met when the agent runs, the agent service asks the monitoring service to run the tasks.

System Service
The system service defines the Business Intelligence Bus API-compliant service used to obtain application-wide Cognos 8 configuration parameters. It also provides methods that normalize and validate locale strings and map locale strings to locales supported by the application.

LDAP Authentication Integration

















Reporting client connects to Reporting server directly. Reporting server does user authentication first (LDAP binding). After authentication is passed, Cognos Content Store authorization applies; Available reports are displayed as a list. Different user groups have different report group access. The diagram describes processes for all user groups.

Messaging and Dispatching in the Reporting Layer
In the reporting layer, messaging occurs between the gateway, the dispatcher, and the content manager. Requests can have different levels of affinity. Affinity refers to whether a request is assigned to a specific server or whether a load-balancing mechanism can assign it to another server. Affinity between request and server ensures that requests are routed to an appropriate computer for processing. There are three types of affinity: absolute, high, and low. The cancel operation is handled with a dedicated connection and does not have an affinity type. Details regarding affinity and load balancing can be found in the ‘Cognos 8 Business Intelligence Architecture and Planning Guide’. The following extract provides and overview as well as a sample explanation on processing a report execution request.

Absolute Affinity
Absolute (control) affinity requests are always routed back to the server that processed the original request. For example, when a user cancels a running report, absolute affinity routes the cancel request back to the executing process. Absolute affinity is used to create an association between the client and the executing server to ensure that long-running requests do not time out.
Cognos 8 routes absolute affinity requests to a specific server, regardless of the load balancing used. An absolute affinity request is used with the following operations: wait, getOutput, and release.

High Affinity
High affinity requests can be processed on any of a number of servers, but resource consumption is minimized if the request is routed back to the executing process.
For example, when a pageDown command is run while reading a report, the command can be run most efficiently by using the process that served up the page that is shown. If that process is not available because the administrator shut down the computer or there was a network failure, the request is routed to another available process. The next page can still be served up, although the process will be slower.
Cognos 8 routes high affinity requests to a specific server regardless of the load balancing used. A high affinity request is used with the following operations: back, email, firstPage, forward, lastPage, nextPage, previousPage, print, render, save, and saveAs.


Low Affinity
Low affinity requests will operate just as efficiently on any computer.




















When a user runs an HTML report or analysis through Cognos Connection, the following occurs:
1. The user clicks a report or analysis to run it, and the request goes through the gateway and the dispatcher to the presentation service.
2. The presentation service sends the request to the report service through the dispatcher.
3. The report service requests the report or analysis and metadata from Content Manager, through the dispatcher.
4. Content Manager sends the report or analysis XML specifications and metadata to the report service. Content Manager refetches metadata only when Cognos 8 is stopped and restarted or the model is updated and republished.
5. The report service returns one of these results to the presentation service:
- • an error page
- • a not ready page
- • a page of an HTML report or analysis
6. The presentation service sends one of these results through the dispatcher and gateway to the browser:
- • an error page
- • a wait or cancel page
- • a page of a completed HTML report or analysis in the Cognos Viewer interface
When the user presses page down or page bottom in the browser, the same path is followed again. The request has a high state of request affinity to ensure that it is routed to the same report service for additional rows of data

Load Balancing
The Cognos 8 architecture is tuned to minimize dispatch time. Cognos 8 uses network capabilities such as load-balancing routers to ensure that dispatchers and Web gateways are evenly utilized. Load balancing routers 'spray' requests across multiple Web or application servers. Although each Cognos 8 application servers has a Content Manager installed, only one is active and the other(s) are in a ‘standby’ status. Since application servers in ‘standby’ mode have more computer resource available to service report request, load balancing settings will be adjusted to direct more request to ‘standby’ servers in an effort to maintain an overall balance of resource utilization across the servers.

Gateways may be configured to recognize multiple dispatchers, however the first dispatcher listed is the primary and will be sent all request unless there is a failure. Consequently, this feature supports failover functionality but not actual load balancing.

The dispatchers are also able to balance service requests across dispatchers sharing the same content store. The dispatcher load balancing scheme is a static algorithm. A weight for each machine can be specified; a dispatcher with a weight of 2 can do twice as much work as a dispatcher with a weight of 1, and so on. Each dispatcher then simply spreads work among all the dispatchers using a weighted round-robin algorithm. Each dispatcher will accept all requests passed its way. Requests are queued by the dispatcher until executed

Load balancing is automatic in a distributed install. If there is more than one instance of a report service, dispatcher will distribute requests to all enabled instances of the service that are registered in Content Manager. The configured server Capacity determines the relative weights of the servers. Over time, a dispatcher with a capacity of 2.0 will receive twice as many requests as a dispatcher with a capacity of 1.0. In addition, Cognos 8 supports load-balancing routers.

If load-balancing routers or equivalent network technology is not used, browser requests are directed to a single Web server, as indicated in the URL. Similarly, Cognos 8 Web gateway requests are directed to a single Cognos Cognos 8 server.

Load-balancing routers and other network technologies are used to distribute network requests across several computers to ensure an even allocation of work. Load-balancing routers can be used with Cognos 8 in front of the web servers and the applications servers. The recommendation is to use them before the web servers and use the load balancing features of the dispatchers to balance the load across the dispatchers.
- Between the Client Tier: web browser or Framework Manager and Web Tier : Web Server Gateway
- Between Web Tier: Web Server Gateway and Application Tier: Report Server














Note: To ensure that requests are managed efficiently, some requests are routed back to the same report server. Cognos 8 does this automatically. The use of one or more load-balancing routers will not disrupt this process.

Cognos 8 Java Servlets and Services
Cognos 8 operates as two Java servlets running in a J2EE-compliant servlet container. The first servlet is the dispatcher. The presentation service, and the job and schedule monitoring service, are Java based and run within the dispatcher. The report service is a non-Java based application running as a child process of the dispatcher.

The second Java servlet is Content Manager, which runs in the same Java process as the dispatcher.

The main incoming port (by default 9300) is owned and managed by the servlet container or application server that routes messages to the appropriate servlet based on the URL.

Multi-Thread Management
The J2EE servlet container manages the threads (computing instructions) for each user request. This varies from a traditional C++ based application, where threads are managed by the service itself.

The Java servlet architecture provides a key advantage. If a failure occurs, only the thread associated with the request is affected. The failure does not impact the service as a whole. In other words, the affected thread will be lost, but other requests will be unaffected, and the system will continue to operate.

In addition, each report server creates and manages own threads. The report server is started and monitored by the dispatcher. If the report server fails, the dispatcher will start a new report server. The affected threads will be lost, but the system will continue to process new requests

Database Connection Management

Content Store Database
The Content Manager Service accesses the content store. Content Manager uses one database connection per request. Content Manager creates new database connections as required, pools connections, and re-uses existing connections when possible. Content Manager maintains all database connections for the duration of the Content Manager operation. The theoretical maximum number of concurrent Content Manager Requests is equal to the number of requests accepted by the Java application server.

When other Cognos 8 services are on the same computer as Content Manager, requests may be divided between Content Manager and the other services. In this case, the number of connections available to Content Manager may be less than the maximum possible connections.

The diagram below shows the use of JDBC for internal managed Cognos databases and the use of native API for reporting data sources.














The report server computer accesses the query databases. The maximum number of query database connections available can be configured to the report server computer, and the amount of time connections are retained. A cleanup thread examines the connections once per minute and any connection that has been inactive longer than the timeout value is removed.

Inactive query database connections can be claimed by a new request. This occurs when the maximum number of connections has been reached and none of the inactive connections can be used by the new request. In this case the oldest inactive connection is terminated and a new connection is created. A query database connection is only reused when the database credentials of the connection match those of the new request. When the maximum number of connections is reached, and all are active, then additional requests fail.

Tuesday, March 24, 2009

Integrate Single-Sign-On Web Service with Business Objects InfoView (JAVA)

Step 1: Query SSO Web Service
queryWebService
public boolean queryWebService(java.lang.String sUserID,
java.lang.String sPassword,
java.lang.String sPortalPassword)Use application request info and user credential to authenticate the user
With Webservice is already initialized, query the webservice, using application request info and user credential to get user response object back. Return true if succeeded.


Returns:
boolean Status of user authentication.


Step 2 Get SSO Session ID
getAWSSessionID
public static java.lang.String getAWSSessionID(HttpServletRequest oRequest)Get AWS session ID. The AWS session ID is stored by SSO login page.
This method retrieves AWS session ID cookie by using specific cookie name. It also uses UTF-8 to decode the session id.


Returns:
String UTF-8 decoded session id
Since:
0.1

Step 3 Get User ID by session
getUserIDBySession
public java.lang.String getUserIDBySession(java.lang.String sAWSSessionID)
throws java.io.IOExceptionReturn user id if existing AWS session of application request info is authenticated.
If AWS session is found, the session id will be used to check against application request info. If the session is still alive on AWS server the user id will be returned for further application authentication.


Returns:
String User id in the session with application request info.


Step 4 Forward to Internal BusinessObjects Logon Page
request.getRequestDispatcher("/" + oPropertyLoader.getPropertyValue("BOLogonPage").trim()).forward(request, response);

Step 5 Initialize Business Object Session Manager
init
public boolean init()Initialize BOUserInfo. Not related to specific user.
This method initializes Property Loader and gets session manager


Returns:
boolean Indicates the status of initialization
Since:
0.1


Step 6 Get Business Object Server Logon Token
getLogonToken
public java.lang.String getLogonToken()Get user logon taken.
This method uses userid, password, cms and authenticatio type to get logon token. If the userid and password is in specified cms database, it returns the token, otherwise it returns blank string. It also save the infoStore object for future usage.


Returns:
String Logon Taken
Since:
0.1

Step 7 Logon to Business Object InfoView
sHomeURL = oPropertyLoader.getPropertyValue("ServerURL") + oPropertyLoader.getPropertyValue("BoInfoviewString") + logonToken;
/*
* It is useful to store some frequently used objects in the session for
* easy access later on.
*/
// Store the IEnterpriseSession object in the session.
session.setAttribute("EnterpriseSession", oBOUserInfo.getEnterpriseSession());

// Create an IInfoStore object and store it in the session.
IInfoStore iStore = (IInfoStore)oBOUserInfo.getEnterpriseSession().getService("InfoStore");
session.setAttribute("InfoStore", iStore);
response.sendRedirect(sHomeURL

Business Objects Enterprise XI Sizing

Step 1 - Load
Potential Users (e.g. Named Users) - Heavy, Active, Moderate, Light
Concurrent Active Users
Concurrent Viewing Jobs
Simultaneous Requests

Example:
(1)) + (((Concurrent active users X % of Active Users) / 100) * (0.25)) + (((Concurrent active users X % of Moderate Users)/ 100) * (0.12)) + (((Concurrent active users X % of Light Users) / 100) * (0.06)) = Calculated Simultaneous Users (rounded up) - or – (((100 X 15) / 100) * (1))) + (((100 X 45) / 100) * (0.25)) + (((100 X 25) / 100) * (0.12)) + (((100 X 15) / 100) * (0.06)) = 31

Step 2 - Services















Intelligence Tier
• Central Management Server (CMS)
• Crystal Reports Cache Server
• Input/Output File Repository
• Event Server

Processing Tier
• Web Intelligence Report Server
• Web Intelligence Job Server
• Crystal Reports Page Server
• Crystal Reports Job Server
• Report Application Server
• List of Values Job Server

Step 3 - Configuration
Basic One Machine Configuration (Vertical Scaling)
Multiple Machine Configurations Types (Horizontal Scaling)

Step 4 - System Database Tuning
- System Database Backend Performance
- Connection between Enterprise XI and the database system
- Performance Criteria
Meeting the following 5 criteria helps to avoid the most common performance bottlenecks.
• The database system’s cache hit rates are over 90%.
• The optimizer statistics are not older than 24 hours.
• Lock granularity is row locking.

Business Objects XI R2 support on Solarias SP2

BusinessObjects Enterprise XI is a reliable and proven BI platform that allows you to deliver extreme insight throughout your organization.














Server Products
• Products BusinessObjects Enterprise XI R2
• BusinessObjects Web Intelligence XI R2
• Crystal Reports XI R2
• BusinessObjects Dashboard Manager XI R2
• BusinessObjects OLAP Intelligence (Server Components) XI R2
• BusinessObjects Performance Manager XI R2
• BusinessObjects Predictive Analysis XI R2
• BusinessObjects Process Analysis XI R2
• BusinessObjects Set Analysis XI (Server Components) R2
• BusinessObjects Encyclopedia XI R2
• BusinessObjects Process Tracker XI R2 (1)
• BusinessObjects Voyager
(1) Process Tracker product is installed separately. Note that BusinessObjects Enterprise Premium XI Release 2 includes Process Tracker.

Desktop Products
Desktop products are only available on Windows. Please go to our supported platforms web site and refer to the platforms document corresponding to this operating system for a detailed list of the supported languages and platforms.

Operating Systems
• Solaris 8 for SPARC
• Solaris 9 for SPARC
• Solaris 10 for SPARC (1)
(1) Support for Solaris 10 requires a new CD or a new download of BusinessObjects Enterprise Release 2 for Solaris from our ESD site at the following link:
https://businessobjects.subscribenet.com/control/bobj/login
If you do not have an account, email the address below:
licensing@businessobjects.com
Language Support Restriction on Solaris 8
Note that Chinese Simplified, Chinese Traditional, Korean and Dutch are not supported on Solaris 8.
Language Support Restriction on Solaris 10
Note that Dutch is NOT supported on Solaris 10.

Minimum Hardware Requirements on Solaris
• SPARC v8plus
• 512 Meg RAM
• 3.75 GB hard drive for BusinessObjects Enterprise without Performance management
• 4.75 GB hard drive for complete install (BusinessObjects Enterprise and Performance management)
• 500MB BusinessObjects Productivity Pack

Patch Level for Solaris 10
Solaris 10 minimum install plus the following packages:
• SUNWgzip
• SUNWzlib
• SUNWscpu
• SUNWbash
• SUNWbcp
• SUNWxcu4 XCU4 Utilities
• SUNWxwfnt
• SUNWxwplt
• SUNWlibC
• SUNWeu8os American English/UTF-8 L10N For OS Environment User Files
• SUNWeuluf UTF-8 L10N For Language Environment User Files
• SUNWuiu8 Iconv modules for UTF-8 Locale
• SUNWulcf UTF-8 Locale Environment Common Files
• SUNWmfrun
• SUNWxwice
Solaris 10 Recommended Patch Cluster including:
Higher patches are supported by Business Objects.

Supported Locales
English en_US.UTF-8
...

Application Servers (JDK)
OAS 10G Rel.2 (10.1.2)
1.4.2_x (1) (4)

Sun Java System Application Server 8.1 Update 2 (05Q1)
1.4.2_06+ (2) (4)

Tomcat 5.0.27
JDK 1.4.2_13+(4)
JDK 1.5.0_xx

WebLogic 8.1 SP4
1.4.2_x(4)

WebLogic 9.2
JRockit 1.5.0_04+

WebSphere 5.1.0.4
1.4.1_x(4)

WebSphere 5.1.1.x (excluding 5.1.1.4)
1.4.2_x (3) (4)

WebSphere 6.0.0.2
1.4.2_x(4)

Portal Servers
• Oracle Portal Server 10g R2 (10.1.2) (JSR 168)
• WebLogic Portal 8.1 SP4 (JSR 168)
• WebLogic Portal 9.2 (JSR168)
• WebSphere Portal 5.1.0.1 (JSR 168)

CMS Database (Repository) & Audit Databases
IBM DB2/UDB for NT/Unix 8.1
DB2 Client 8.1

IBM DB2/UDB for NT/Unix 8.2
DB2 Client 8.2

IBM DB2/UDB for NT/Unix 9.1
DB2 Client 9.1

Oracle 10g R1 (10.1)
Oracle Net Client 10.1

Oracle 10g R2 (10.2)
Oracle Net Client 10.2

Oracle 9.2
Oracle Net Client 9.2

Sybase Adaptive Server Enterprise 12.5.2
Sybase Open Client 12.5.2

OLAP Connectivity for OLAP Clients
Hyperion Essbase Server 6.5.4
Hyperion Essbase API 6.5 Patch 4 (1)(2)

Hyperion Essbase Server 7.0
Hyperion Essbase API 7.0

Hyperion Essbase Server 7.1.x
Hyperion Essbase API 7.1.x

IBM DB2 OLAP Server 8.1 Fix Pack 3
IBM DB2 OLAP API 8.1 (1)

IBM DB2 OLAP Server 8.2
IBM DB2 OLAP API 8.2

SAP BI 7 SP10
SAP GUI 640 (3)

SAP BW Server 3.0b SP33
SAP GUI 620 or 640

SAP BW Server 3.1c SP37
SAP GUI 620 or 640

SAP BW Server 3.5 SP19
SAP GUI 640

LDAP Directory
• IBM Tivoli Directory Server 5.1
• IBM Tivoli Directory Server 5.2
• Lotus Domino Directory 6.0.2
• Lotus Domino Directory 6.5.3
• Novell eDirectory 8.7.3
• Oracle Internet Directory 10gR2 (10.1.2)
• Sun Java System Directory Server 5.1
• Sun Java System Directory Server 5.2

Business Objects Crystal Enterprise 10 Business Views

Business Views Overview
Business Views is a multi-tier system that enables companies to build comprehensive and specific Business Views objects that help report designers and end users access the information they require.

Using Business Views, you can integrate data from disparate sources. You can bring together data from multiple data collection platforms across application boundaries so that the differences in data resolution, coverage, and structure between collection methods are eliminated.

Business Views objects consist of the following:
• Data Connections
• Dynamic Data Connections
• Data Foundations
• Business Elements


Architecture



















Business Views is comprised of three tiers:
the client tier, the business tier, and the data tier.
• Client tier
The client tier consists of any Crystal client application that accesses the Business Views that are stored and organized in the business tier.

• Business tier
Business Views objects—a collection that includes Data Connections, Dynamic Data Connections, Data Foundations, Business Elements, and Business Views—are a part of this tier. Using the Business View Manager, you specify the settings and conditions for the various objects so that the client tier has access only to specific information from the data tier.

Business View Manager
The Business View Manager enables you to create and modify Business Views and the various objects that make up these Business Views. The administrator uses this designer to specify different Data Connections, to set security, and to control access to the data found within the different data sources in the data tier. This thick-client designer is the only part of Business Views that administrators interact with directly. End users access the data specified within the Business View Manager through their Crystal client application, such as Crystal Reports (via the Crystal Repository) or through the Report Application Server.

Business Views objects
Business Views objects include the following: Data Connections, Dynamic Data Connections, Data Foundations, Business Elements, and Business Views.

Data Connection
Data Connections specify and define the data sources for a Business View; they define how these data sources are made available to users. Thus, a Data Connection is a connection object, and an administrator can apply security to this object. Each Data Connection contains information that describes the physical data source, such as the server and data being accessed, the logon credentials, and the type of server being accessed.

Dynamic Data Connection
A Dynamic Data Connection is a collection of pointers to various Data Connections. An administrator or user is able to select which Data Connection to use through a parameter.
A typical scenario involves the migration of data from a development system to a test system, and finally, to a production system. In this scenario, a report is run against a development system, and then, when the data is migrated to a test system, the same report is run against the test system’s data. The only change required is that the Dynamic Data Connection’s settings must be updated so that it points to the test system’s Data Connection. Finally, when the test system’s data is migrated to the production system, the same report can again be run against the production system.
Note: When users refresh reports that are based on a Dynamic Data Connection, they are prompted to specify which of the available Data Connections to use.

Data Foundation
A Data Foundation consists of collections of tables and fields. Default table joins are defined at this level. Administrators can secure Data Foundations using the standard Crystal Enterprise security model, which includes View and Edit rights. The primary use of Data Foundations is for data abstraction: administrators control which tables and fields users can or cannot access when these users are designing or viewing a report.

Business Element
A Business Element is roughly equivalent to an OLAP dimension or logical view; that is, this object is a logically related collection of data fields that are based on a Data Foundation. These fields can be organized into a hierarchical structure within the Business Element. The most common example is a hierarchical structure that contains the following fields: Country, State or Province, and City. Business Fields in Business Elements can be aliased to support data abstraction and to facilitate report design. Administrators can secure Business Elements through the standard View and Edit rights.


Business View
A Business View is a logical collection of Business Elements. A Business View provides the highest level of data abstraction for end users. Users see Business Views as abstract database connections, and the contained Business Elements as virtual tables that, in turn, contain Business Fields. Administrators can secure Business Views through the standard View and Edit rights.
A Business View consists of the following objects:
• One or more Data Connections
• One optional Dynamic Data Connection
• One Data Foundation
• One or more Business Elements
Note:
• End users can access Business Views through applications such as Crystal Reports and the Report Application Server.


• Data tier
The data tier consists of data sources, such as multiple databases on different machines that provide the data for the business tier.
Usage Scenario


















Architectural workflow

Saturday, March 21, 2009

Business Object XI R2 Recommended Settings for WebLogic

The recommendations in this guide are based on a multi-tier architecture.














Windows XP Professional
Environment
Windows XP Professional Edition Service Pack 2
MDAC 2.8 is required.
Acrobat Reader 7.0

Hardware component
Number of CPUs - 1
Type of CPU - Pentium III 733MHz minimum
Memory - 256 MB recommended minimum
Disk (Size) - 3 GB of free space minimum, 30 GB for IDE
Network Desktop to RDBMS - 100Mbps
Network Card Type - Ethernet
Network Card Number - 1
File System Type - FAT32 or NTFS
Swap Space - Default

Internet Explorer
Environment
Internet Explorer 6.0

SP1
SUN Java Runtime
Environment 1.4.2.05
No Microsoft JVM supported.
Internet Explorer 6.0

SP2
SUN Java Runtime
Environment 1.4.2.05
No Microsoft JVM supported.

Parameters
Security Settings

To access the Security Settings in Internet Explorer:
1. Select Tools > Internet Options > Security.
2. Click Custom Level.
3. In the Security Settings box, set the following parameters:
Advanced Settings
To access the Advanced Settings in Internet Explorer:
1. Select Tools > Internet Options > Advanced.
2. Select the following options:
• Under Printing, select Print background colors and images.
• Under Browsing, select Always send URLs as UTF-8 (requires
restart).

Server Tier Architecture
WebLogic application server


Environment details
WebLogic 8.1 Service Pack 4 with JDK 1.4.2_06
If installed on HP-UX, the following patches must be
installed:
• PHNE_30367 Cumulative STREAMS patch
• PHNE_31247 Cumulative ARPA Transport patch

Parameter Recommended setting/ value
Thread Count 45
Socket Readers 50
Stuck Thread Max Time Set this value to the Maximum active time
specified for the Web Intelligence cluster.
Stuck Thread Timer Interval 60
Threads Increase

BusinessObjects Enterprise Server operating
system

Solaris
Solaris 10 minimum installation with the following patchs:
• SUNWgzip (The GNU Zip (gzip) compression utility)
• SUNWzlib (The Zip compression library)
• SUNWscpu (Source compatibility)
• SUNWbash (GNU Bourne-Again shell (bash))
• SUNWbcp (SunOS 4.x Binary Compatibility)
• SUNWxcu4 XCU4 utilities
• SUNWxwfnt (W Window System required fonts)
• SUNWxwplt (X Window System platform software)
• SUNWlibC (Sun Workshop Compilers Bundled libC)
• SUNWuiu8 Iconv modules for UTF-8 Locale
• SUNWulcf UTF-8 Locale Environment Common Files
• SUNWmfrun (Motif RunTime Kit)
• SUNWxwice (ICE package)
Use J2SE SDK 1.4.2 (1.4.2.02 or later is recommended).
bash installed
To check the OS version, use the following command:
uname -a
To check the patch level, use the following command:
showrev -p egrep "108528108827108434109147"

Parameter Value
Shell /bin/sh or /bin/ksh or bash
User account Recommended use of a non-root, dedicated user
account for Administration tasks.
user setting (limit,
ulimit)
• data segment unlimited
• file size unlimited
• open file = 1024
• stack size = 8192
• virtual memory unlimited
• cpu time unlimited
LD_LIBRARY_PATH LD_LIBRARY_PATH should be empty to avoid
conflicts with Business Objects server settings
(defined in the MyWebiEnv.sh file).
PATH PATH should be restricted to /usr/bin to avoid
conflicts with Business Objects server settings
(defined in the MyWebiEnv.sh file).

Database Tier Architecture
Oracle
OracleServer 9.2.06 Enterprise Edition
OracleServer 10.1.0.3 Enterprise Edition

Hardware component Value
Number of CPU’s 4
Type of CPU 750 MHz minimum
System bus: 150Mhz min
Memory 4 GB
Disk (Size) 18 GB x 8
Disk (Type)
Note: This specific
configuration of disk
controllers is not
required. It is an
example of how to
configure your disks.
SCSI controller #1: Operating system, database
server software, paging file
SCSI controller #2: Database server journal files
SCSI controller #3: Dedicated to CMS tables
SCSI controller #4: Dedicated to CMS tables
SCSI controller #5: Dedicated to Data source
SCSI controller #6: Dedicated to Data source
SCSI controller #7: Dedicated to Database server
dictionary, undo information and sort space
SCSI controller #8: Dedicated to Database server
dictionary, undo information and sort space
Network (middle-tier to
database)
100 Mbps
File System Type RAW
Swap Space 4GB
Network Card Type Ethernet
Network Card Number 1

Parameter Definition "Oracle 9" "Oracle 10"
db_block_size These parameters set
the RDBMS cache size
8192
db_block_buffers 183500 n/a
db_file_multiblo
ck_read_count
Facilitates the “full
table scan”
64 n/a
shared_pool_size Storage area for
parsed SQL
67108864 n/a
log_checkpoint_
interval
Accelerates log 10000 n/a
Processes Maximum number of
clients
512
log_buffer Accelerates log 163840 n/a
sort_area_size 3 MB n/a
TCP/IP Port 1521 n/a
sga_target n/a 384 MB
pga_aggregate_
target
n/a 128 MB
undo_management n/a Undo
undo_tablespace n/a Undo