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);

Install Crystal Reports XI Developer

Open zip file “CrystalRptXI Install.zip”

1. Run setup.exe

1.1 Splash Screen-
Select 'English" and click "Install'

2.Welcome screen-
Click 'Next"

3. License Agreement Screen-

Check button "I Accept"
Click "Next"

4. User Information screen-Enter following at prompts.

Full Name: <Your Name>
Organization: <Your Company>
Product Key Code: < Get it from Business Objects Sales >

Click "Next"

5. Select Installation Type screen-

Check button "Typical"

Enter following at prompts.
Destination Folder: "e:\program files\business objects\"
Common Files Folder: "e:\program files\common files\business objects\3.0\"

Click "Next"

6. Start Installation screen.

Click "Next"

Note: Install check disk for space. If not enough disk space you will be prompted. Adjust space and proceed"

7. Crystal Reports Install in progress screen.

Wait until finished
If Prompted for Disk 2 - Click "OK"

8. Register Now screen-

Don't register!

Click "Register Later"

9. Crystal Reprots XI Installed screen -

UNCheck button "Check for Updates"
Click "Finish"

Main software Install is done.
OK - Now there are updates. Perform in this order.


Perform XI SP2 Install:

10. Run “crXIwin_sp2.exe” self extracting zip

11. Winzip Self-Extractor “This File will” screen -

Click “OK”

12. Winzip Self-Extractor - crXIwin_sp2.exe screen-

Enter following at prompts.
Unzip to folder: E:\Program Files\Business Objects\Crystal Reports 11\Patches\SP2

Keep Overwrite? And When done checked.

Click “Unzip”
Wait……


13. Winzip Extractor “17 files unzipped” screen -

Click “OK”

Install starts….
14. Choose Setup Screen -

Click “OK”

Run crXIwin_mhf.exe

Oracle Application Server 10g Corporate Portal

Overview
•Browser-based environment for building, deploying, and maintaining enterprise portals
•Secure and manageable framework
•Organized and personalized views
•Self-service Web publishing
•Manageable deployment architecture

Oracle Application Server Components
•Oracle Internet Directory (OID)
•OracleAS Portal (OC4J)
•OracleAS Wireless
•OracleAS Web Cache
•OracleAS Personalization
•OracleAS Integration

Grid Computing

Architecture that pools large numbers of servers and storage into a less expensive, flexible, on-demand computing resource for all enterprise needs

- Standardize low cost components

- Consolidate shared resources

- Automate management operations

