Switch to standard view 
  Sybase logo
 
 
 



Contents


Overview

This section describes each of the products tested and how they were used during testing. This report documents only the platforms and products tested for certification. Other possible combinations of these products and platforms are not certified by Sybase. For more information about Sybase Adaptive Server Enterprise, including known issues not encountered during this certification or those occurring on other platforms, see the Release Bulletin for the specific platform and version. For more information about any of the products, please refer to the product literature or manufacturer website.

For more detailed information about the machines used in this environment, see the section Test Environment later in this report.

The following diagram illustrates the test environment. The BOE Server was installed on a Microsoft Windows 2008 server.

Back to Contents


Tests Performed

This section contains a detailed explanation of the tests performed.

Installation Tests

Report Creation Tests

Back to Contents


Setup and Configuration

The following information relates to the installation, setup and configuration of the test environment.

The setup and configuration tasks are described in the following sections:

Note: Sybase ASE served as the host for the BOE repository, the ASE data sources and BI Java Launcher application used in the testing environment. It was installed on a Windows 64-bit Server 2008 system. Detailed instructions about installing and configuring the BOE and ASE Server environments are provided in the Sybase Certification Report: SAP BusinessObjects XI 4.0 with Sybase ASE 15.0.5 and IQ 12.7 (http://www.sybase.com/detail?id=1094236&id=1094236).

Install and configure the BOE Client environment

This section describes how to install and configure the BOE Client environment.

It includes the following sections:

Installing the BOE Client

  1. Read the BusinessObjects product installation documentation for system requirements. Note that the BusinessObjects Client applications are available as 32-bit Microsoft Windows applications only.
    1. Ensure the two pre-requisites are satisfied:
      • Install the Microsoft .NET Framework version 3.5 or higher
      • Use a user with Administrative privileges to run the BOE Client installation program.
    2. Run the installation program. It starts by running a pre-requisite check. Following are the installation options selected in the test environment:
    3. Default English language
    4. All Selected Feature defaults for Client Components and Developer
    5. All selected defaults for Data Access and Security Components, except the following options which were de-selected: Netezza, Ingres, Greenplum, IBM Db2, Informix, Progress Open Edge, Oracle and Teradata.
  2. Proceed to install the selected products. In the test environment, the installation ran for over an hour and the machine was subsequently rebooted.
  3. Check the Start menu. SAP BusinessObjects XI 4.0 should be available.
  4. Verify the installation by launching the Information Design Tool (IDT). Choose SAP BusinessObjects XI 4.0 | SAP BusinessObjects Client Tools | Information Design Tool from the Start menu. Note that you will not have any projects or repositories listed the first time you open the IDT.

  1. Create a session to your BOE Server repository by locating the Repository Resources view in the lower-left corner of the application, clicking the drop-down arrow next to the green plus sign, and choosing Insert Session.

  1. Enter the host and port of the your BOE Server repository in the System field, "Administrator" in the User Name field, the password you created for the Administrator created during BOE Server installation in the Password field, and click OK. The repository session will be listed in the Repository Resources view.
  2. Open the session by right-clicking it and choosing Open Session from the pop-up menu. The Open Session login dialog is similar to the Insert Session dialog except that includes an additional Authentication field in which Enterprise was filled in and grayed out. The Connections and Universes folders in the repository will become available when the repository session is open. These are the folders to which you will save the connections and universes you create in the IDT. More information about this will follow in the Feature Example section.
  3. Exit the IDT application.

Installing and configuring the Sybase database client software

The BOE Client applications require that the database client software be installed on the same machine.

For connectivity to ASE, you install the Sybase PC-Client software. It includes the Sybase Open Client libraries. The PC-Client installation program sets the environment variables the BOE Client applications need for Sybase Open Client connectivity.

The Sybase database client installation programs on Windows set the environment variables applications need to access the Sybase database client libraries for Open Client.

Once the Sybase database clients are installed, you need to configure them. This involves creating a Sybase Open Client server definition in the sql.ini file for the target Sybase ASE server. For details on configuring Open Client server refer to Sybase White Paper: Basic Connectivity for SAP BusinessObjects Enterprise 4.0 and Sybase Databases (http://www.sybase.com/detail?id=1093263).

Configuring BOE Client for access to Sybase data sources

With the BOE Client and Sybase database client software installed, you are ready to configure the BOE Client software for access to Sybase data sources. This involves modifying the Sybase Open Client sybase.sbo file. Specifically, modify the file in ...SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\sybase\sybase.sbo to set the "Quoted Identifier" parameter "true."

If you have any BOE Client applications open when you make these changes, you will need to close and reopen them for the sybase.sbo file changes to take effect. With these changes, the BOE Client environment should be ready to use. Continue to the Feature Example section to see an example of how to create a CR4E report BOE4.

Back to Contents


Feature Example

This section provides an example of how to create and publish a report using the Crystal Reports application and how to view a CR4E report with a Web browser.

Create a universe of Sybase data with the IDT

BOE Client provides the Information Design Tool (IDT) for the creation of universes, which are data objects defined with connection and meta data information. You use the IDT to create universes with Sybase data. Detailed information about creating a universe with Sybase data is provided in the Sybase White Paper: Basic Connectivity for SAP BusinessObjects Enterprise 4.0 and Sybase Databases (http://www.sybase.com/detail?id=1093263). Create a universe of Sybase data and publish it to the BOE repository. Then proceed to the next section to create a CR4E report with it.

Create a report with the Crystal Reports application

The following steps describe how to use the Crystal Reports application to create a CR4E report and save it to the BOE repository, making it Web-accessible.

  1. Launch the CR4E application by choosing Start | All Programs | Crystal Reports for Enterprise 4.0 | Crystal Reports for Enterprise 4.0. The SAP Crystal Reports for Enterprise home page opens.

  1. Connect to the BusinessObjects Enterprise Server. Log on to the Business Objects Enterprise. From the tool bar select File | Log On to SAP BusinessObjects Enterprise. The Log On window displays.
  2. Click the ellipse button to view the available server connections. Select a server connection, enter your user name and password. Click OK to continue. Note the status icon, located in the lower left-hand corner of the home page, now displays your status as logged on.

  1. Create a new CR4E report by selecting File | New Report. The New Data Source Connection window displays.
  2. Expand the Universes folder and select the Universe that contains the data you wish to use in the report. Click Next to continue. The Query Panel displays.

  1. To start the query building process, drag and drop data objects into the Result Objects pane. These data objects are used to generate a SQL statement that is then submitted to the database.

  1. Add Query Filters to your report by dragging and dropping data objects on to the Query Filters pane.
  2. To select an operator for the query, click the down arrow and select the operator. Specify a value and click Finish to close window.

  1. The query is processed and the Result Objects pane opens displaying the data in the report view.

  1. From within the Result Objects panel, interactive filters can be used to determine how values are displayed within the report. These filters hide values at the report level and do not modify the actual data retrieved from the data source.
  2. Save your work, making note of which folder you save the report to.

View a published report with a Web browser

  1. Using a browser, connect to the BusinessObjects Business Intelligence web application using a URL similar to http://aeboesp2:8080/BOE/BI. The Log on to BI Launch Pad page displays.
  2. Enter your user information and click Log On. The BI Launch Pad Home page is displayed.
  3. Select the Documents tab. From within the left-hand pane, click Folders.

  1. Navigate to the folder in which you saved the CR4E report. Expand the Public Folders and expand the folder where the CR4E reports have been saved. Double-click the CR4E report you wish to display.
  2. The report successfully displays.

  1. To refresh the report data click the refresh icon located in tool bar.

Back to Contents


Test Notes

This section contains information gained during testing, which may be helpful. The notes are divided into the following sections:

Test Note 1: Formatting a result object element to modify how a numeric value displays
Test Note 2: Formatting a result object element to modify how a date or timestamp values display
Test Note 3: Data Types tested and related notes

Test Notes 1: Formatting a result object element to modify how a numeric value displays

To format a numeric object element within the report, right-click the object element you wish to format. From the menu displayed select Format Result Object Element... The format dialog box appears.

Expand the Format section and select the formatting style preferences you wish to display on your report. For example, in the test environment the salary object element was selected.

To format the selected element, expand the Format section and select number. Enter the number of decimal places you wish to display.

Click Close to save your changes and return to the report design view.

Test Notes 2: Formatting a result object element to modify how a date or timestamp values display

To format a date object element within the report, right-click the object element you wish to format. From the menu displayed select Format Result Object Element... The format dialog box appears.

Expand the Format section and select Date. Select the formatting style preferences for the date object element.

Click Close to save your changes and return to the report design view.

Test Note 3: Data Types tested and related notes.

This section contains a table listing the data types tested for Sybase ASE 15.7. Following the table are test notes and workarounds for possible data type issues.

Data Types tested

A sampling of following Sybase ASE 15.7 data types were tested. Maximum values (or large values where maximum values are theoretical and restricted by hardware) and small values as well as null and not null values were tested. See Test Note 1 & 2 for information about formatting data, such as decimal values, and see the notes following the table below for additional information about data types.

Types Sybase Adaptive Server Enterprise 15.7
Exact Numeric Integer (int) Types

Tinyint, smallint, int, unsigned int, bigint, and unsigned bigint

The maximum and minimum Sybase ASE supported values for bigint (+/-9223372036854775807) displayed in scientific notation as 9e+018.

Overflow error occurs when creating a query that contained unsigned int and bigint. See Issue 1. The range in CR4E for Unsigned bigint displays a range from 0 to 9,223,372036,854,775,807. For Unsigned int CR4E displays a range from 0 and 2,147,483,647.

Exact Numeric Decimal Types

Decimal, numeric, smallmoney and money

See Test Note 1 for information about formatting numeric data.

Decimal(10,4) (8,8),and smallmoney - CR4E returned data as expected. Decimal (19,4) and money rounds up. For example 999,999,999,999,999.9999 rounds up to 1,000,000,000,000,000.0000 Decimal (31,0) returned scientific notation 1e+031, rounding also occurs. Numeric (18,0) (38,4) returned scientific notations 1e+018 and 1e+034 respectively.

Approximate Numeric Float Types

Float, real and double

Float values return as scientific notations, most negative values rounding up to zero. Real values round up. For example 12.3456697463989258 rounds up to 12.3456697464. Double maximum value returns NaN

Character (char) Types

Char in lengths 1 and 254 and varchar in lengths 10 and 254

Char, varchar, nchar and unichar (254 null/notnull) - CR4E returned data as expected. Report containing data types unichar (10) notnull and univarchar (10)null produce an error. See Issue 2.

Date/Time Types

Date, time, smalldatetime, datetime and timestamp. See Test Note 2 for information about formatting date data. CR4E does not provide an option to display milliseconds.

Binary (bin) Types

Binary and varbinary data types are not supported in CR4E

User-Defined Types

Test user-defined data types created from char, numeric and identity types. CR4E returned data as expected.

Text and Unitext types CR4E returned data as expected.

Back to top of Test Notes section | Back to Contents


Issues and Incompatibilities

Issue 1: Overflow Error occurs when executing queries containing unsigned int and unsigned bigint data.

An overflow error was encountered during the query building process containing unsigned int and unsigned bigint data types.

  1. Drag and drop object the unsigned int/bigint elements into the Result Objects pane.
  2. Click Data Preview Panel icon.to display data.
  3. Overflow error occurs while data is being refreshed.

Issue 2: Error occurs when executing queries containing unichar (10) and univarchar (10).

An error was encountered during the report creation which contained unsigned int and unsigned bigint data types.

  1. Drag and drop object the unsigned int/bigint elements into the Result Objects pane.
  2. Click Data Preview Panel icon.to display data. Data displays properly in the Result set pane.

  1. Click Finish to save query and close window.
  2. Error occurs and report fails.

Note: Reports containing unichar (254) and univarchar (254) data value types are created and processed without issue.

Back to Contents


Test Environment

This section provides details about the test environment.

BOE Client Machine

Hardware or Software Description or Version

Operating Environment

1 - Intel(R) Xeon(R) CPU E7320, 2.13 GHz processor, 32-bit VMWare virtual machine
Memory:

4.00 GB RAM

Disk 20 GB
Operating System Microsoft Windows Server 2003 Enterprise x64 Edition Service Pack 2
SAP Crystal Reports for Enterprise SAP Crystal Reports for Enterprise XI 4.0, Version 14.0.2, Build: r364_v20110603
SAP BusinessObjects Information Design Tool SAP BusinessObjects Information Design Tool, Version 14.0.2
Sybase ASE database client

Sybase ASE PC-Client, including Sybase Open Client 15.0

Windows BOE Server Machine

Hardware or Software Description or Version

Operating Environment

1 - Intel(R) Xeon(R) CPU E7320, 2.13 GHz processor, 32-bit VMWare virtual machine
Memory

4GB RAM

Disk 80 GB, divided between two disks: 40 GB per drive
Operating System Microsoft Windows Server 2008 R2 (64-bit)
Software development kit Microsoft .NET Framework 3.5 SP 1(Version 3.5.30729.4926)
BOE repository and data source database Sybase Adaptive Server Enterprise version 15.7
Sybase native connectivity, included with Sybase ASE server installation Sybase ASE PC-Client, including Sybase Sybase Open Client 15.0
BusinessObjects Business Intelligence Platform

SAP BusinessObjects BI platform 4.0.

Back to Contents


Other Sources of Information

Sybase ASE Resource Page

Sybase provides a site dedicated to the Sybase ASE product. On this page, there are links to Data Sheets, White Papers, Webcasts / Podcasts, News, Case Studies (customer success stories), Analyst Reports, Technical White Papers, EBF's, FAQ's, Platform Certifications and Technical Videos. There is also a link on this site to a free download trial of Sybase ASE.

The Sybase ASE Resource Page is located at: http://www.sybase.com/ASE

Sybase Partner Program

For more information about the Sybase Partner Program, please visit the Sybase Partner Program website.
http://www.sybase.com/partner

Back to Contents


Vendor Contact Information

Vendor Name: SAP America, Inc.
Website: http://www.sap.com/index.epx#/countries/index.epx

Back to Contents




Back to Top
© Copyright 2010, Sybase Inc.