OracleAS 10g portal Solution
•Content management (Classify content, Navigate and access content; Route content for review and approval)
•Content display (Create, organize, and manage pages; Build and customize dynamic portlets
•Content integration (integrate applications and disparate data by using built-in functionality, including Web Clipplig, OmmiPortlet, and Portlet Builder

Major User Roles in OracleAS Portal

- Page designers

- Content contributors and content managers
- Portlet developers

- Portal administrator

Portal Page Modes

•Page group – Root page; Subpages
•View mode; Graphical mode; Layout mode; List mode

Adding Content to Portal
Item
•An item is a basic unit of content on a portal page.
•Two kinds –
•Content item type
•Navigation item type

Content item types
•File and Simple File
•Simple Image
•Image and Simple Image Map
•PL/SQL and Simple PL/SQL
•Prge Link and Simple Page Link
•Text and Simple Text
•URL and Simple URL
•Zip File

Item-Related Features
•Versioning
•Item-level security
•Document control
•Publishing dates
•Expiry dates
•Approvals

Adding Items

Accessing the Document Library by Using a WebDAV Client

With a WebDAV client, you can:

- Move content, files, and folders between your desktop and the document library

- Open, edit, and save file type items "in place" by using desktop application

Content Metadata
•Data about the content in the document library
•Set explicitly or implicitly
•Made up of three main components (Attributes; Categories; Perspectives)

Classifying Content in OracleAS Portal
•Category – A predefined attribute that is used to group or classify pages, items, and portlets

Creating Category

•Perspective – A cross-category grouping of items and pages (attributes)

- Further classify content across categories

- Enable users to view related content classified in different categories

Creating Perspectives

Implementing Custom Types

Custom Types
•Custom types are unique types you create to extende the standard type definitions provided by OracleAS Protal.
•Custom attributes – User-defined attributes based on predefined data types created to store additional info about an item. (used in definition of custom item types and page types)
•Custom item types
•Custom page types
•[Item Type]n-n[Attribute]n-n[page type]

Creating Custom Item Types

Approval Process

A Series of one or more approval routing steps

- Each step must have one or more approvers

- Routing to approvers can be in serial or in parallel

Portal Page

•OracleAS Protal object that contains portlets and items.
•A portal page is the face of the portal – that which the user interacts with to access informatipn and applications. The layout of a portal page is defined through regions
•A portal page combines the features of a directory folder and a browser page.Like a folder, a page can exist within a hierarchy of pages and can contain content.

Page Group

•A page group is a hierarchical collection of pages for which common attributes and mechanisms can be established to govern the behavior of the pages it contains.
•Consider – (Administering page groups; Managing content metadata; managing content presentation; Copying and moving content)
•Region – rectanglar area on a page used to define the page layout (Types: Item; Portlet; Sub-Page Links; Undefined)

Shared Objects

•Layout and appearance (Styles; Templates; Navigation pages)
•Content attribution (Custom page types; Custom item types; Custom attributes; Perspectives; Categories

Style

•Set of values and parameters that controls the colors and fonts that are used by pages and regions within a page

Page template
•An object that enforces an standard layout and appearance for multiple pages

Navigation Items

•Portal Smart Link

•Login/Logout Link

•Basic Search Box

•List of Objects

•Portal Smart Text

•Object Map Link

•Page Path

•Page Function

Page parameters

•Synchronize portlets residing on a page

•Enable the reuse of portlets on multiple pages with no additional coding

•Provide users the means to customize pages based on their input values

Portlet parameters

•Enable the portlet developer to declare a public data input interface for the page designer to use

•Give the page designer control over the input data to the portlet

Integrating Page and Portlet Parameters

Controlling Access to Page Groups

Controlling Access to Pages

Item-Level Privileges

•Manage

•Edit

•View

Accessing Portal Objects by Using Direct Access URLs

Web Clippling

A piece of existing Web content that can be repurposed in other Web pages, particularly portals.

OmniPortlet

A feature of Oracle AS Portal that enables you to quickly and easily publish data from various data sources and render the result in a variety of formats.

Supported data sources

•Spreadsheet

•SQL

•XML

•Web Service

•Web Page

Supported Data formates

•Tabular

•Chart

•News layout

•Bulleted list

•Form

Data-Driven Portlets (DB, SQL etc)

OracleAS Portal Forms

•Forms based on tables and views

•Master-detail forms based on two tables or views

•Forms based on stored procedures

OracleAS Poprtal Reports

Publishing Business Intelligence on a Portal Page

OrcleAS Discoverer provides two types of portlets

•List of Database Workbooks portlet: Contains the names and links to Discoverer workbooks

•Worksheets portlet: Enables you to place actual worksheetcontent on the portal page

Privileges

- Global privileges

- Objectr-level Privileges

- The corresponding global privilege overrides an object-level privilege

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 XI R2 Install on Solaris 10 (WebLogic) Pre-Installation Considerations

BusinessObjects Enterprise requires a database server software and web application server software to be installed and configured.
Oracle 10g database and Weblogic application server are required to be installed before BusinessObjects Enterprise installation. The database (MySQL) and application server (TomCat) which come with the installation package should not be chosen during BusinessObjects Enterprise installation. After completed the installation, the Weblogic application server needs to be configured so it integrates with BusinessObjects Enterprise.
In addition, ensure that all BusinessObjects Enterprise machines can communicate properly with one another:
• Each BusinessObjects Enterprise machine must be able to communicate over TCP/IP with the machine that runs your Central Management Server(CMS). The CMS database must exist prior to BusinessObjects Enterprise installation. The CMS is responsible for maintaining a database of information about your BusinessObjects Enterprise system, which other components can access as required. The data stored by the CMS includes information about users and groups, security levels, BusinessObjects Enterprise content, and servers. For more information about the CMS, see BusinessObjects Enterprise Administrator’s Guide.
• UNIX servers that run BusinessObjects Enterprise must have a fixed host name. Root privileges are required to set or modify a fixed host name on the system.
• Installing BusinessObjects Enterprise should not use root privilege. Ask UNIX administrator to create a user account for BusinessObjects Enterprise and perform a user install of BusinessObjects Enterprise.
• Ensure that your database client and server are set up to use Unicode character encoding (such as UTF-8). Consult your database documentation to determine the settings required for a Unicode configuration.
• When installing Oracle database server, server needs to be configured to use Unicode encoding for the character data types.
• The BusinessObjects Enterprise will be connected to a Weblogic application server. The Weblogic application server must be able to communicate with all BusinessObjects Enterprise machines. This communication is enabled by the BusinessObjects Enterprise SDK, which must be installed and configured on the Weblogic application server. In this case, the BusinessObjects Enterprise Java SDK must be installed.
Note:
• Make sure that Weblogic application server has the JDK on it, you will need to install it before installing BusinessObjects Enterprise SDK.

Checking for required commands and utilities
In order for the install setup program to run correctly, the following commands and utilities must be installed on your Solaris 10 system:

/bin/sh
Pwd
read
touch
uname
expr
hostname
sed
Awk
chown
grep
tail
tar
Id
dirname
Gzip
sty
ulimit
which

These relatively standard commands and utilities should be available on most UNIX distributions. However, if for any reason one of them is not available on your system, download and install a version appropriate to your system.
Additionally, these commands and utilities must be accessible in the PATH environment variable of the user account that you use when installing BusinessObjects Enterprise.
Important
Proper verification of both install privileges as well as connect strings need to performed.For Oracle Connectivity make sure that SQL*PLUS can be used to connect to the database.

Components installation before BusinessObjects XI R2 Install
Several components need to be installed before BusinessObjects Enterprise system can be installed. Here is the list that needs to be followed:

1. Installing Oracle Net Client 9.2
Note: Oracle Net Client 9.2 works as tested. Even though the BO XI R2 supported platforms document lists Oracle Net Client 10.2 as supported, there are issues using 10.2 client (64bit). It is recommended to use Oracle Net Client 9.2 with /lib32 set within the .profile
Follow the instruction below to install oracle 9i (9.2.0.6) client on application server.

· Login to application server usplgmhsras001/usplgmhsras002 with “Vbobje” id
· cd /usr/local/oracle/product.
create this directory if not exist.

· untar "9.2.0.6_client.tar” file
cd /usr/local/oracle/product
tar –xvf 9.2.0.6_client.tar

Validation:
With the Vbobje id, run sqlplus, should see the output like below:

SQL*Plus: Release 9.2.0.6.0 - Production on Wed May 23 16:03:53 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Enter user-name:


Vbobje unix id profile update:

Update Vbobje .profile file with the following entries: (if it’s not updated earlier)

ORACLE_HOME=/usr/local/oracle/product/9.2.0
export ORACLE_HOME
TNS_ADMIN=/var/opt/oracle
export TNS_ADMIN
LD_LIBRARY_PATH=$ORACLE_HOME/lib32
export LD_LIBRARY_PATH
ORACLE_SID=ORCL
export ORACLE_SID
PATH=$ORACLE_HOME/bin:/usr/j2se/bin:$PATH
export PATH

LANG=en_US.UTF-8
LC_ALL=en_US.UTF-8
export LANG LC_ALL

export BOBJE_ENV_SOURCED=""
. $HOME/bobje/bobje/setup/env.sh

tnsnames.ora file update:

· cd /var/opt/oracle
create this directory if not exist.

· Copy the tnsnames.ora file from /usr/local/oracle/product/9.2.0/ to /var/opt/oracle/ and modify the entries mention below:

PreProd / Production:
Database sid name
Database SID VIP
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = tcp)
(HOST = ORCL)
(PORT = 1521)
)
)
(CONNECT_DATA =
(SID = ORCL)
)
)


Validation:
With the Vbobje id, run
· sqlplus bobje/bobje@ORCL

Should be able to SQL > prompt


· on sql prompt run the following select query

SQL> select name from v$database;

Output should look like this:

NAME
---------
ORCL

1. Setting up an empty database for CMS
2. Setting up an empty database for auditing
3. Creating an account, a home directory and a login environment for BOE installation
4. Providing and verifying connectivity to the CMS database
5. Installing the Java SDK
6. Accessing Weblogic Administration Console. It requires account and password


Setting up an empty database for CMS
BusinessObjects Enterprise requires a database (or Oracle schema) to store information about the system and its users. An existing Oracle 10g database will be used.
Database administrator must create a new database on database server before BusinessObjects Enterprise installation. The database used only for BusinessObjects Enterprise , and not contain other tables.Create a new database, create a new user account and password for the database that will be used by BusinessObjects Enterprise. Ensure that the new account has permission to create, modify, and delete tables and create procedures so that BusinessObjects Enterprise can modify the database as required. Write down name of the database, the user account, and the password. They will be used in BusinessObjects Enterprise installation script.
Name the new database (hisrepcmpldb.iweb.gm.com, instance: hisrepcm), and create a new user account (bobje), however, this naming convention is not required.
Ensure that the database server is set up to use Unicode character encoding (such as UTF-8). Consult your database documentation to determine the settings required for a Unicode configuration. For Oracle database servers, during installation you need to configure the server to use Unicode encoding for the character data types.

Setting up an empty database for auditing (if applies)
Create another database schema for auditing. It can share CMS instance. Name the auditing database (ex: bobjeaudit), and create a new user account (ex: bobjeaudit).

Creating an account, a home directory and a login environment
Create a specific user account and group under which the BusinessObjects Enterprise daemons can run. You will log on as this user in order to perform the remainder of the installation procedures. Although it requires root privileges to set up this account, the account itself does not require root privileges. Neither the installation scripts nor BusinessObjects Enterprise itself needs to run as root.Use usual administrative procedures to perform these recommended tasks.

Setting up UNIX system
Create a new group. Create a new user account, and set this user’s primary group to the new group. Assign a secure password to the new user account.
Create the directory where BusinessObjects Enterprise will be installed. By default, the installation will use current directory, that is, the directory you call the install program from, as its base directory for the install. You can override this default, with the directory of your choice at install time. You will see this directory referred to as INSTALLDIR throughout this document.
Set the new user’s HOME directory to the installation directory that you created. When you run the installation script, you choose a “user” installation type so that all of the installed files are confined to the directory that you specify here.
Ensure that the account you created has read, write, and execute permissions on the new HOME directory.
Assign the new user a default login shell, and create or modify the appropriate login script(s) for the user account. In particular, make sure that the login script(s) set up a default login environment that meets these requirements:
The user’s HOME directory must be included in the PATH environment variable.
All of the commands and utilities required by the install setup program must be accessible in the PATH environment variable. For details, see section 10.1.
The user’s login environment must set up the database environment such that the install setup program can access your database client software. Make sure the tnsnames.ora is set correctly. For details, see section 10.2.

Providing and verifying connectivity to the CMS database
To create tables and write data to the new CMS and auditing databases, the installation scripts need to establish a connection to the database server. That is, when you log on to UNIX with the user name from which you will perform the installation, the default shell environment must include the appropriate database environment variables and/or initialization files. Only then can the installation setup program access the CMS database using your database
client software.
The environment variables and/or files required by the installation scripts depend upon the type of database server you are running:
Oracle database is connected through a native connection, the installation searches the current shell for the ORACLE_HOME environment variable. This standard Oracle environment variable must be set in order for the install script to utilize the Oracle client software.

Additional database environment variables must be set in order for the installation script to use the database client software properly. Before running the installation script, test the shell environment of the account from which you will install BusinessObjects Enterprise to verify database connectivity and privileges. See the procedure that corresponds to the database.
The existing database needs to be sourced:
User can modify their own profile and add the command to source their database environment. This method must be done by the user which installs BusinessObjects Enterprise
Note: Consult database documentation and/or database administrator if the account shell environment from which you will install BusinessObjects Enterprise has not yet been set up for database client software, or if you are unable to connect successfully to the database.

Configuring the Java environment variable
After installing the Java SDK you must set the JAVA_HOME environment variable. If your Java web application server installs the Java SDK as part of its installation process, install the application server first, and then set the environment variable.
You need to know the directory path containing your Java SDK bin directory.

To set the JAVA_HOME environment variable on UNIX
1. Log on to the UNIX server with the user account and password which you will use to do your install.
2. Type JAVA_HOME= . is the directory containing your Java SDK bin directory.
3. To confirm that you’ve set the environment variable correctly, type echo $JAVA_HOME.
4. Using a text editor such as vi, add the command to set JAVA_HOME to the login environment for the account from which you will install BusinessObjects Enterprise. Add the command to your .profile file. This ensures that the value of JAVA_HOME is correctly set each time you log on to the account.

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

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