Crystal Reports
Crystal Reports
Crystal Reports
Release Notes
BusinessObjects XI Release 2
Windows
Patents Business Objects owns the following U.S. patents, which may cover products that are offered
and sold by Business Objects: 5,555,403, 6,247,008 B1, 6,578,027 B2, 6,490,593 and
6,289,352.
Trademarks Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are
trademarks or registered trademarks of Business Objects SA or its affiliated companies in the
United States and other countries. All other names mentioned herein may be trademarks of
their respective owners.
Third-party Business Objects products in this release may contain redistributions of software licensed
contributors from third-party contributors. Some of these individual components may also be available
under alternative licenses. A partial listing of third-party contributors that have requested or
permitted acknowledgments, as well as required notices, can be found at:
http://www.businessobjects.com/thirdparty
Contents
Chapter 1 Contents 3
Java SDK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
RAS SDK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
JSP tutorials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
International . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Web Services portal sample . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
International issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
Crystal Reports developer samples . . . . . . . . . . . . . . . . . . . . . . . . . . . 42
International . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Migration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Connections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Sybase ASE ODBC . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63
Deployment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65
Upgrading and migrating issues . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Dashboards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Analytics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Interactive Metric Trend . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68
Map analytic . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69
Pareto chart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69
Dashboard Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69
Performance Manager . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70
My Goals page . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70
Predictive Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71
Process Analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72
2-tier products: Set Architect and Set Analyzer . . . . . . . . . . . . . . . . . . . . . . 72
chapter
1 BusinessObjects XI Release 2 Release Notes
About these notes
chapter
2 BusinessObjects Enterprise
Installation
Installation
• For a complete list of system requirements and supported platforms, see
the platforms.txt file included with your product distribution. For
complete installation instructions, see the installation guide
(install.pdf).
• Disable all antivirus software before installing BusinessObjects
Enterprise components. Enable your antivirus software after the
installation.
• Due to third-party applications (such as JDK, JRE, and Tomcat) that do
not support directories with non-ASCII characters, BusinessObjects
Enterprise XI R2 does not support installation to a directory that contains
non-ASCII characters.
• If BusinessObjects Enterprise XI is uninstalled and then re-installed, the
tables from the previous MySQL installation are used as the CMS
repository.
• Users with Non-ASCII usernames will fail to log on to BusinessObjects
Enterprise XI R2 using Java Windows AD authentication. This is a
limitation of the Java API.
Non-ASCII usernames are not supported by Kerberos. This is a known
Kerberos limitation. The Kerberos V protocol is not internationalized, and
currently does not provide a means of specifying the character set to be
used.
• During a custom installation, the Web Component Adapter (WCA)
screen may appear even though the option to install Tomcat has already
been selected.
• If you use Microsoft SharePoint and add a report in .NET InfoView, an
error message appears.
Workaround: Do not deploy the .NET WCA to the “Microsoft SharePoint
Administration” IIS website, which is part of the Microsoft FrontPage
Server Extensions.
• BusinessObjects Enterprise installs MySQL 4.1.9 and configures it to
start by default on port 3306. If you have another version of MySQL
installed which is already running on this default port number, the version
of MySQL that BusinessObjects Enterprise installs will not start.
Workaround: Before installing BusinessObjects Enterprise, check
whether MySQL is installed on the machine and if so, what port it is
configured to start on. If it is configured to start on port 3306, specify a
different port number for MySQL when installing BusinessObjects
Enterprise.
Import Wizard
• When you choose to import inboxes, note that inboxes will be imported
only for the users that you are importing. The user is not automatically
selected for import when you select the user’s inbox for import.
• When you choose to import repository objects from BIAR, all repository
objects in the BIAR data source will be imported.
• In some cases, users who are trying to import “users and groups” or
“folders and objects” from the BIAR source file will not be able to do so.
This happens when one of the objects in the source file is corrupt. Please
note that the Import Wizard will not report an error if it encounters a
corrupt object and fails to retrieve it and others from the BIAR file.
• A timeout may occur when a large number of users and groups are being
imported to BusinessObjects Enterprise XI Release 2.
Workaround: To avoid a timeout, ensure that third-party authentication is
disabled. Disable third-party authentication after all of the objects have
been counted, but before Finish is clicked.
• When working with Dynamic Cascading Prompts (DCPs), users need to
pick "Import all repository objects" from the "Import repository objects
options". Selecting other options will result in broken DPCs after the
import.
• When a BusinessObjects 5x universe is imported, a restriction is created
for groups and a duplicate restriction is created for the user. The user
ends up having 2 identical restrictions. This is an error.
• Connections are not migrated correctly from the 5.x repository for
Informix Connect for IDS9.4.
Documentation
• The table on page 273 of the BusinessObjects 5.1.x to XI Release 2
Migration Guide and on page 303 of the BusinessObjects 6.x to XI
Release 2 Migration Guide incorrectly refers to calculation issues related
to BusinessObjects from versions 5.1.6 through 5.1.9 in the second
row. This row in fact refers to calculation issues related to
BusinessObjects 6.0.
InfoView
• When you expand and collapse the Events or Server Groups options
when scheduling a document from InfoView, other previously set
options are lost.
• The error “Text-only printers are not supported. Please change your
printer” occurs when you schedule a Desktop Intelligence document
to be printed using a Custom Printer, and you supply the IP address
of the printer.
LiveOffice
• In Microsoft Word 2003, when part of a report view is copied and pasted
to another area of a document and the view is refreshed, the copied
section of the report view disappears.
• In Microsoft Excel, when you right-click the legend of a chart, the Drill
option is active. It should not be active because you cannot drill-down on
the legend of a chart.
Scheduling issues
• You cannot re-schedule Web Intelligence documents to Excel or PDF
formats. Depending on your precache settings, these options may
incorrectly appear.
• Scheduling a Publication will fail when done by a third party who lacks
the following rights:
Documentation
• The BusinessObjects Enterprise XI Administrator’s Guide description for
the command-line option “-cleanup” reads "Specify the frequency (in
minutes) with which the server cleans up listener proxies"; however, the
Event Server uses minutes/2. For example, “-cleanup 10” will run the
cleanup thread in the event server every 5 minutes.
• For information on how to install the Crystal Reports Offline Viewer,
please see chapter eight of the InfoView User’s Guide.
• The BusinessObjects Enterprise XI Administrator’s Guide description for
the command-line option “-threads” reads "Use a thread pool of the
specified size. The default is one thread per request." The actual
behaviour of the “-threads” parameter depends on the size of the pool of
worker threads the CMS initializes and draws workers from. The
maximum is 150, and the minimum is 12. The default is 50 if the
parameter is not specified.
Security
• When Java Windows Active Directory (AD) authentication is used, users
with non-ASCII user names are unable to log in. This is a limitation of the
Java API.
Java InfoView
• If you're running Sun Application Server 8 upgrade 1, you cannot create,
view, or modify a Dashboard from Infoview.
Workaround:
To use InfoView, the following actions should be applied to avoid possible
XML/XSLT processor conflicts:
1. Set the class-loader delegation policy in the WEB-INF/sun-web.xml
file to "true" as shown in the following example:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sun-web-app PUBLIC "-//Sun Microsystems,
Inc.//DTD Application Server 8.0 Servlet 2.4//EN"
"http://www.sun.com/software/appserver/dtds/sun-web-
app_2_4-0.dtd">
<sun-web-app xmlns="http://java.sun.com/xml/ns/j2ee">
<context-root>businessobjects/enterprise11/
desktoplaunch</context-root>
<class-loader delegate="true"/>
</sun-web-app>
2. Create a JSP script in the deployed application (or add the code to
an existing web application script) with the following content:
<%
System.setProperty("javax.xml.transform.TransformerFa
ctory",
"org.apache.xalan.processor.TransformerFactoryImpl");
%>
3. Before accessing Infoview, execute the JSP script from step 2. This
will set the correct XML transformer to work with Business Objects
applications.
• Users can not log on to the BusinessObjects Enterprise Java Infoview
when using the server IP address in the system field. The workaround to
achieve a successful logon is to have the client application log on with the
hostname of the Central Management Server (CMS).
• InfoView does not deploy correctly if system properties are not set
appropriately.
Workaround: Set the following propery in a JSP file, or globally in the
SAP application server:
System.setProperty("org.xml.sax.driver",
"org.apache.xerces.parsers.SAXParser");
• To enable printing from a DHTML viewer using ActiveX print control,
ensure that gzip compression is turned off for the following MIME types:
• - application/x-epf
• - application/x-ack
• - application/x-eor
• - application/x-etf
• - application/x-emf
• You may encounter problems when viewing double-byte characters if you
are using an Oracle 10G server or an SAP application server.
Workaround: Before deploying the desktop.war and jsfadmin.war files,
modify the corresponding web.xml so that the <filter> and <filter-
mapping> elements are uncommented.
RAS Java
• Some paper sizes and paper sources exposed in the SDK are not
supported by JDK 1.4. If users select the unsupported print options, an
error message appears.
Viewers
• The viewers fail to support reports that contain formula fields or database
fields whose names contain either of these brackets: {}.
• Use the new database logon format when using the RAS server. The old
format is as follows:
user=value
password=value
Some of the recommendations use a formula that works with the number of
CPUs on a server. The number of CPUs in each formula is represented by the
variable N. To adjust configuration settings when you have hyperthreading
enabled, you must use the number of logical CPUs instead of the number of
physical CPUs. For example, if you have a four-processor server with
hyperthreading enabled, the value of N in a formula is 8 rather than 4.
International issues
• On the Solaris and AIX platforms, if you need to run the Central
Management Console (CMC) in Chinese, Japanese, or Korean, you must
use a Chinese, Japanese, or Korean locale on the J2EE application
server that hosts the Web Component Adapter (WCA). To set the locale,
set the environment variables LANG and LC_ALL before starting the
J2EE application server.
• If you have deployed WebSphere 5.1 or WebSphere 6.0, you may
encounter problems while viewing InfoView’s preferences page using
Asian locales.
chapter
3 Crystal Reports
Installation
Installation
• For a complete list of system requirements and supported platforms, see
the platforms.txt file included with your product distribution. For
complete installation instructions, see the installation guide
(install.pdf).
• Disable all antivirus software before installing BusinessObjects
Enterprise components. Enable your antivirus software after the
installation.
Data access
• A document containing a list of limitations for the latest version of the
native XML driver can be found on our Technical Support site.
Report creation
• To find a value for a selection or content locale, put the appropriate
special field (Selection Locale or Content Locale) in your report and view
the value from the report.
• Command objects that use a dynamic prompt, or a prompt that includes a
cascading list of values, will malfunction if added to the BusinessObjects
Enterprise Repository in this version. Such a command object will return
an error when you refresh the data of the report that you created from it.
• When you define an XML element for a string type, you can define it as
follows to remove padded spaces:
<xsd:simpleType name = "myString">
<xsd:restriction base = "xsd:string">
<xsd:maxLength value="255"/>
<xsd:whiteSpace value = "collapse"/>
</xsd:restriction>
</xsd:simpleType>
<xsd:element name="col1">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="col1" type="myString" />
</xsd:sequence>
</xsd:complexType>
Documentation
• The option “Limit size of result set to” that is described in the Crystal
Reports Online Help is unavailable in this version.
• A new, undocumented function called
CountHierarchicalChildren(GroupingLevel) has been added to
this version. Use this function to suppress hierarchical group headers or
footers when no child levels exist.
CountHierarchicalChildren(GroupingLevel)
GroupingLevel is a function that determines the level of an existing
group.
The CountHierarchicalChildren(GroupingLevel) function returns
the number of direct child hierarchical groups for any given level of the
grouping hierarchy. Grandchild (and deeper) groups are excluded from
the count.
This number does not count the number of detail records in any group.
So, the output will be different from count({field}) when summarized
across a hierarchy. (The count({field}) function counts detail
records.)
Developer issues
JDBC Driver
• The LiquidData JDBC Driver may cause the following code to fail:
ResultSet rs;
ResultSetMetaData rsmd = rs.getMetaData();
int colType = rsmd.getColumnType(i);
chapter
4 Desktop Intelligence
General information
General information
• When installing Desktop Intelligence, all languages are installed with the
product. But at the first logon, Desktop Intelligence is launched in
English.
Workaround: Change the language manually as follows:
1. Click Options on the Tools menu.
2. In the dialog box that opens, go to the General tab and choose the
language from the list.
• If you change the language in Desktop Intelligence as described above, if
the document locale is not modified correspondingly the number formats
associated with the selected language are not taken into account. English
number formats are used instead.
Workaround: When changing the language, be sure to click the
Language button.
• In Desktop products (Desktop Intelligence and Designer), the list that
enables you to set the current language (Tools > Options > General tab)
always displays the language names in English.
• To start a new session in Offline mode, you must first connect to the CMS
with your login in Online mode. This action refreshes the .lsi file.
• To work in 3-tier mode, you must first install Desktop Intelligence on the
client machine, then log on to InfoView and download the .jre or .net file
by creating, modifying or editing a Desktop Intelligence document.
• When you apply a filter on a date object for a document where the user
interface locale (UIL) and the user format locale (UFL) do not match, the
display of the report is blank.
• Teradata stored procedures with OUT variables are not supported by
Business Objects as concerns data providers and the Connection Server.
• When you open a Desktop Intelligence document from the InfoView
portal, sections don't appear in the report map.
• When you schedule a Desktop Intelligence document and select the
Custom Printer option with IP Address as the input, scheduling fails.
• It is not possible to change the data source of a BusinessObjects 6.x
document from Desktop Intelligence.
• When an REP file is saved as HTML from Desktop Intelligence, breaks
with center across (horizontal) do not work.
Migration
• In a mixed deployment of BusinessObjects 6.x and BusinessObjects XI
Release 2, you cannot open a BusinessObjects 6.x document using
BusinessObjects 6.5 in 3-tier mode from within the InfoView 6.x portal.
Workaround: In this situation you can open a BusinessObjects 6.x
document using BusinessObjects in 3-tier mode only by launching
BusinessObjects in 3-tier mode from the Windows Start bar. In addition,
these conditions must be met:
• BusinessObjects 6.x must have been installed prior to
BusinessObjects XI Release 2.
• You must manually copy the .rkey file that points to your InfoView 6.x
repository to your locdata folder if this has not already been done.
• Use of Microsoft VBA (for example, a VBA application using the full client
SDK, or documents containing VBA procedures) is not supported when
Desktop Intelligence XI R2 is installed on a machine that already has
BusinessObjects 6.x installed.
Workaround: Be sure to uninstall BusinessObjects 6.x prior to installing
Desktop Intelligence XI R2.
Drill
• The arrow icon for the drop-down list on the Drill toolbar is not displayed
when a dimension name contains more than 255 characters.
• You cannot drill in a dimension placed in the body of a crosstable.
• You cannot drill down or drill by from the legend, although can drill up.
• When you perform certain actions in drill mode, the labels of the charts
may change orientation.
Report formatting
• When you specify a format for a negative value in the Negative text box
on the Number tab of the Cell Format dialog box, you must include the
minus symbol (-) before the format. For example, to specify a negative
format with three decimal places, you should enter -0.000.
• With linked tables, if you select the Repeat block on every page option in
the Table Format dialog box, Business Objects recommends you apply
this option to all the tables. Otherwise the blocks may overlap.
• In reports, a block set to repeat on every page may attach to the header
of another block at the top of each subsequent page.
Workaround: When necessary, insert an empty cell between two tables
to prevent the repeating block from attaching to the header.
• When the display of a block or a cell exceeds 70% of the page layout, the
Repeat on every page option is not applied. This avoids having
overlapped blocks from the second page onwards.
Workaround: Do not use the Repeat on every page option when a block
or cell exceeds 70% of the page layout.
Saving Documents
• When you activate the Automatic Open After SaveAs option (in Tools >
Options > Save tab) and save a document as HTML, PDF, XLS, RTF or
TXT, the file is opened in the appropriate application.
• The number and format of cell borders are not kept when a document is
saved as HTML.
• Saving a document with a long file name as HTML may fail.
• When you launch Desktop Intelligence in the English version and save a
document with a long file name as HTML, an error message may appear
in French.
• When a report is saved as a PDF file, the Symbol font is not converted if
the font style is bold and/or italic.
• When defining a formula or a variable with "In CurrentPage" as the
context, the corresponding calculations won't be displayed in the XLS,
HTML, TXT, and RTF files when the report is saved in these formats.
• When a Desktop Intelligence report is saved in Microsoft Excel format,
column width and value display issues may occur:
• If a column is incorrectly sized in Desktop Intelligence, the column
width is reduced and the value displayed as ### in the Excel file.
Printing
• Some printer drivers do not differentiate the colors used in graphics and
may print similar shades for different colors. To lessen the impact of this,
Desktop Intelligence creates differences in the color palette to print colors
or shades that are clearly distinguishable.
• If you want to print several reports containing the Euro character at the
same time, you must use the same printer (and the same printer driver),
otherwise the Euro character will not be printed after the first report.
• The hyperlinks won’t be activated if you select the Print as
BusinessObjects 4.1 option in the Options dialog box (Tools > Options >
General tab).
Break
• The Center Value Across Break option has no effect on a long cell,
even if this option is activated in the Breaks dialog box.
Manage Categories
• In the Add and Edit Categories dialog boxes (Export to Repository >
Categories > Manage > Add/Edit), clicking F1 on the keyboard does not
display the help files. There are no help files associated with these dialog
boxes.
Publication scheduling
• Publication instances scheduled to the Default destination fail if the Inbox
destination is disabled on the Desktop Intelligence job server.
Workaround: Enable the Inbox destination on the job server.
• Publication recipients do not receive their content when two conditions
are true:
• The publication is scheduled to Inbox using job server defaults.
• The Desktop intelligence job server has one or more recipients set
for the Inbox destination.
Under these circumstances all the content will go to the job server
recipients instead of the Publication recipients.
Workaround: To avoid this problem, either schedule using custom Inbox
settings, or do not set any Inbox recipients.
chapter
5 Developer Library
General
General
• The Business Objects Developer Library is installed with
BusinessObjects Enterprise and can be accessed through the Start
Menu, navigating to the default install directory, or through the Business
Objects Developer Zone website.
Start Menu:
Start > Programs > BusinessObjects XI Release 2 > BusinessObjects
Enterprise > BusinessObjects Enterprise Developer Documentation
Default Install Directory:
C:\Program Files\Business Objects\BusinessObjects Enterprise
11.5\Developer_Help\en\default.htm
Website:
http://www.businessobjects.com/products/dev_zone/default.asp
Designer SDK
The "Type" property of the "Key" Object is read-only.
Java SDK
• If you use AD Authentication with Kerberos, you cannot log on to
BusinessObjects Enterprise with a non-ASCII user name. Kerberos
supports only ASCII user names.
RAS SDK
ReplaceConnection suppresses all errors related to database connectivity.
JSP tutorials
• The XML report output for a document with multiple reports always
returns the first report.
• Desktop Intelligence returns an invalid Last Refresh Date
International
• Creating a Web Intelligence document returns a compilation error in the
Japanese version.
International issues
Crystal Reports developer samples
• Windows Start menu links for developer samples do not work in non-
English operating systems.
chapter
6 Import Wizard
General
General
• When installing BusinessObjects Enterprise, we recommend running a
Server Installation in order for the Import Wizard to run correctly.
• Import Wizard does not test that the File Repository Server and Input
Server are running before starting to import objects.
Workaround: Make sure the File Repository Server and Input Server are
running before running the Import Wizard.
• Import Wizard does not test license validity before starting to import
objects.
Workaround: Make sure you have a valid license before running the
Import Wizard.
• The “Clear All” buttons on Universe and Document dialog boxes clear
even the greyed checkboxes.
• Selected afd cannot be unselected.
• The OLEDB connection cannot be set correctly in the Application
Foundation Repository dialog box.
Universes
• Large universe descriptions are not fully migrated and may become
truncated.
• Migrated UNV files have an incorrect cluster GUID.
• Unchecking Universe for Metrics is possible after selecting for import
“universes and connections that the selected WebIntelligence,
BusinessObjects and Application Foundation documents use directly, as
well as all the universes used for metric definition.”
• Import Wizard may display universe and document domains that don't
exist in Supervisor.
Documents
• When you migrate a REP document or publish a document from Desktop
Intelligence, and then refresh it in Infoview, the date and time in the
Status bar are not updated.
• From XI to XI R2, migrated Web Intelligence reports do not update
precaching properties to the new format.
• No warnings are displayed when orphaned documents are migrated.
Performance Management
To see other release notes for Performance Management see Performance
Manager.
• Even if you deactivate the Import Categories, Import Documents and
Import Universes options while migrating from Application Foundation
6.x to BO XI R2, the Select Categories, Select Document, and Select
Universe screens appear and all Application Foundation 6.x related
documents, categories, universes, and connections are imported.
• Universes with subjects based or metrics associated are not imported.
• On SQL - When you select a connection to make the repository point to
the Application Foundation repository, the Connection box displays data
that is not from that connection.
• On the Setup tab of the Connection box (pointing to the Application
Foundation repository), too much data is displayed. The correct
connection names are displayed in the middle of other information
wrongly displayed as connections.
• If you add a filter to an existing metric, the metric entry is duplicated.
• During the migration of goals (in goal name) and metric tree (in metric
tree name and description), accentuated character migration does not
occur correctly.
• Upon displaying the migrated dashboards, the AAAnalytics process used
over 200K of memory and more than 90% of CPU resources. Tomcat
also uses large amounts of CPU at random.
• The Metric list on the dashboard is not well displayed after migration for a
non-administrator user.
• The Metric list incorrectly offers “Display Goal Analytic” from its
navigation menu when no goal exists. When the Metric list has been
navigated, the “Display Goal Analytic” option is always available from the
Navigation menu for all items listed, whether a goal exists or not.
• After migration, the user can create a very long rule; after refresh the
formula definition fully disappears.
• The metrics of some universes are set to Manual Entry and are no longer
available for refresh.
• The warning message that appears when migrating from Application
Foundation 6.1 does not contain all of the necessary information.
General
• Migration to Performance Management XI R2 is only supported from the
following versions of Application Foundation: 6.1.b, 6.1.3, 6.5.1 and
Performance Management XI.
• There is a check on repository version in Import Wizard that should block
versions prior to 6.1.b but currently allows migration from versions 6.1
and 6.1.a. Migration from these versions of Application Foundation is not
supported.
• Business Objects recommends that you migrate all of your Application
Foundation objects at one time using the Import Wizard. An incremental
migration can result in corrupt links.
• When upgrading the Application Foundation repository from version 6.x,
use the Import Wizard. The repository upgrade in the Performance
Management Setup does not upgrade the version 6.x repository to XI R2.
Business Objects strongly recommends that you back up your
Application Foundation repository before launching the Import Wizard.
Failure to do so will result in the repository being unreadable in the 6.x
environment. To maintain the source system after migration, follow these
steps after the XI R2 installation:
1. Copy your AF 6.x repository using the account under which you will
access the Performance Management repository.
2. Use the Import Wizard to migrate your Business Objects and
Application Foundation objects to the CMS and to upgrade the
Application Foundation 6.x repository.
3. In Setup, configure Performance Management to use the migrated
repository.
Known Issues
• The Import Wizard does not import Application Foundation 6.x schedules
to CMS on Oracle.
• Before importing Application Foundation 6.x schedules to an SQL server
CMS with the Import Wizard, manually create an AFScheduleProgram
object in the destination CMS. The Import Wizard does not correctly
import AFSchedules to SQL server unless you perform this step before
running the Import Wizard.
• Links in personal dashboards to personal documents are not migrated.
• When upgrading the performance management repository from version
XI, use the repository upgrade in System Setup. You cannot upgrade a
version XI repository to version XI R2 in the Import Wizard.
• When migrating from Application Foundation versions 6.1b, 6.1.3, or
6.5.1 to BusinessObjects Enterprise IX Release 2, access restrictions on
dashboards may not be migrated correctly. Unauthorized users may be
able to access restricted dashboards and dashboard items. Other
performance management rights imported to the CMC may not be
applied correctly in the destination environment, and some users may
lose certain access rights.
chapter
7 Intelligent Question
Exporting to Web Intelligence
Configuring SSL
In the CCM, the Protocol tab in the Properties dialog box is used to configure
SSL for all servers in the Business Objects system. However, for the Question
Engine, the Protocol tab does not appear.
You need to configure the command line parameters manually. Enable SSL
for (at a minimum) CMS, PageServer, and CacheServer.
To add the SSL command line parameters to the Question Engine:
1. In the CCM, stop the Question Engine if it is running.
2. Right-click QuestionEngine and select Properties.
3. Click in the Command text box and scroll to the end of the text.
4. Paste in the command line options as described in the CCM Help (look
for SSL). For example:
-protocol ssl -ssl_certdir "C:\ssl" -ssl_mycertificate
"servercert.der" -ssl_trustedcertificate "cacert.der"
-ssl_mykey "serverkey.pem" -ssl_mykey_passphrase
"passphrase.txt"
To find the correct command-line parameter values for your server after
SSL is configured, right-click the CMS, select Properties, click in the
Command text box, and copy the SSL-related parameters from there.
5. Make sure all the servers are running.
6. Open InfoView and click Intelligent Question.
The Question Panel should function correctly.
chapter
8 OLAP Intelligence
Installation
Installation
• For a complete list of system requirements and supported platforms, see
the platforms.txt file included with your product distribution. For
complete installation instructions, see the installation guide
(xir2_oi_olapinstall_xx.pdf).
Essbase support
A new Essbase/DB2 OLAP driver delivers enhanced support for native
Essbase features such as multiple alias tables, Dynamic Time Series,
attribute dimensions, and user-defined attributes.
Application behavior
• Calculated members from higher hierarchical levels in a dimension
appear with members from lower levels. The problem occurs if you use
OLE DB for OLAP (MSOLAP) data sources, your Worksheet contains a
dimension with three or more levels in its hierarchy, and calculated
members are on some or all of the levels in the hierarchy.
For example, if your dimension has four levels (level 4 being the lowest
child level), and calculated members exist at all four levels, when you
invoke the Member Selector by right-clicking a level 1 member, and then
use the function Add Children to Selection > Custom to display only the
level 4 members, the calculated members at level 2 are displayed along
with the level 4 members.
You can manually deselect the calculated members to remove them from
the Worksheet.
• OLAP reports that have been saved to BusinessObjects Enterprise by
the OLAP Intelligence designer appear as reports created and saved by
the Interactive Viewer. The Worksheet and Chart buttons appear on the
toolbar, and the Worksheet and Chart in the report can be toggled on and
off.
The problem happens in the following situation:
• An OLAP report is created in the Interactive Viewer and saved to
BusinessObjects Enterprise.
• The report is closed, but the InfoView session is left open.
• The report is then opened in the OLAP Intelligence designer and re-
saved to BusinessObjects Enterprise with the same name.
• In the DHTML Interactive Viewer, the whole page is refreshed after the
Member Selector window is closed.
The cause of the problem is that some browsers, such as Firefox and
Mozilla, are capable of refreshing only the entire page, not components
on a page.
For users of the BusinessObjects XI Integration Kit for SAP
• Null suppression is on when an OLAP report is first created.
This behavior is intentional when creating OLAP reports against an SAP
BW data source, to maintain consistency with SAP default views. You
can turn off null suppression with the toolbar button.
• The Member Selector in the Set Parameters dialog box may be slow to
load large numbers of members. As a result, several minutes may pass
before the Set Parameters dialog box appears; then it takes more time for
the Member Selector to display.
• The URL syntax for opening a .car file in .NET InfoView is changed in
OLAP Intelligence XI R2.
Old URL syntax:
http://<Machine name>/styles/csp/
analysisviewer_sap.csp?id=<Report ID>&sap_client=<SAP
Client>&sap_sysid=<System ID>
New URL syntax:
http://<Machine name>/businessobjects/enterprise115/SAP/
InfoView/analysisviewer_sap.csp?id=<Report
ID>&sap_client=<SAP Client>&sap_sysid=<System ID>
International issues
• In .NET InfoView, the Calculated Members dialog box does not load
properly with some Asian languages unless the Asian language packs
are installed on both the server and client machines.
Workaround: Install Asian language packs on both the server and client
machines. To install the language packs on a machine running Microsoft
Windows, do the following:
1. Click Start > Control Panel > Regional and Language Settings.
2. On the Languages tab, select “Install files for East Asian languages”,
and then click OK.
3. Reboot.
General issues
• Errors occur when OLAP Intelligence reports are previewed in the
Central Management Console. Note that the Preview function is
designed only for use by system administrators who want to ensure that
reports display correctly. If you try to manipulate or save reports in
preview mode, the errors occur.
• The OLAP Intelligence Navigation toolbar may not be removed when the
OLAP Intelligence Add-In for Excel is disabled. When the OLAP
Intelligence Add-In is disabled from the Add-Ins option on the Tools menu
in Microsoft Excel, the OLAP Intelligence toolbar is removed, but the
OLAP Intelligence Navigation toolbar may remain. Use the Customize
option from the Tools menu in Excel to manually remove the toolbar.
• When connected to a MSOLAP data source, OLAP Intelligence may
produce erratic behavior when the underlying data cube is refreshed.
Your report may become unstable and potentially unusable.
Documentation
• In the chapter “Enabling the DHTML Interactive Viewer in Java InfoView“,
a paragraph in the Prerequisites section should read as follows:
OLAP Intelligence components, by default, are installed to the directory
C:\Program Files\Business Objects\OLAP Intelligence
11.5\. If you choose to install to a different location, substitute your
install path for the default in the generic Java Virtual Machine (JVM)
arguments. The instructions in this chapter assume that you have
installed to the default location. You must use the shortened directory
naming convention shown (that is, C:\Progra~1\ rather than
C:\Program Files\) to ensure that no spaces are entered in the
argument line. Spaces can be misinterpreted as an additional argument
and can cause errors. If your operating system does not support
shortened directory names, use the full path surrounded by quotation
marks.
chapter
9 Performance Management
General
General
• When the maximum number of concurrent users is reached, the last user
to log in has limited options within InfoView and no access to the
performance management repository, and users already logged in who
have not accessed the performance management repository will be
denied access.
Swedish
• Truncations and translation errors occur when you try to create
dimensions, analytics, populations, sets, and models.
Installation
• If you are installing the Performance Management products on a SQL
server, the AFdemo can be installed on the SQL server as a demo
Performance Management repository. If you do this, however, the
datasource name will be created, but the connection might not work
properly.
Workaround:
1. In the CCM, stop the servers.
2. In Designer, select Tools > Connection.
3. To the AFDEMO connection, add your SQL server password.
4. Test the connection to make sure it works.
5. In the CCM, restart all of the servers.
The AFDEMO is now available.
Note: The database does not support double bytes. If you want the
database to support them, you need to change the collation name.
To do this:
1. In the CCM, stop the servers.
2. In the SQL Server Query Analyzer, log in to your SQL server.
Configuration
International
• You cannot populate ASCII data in a dimension on Sybase.
Migration
• When you migrate from Business Objects 6.1.3 on a SQL server, the
target database and user in Performance Management are not visible,
but the connection still exists and works correctly.
Connections
Sybase ASE ODBC
• An error occurs if you use the Sybase Adaptive Server 12 open client to
create the performance management repository. You need to use a
Sybase ASE ODBC driver to create the repository.
To do this:
1. Install Sybase using the correct language model.
Deployment
• There is one additional WAR file to deploy if you installed performance
management and you are deploying on any of the following web
application servers:
• WebSphere
• WebLogic
• Oracle Application Server
• SAP NetWeaver
This WAR file, which contains the online help for performance
management, is called afhelp.war and can be found at C:\Program
Files\BusinessObjects\Performance Management 11.5. The WAR file
should be deployed with the context root /bobje.
• To deploy performance management products on a different server from
BusinessObjects Enterprise XI R2:
1. Install your web application server and Web Component Adaptor
(WCA) on Server 1.
Dashboards
• Process Tracker is not available in the Corporate Analytic folder as an
analytic or a link.
• In the InfoView preferences, when you change the options Create a
Single Dashboard or Create a Tiered Dashboard in the General tab,
you need to click OK. If you click Apply, your option change will not be
applied.
• The scroll bar does not function for the Corporate Tiered Dashboard list
in performance management.
• In SAP Netweaver, a page error occurs when you create a goal or
analytic and click on Add to my dashboards.
Analytics
• When you click Cancel from the analytic prompt, the analytics properties
page reappears with all or most settings returned to the default settings.
• When you click Save As for an analytic saved in FLASH format, the title
does not appear and the only format available to save in is SVG.
• When you use the [Red] or [Blue] option in Designer to format labels, the
option name appears in the Y axis label of the Goal analytic.
For example: if you apply the [Red] option in Designer, it will appear as
100 [Red] on the Y axis instead of 100.
• The WebSphere application server crashes when you try to create a Map
analytic.
Workaround: Define a system environment variable:
Name: JITC_COMPILEOPT
Value: SKIP{com/corda/pcis/c/c}{a}
• When you set the following metrics to open in a separate window, they
still open in the parent window:
• Speedometer
• Interactive Metric Trend
• Metric List
• When you try to refresh an analytic after e-mailing it to someone, the
following error message appears: “The document you are trying to open
no longer exists in the system.” However, the document does still exist.
Workaround: Log out and back in again to see the document.
• When you open a Metric Forecaster document in Predictive Analytics,
two error messages appear, but if you click OK for both of them, the
document appears as normal.
• An error occurs when you link to an analytic from within another analytic,
if you specify the repository type as 'M' or 'P' when creating the
openAnalytic URL.
Documentation
• The Dashboard Manager online help incorrectly states that you can
create a metric or goal type using a Change variation to detect lag.
Lag can be detected once the analytic is created:
1. Click the analytic to select the beginning point.
Map analytic
• If you select the GL (Groenland) option in the Map analytic, the following
error appears: "Couldn't Create Image".
Pareto chart
• A Pareto Chart created in Application Foundation 6.5.1 and migrated to
BusinessObjects Enterprise XI Release 2 does not appear in snapshot
format.
Dashboard Manager
• Use of values larger than 1.0E27 may cause performance management
to freeze. When you try to display some analytics (like the goal analytic)
that contains such values, an error occurs.
• If you select the 'Top Slices' document in the Metrics Analytics tab, it
appears to load, but then the following error message appears:
This document is not available on MS SQL Server Database.
• In the Metrics page, the refresh of groups of metrics does not always
work.
Workaround: In this case, refresh each of the metrics belonging to the
group individually.
• The Destination section in the Scheduler Analytic Refresh dialog box
shows a list column that contains the following item:
??schedule.destination.defaultmanaged???
• If you are using SAP Netweaver, a script error occurs when you try to
schedule a refresh.
• When you create metrics, a metric name is generated automatically that
may not make sense in some languages. You should type your own
metric name instead of using the system default name.
Performance Manager
• An error may occur when you publish a goal or metric, or if you try to
activate a goal or metric manually or using in Strategy Builder.
Workaround:
1. Open your CMC.
2. Restart the AA Alert & Notification Server.
• If you create a bipolar goal based on a universe query with only one
upper tolerance that is designated as the first upper tolerance, this
tolerance is not displayed.
• If you are using SAP Netweaver, a script error occurs when you try to
create in Strategy Builder a new strategy or role, or publish a goal or
metric.
My Goals page
• Not all of the action hyperlinks work on the My Goals page.
• After migrating from 6.5 to BusinessObjects XI or XI R2, the publications
may not be visible in the My Goals tab and you may not be able to publish
a goal or metric to certain users.
Predictive Analysis
• You cannot use range limits with the binning variable.
• An error occurs when you try to refresh a new model-based metric based
on a set metric.
Workaround: You need to manually set the packed_result value in the
ci_param table. Insert the following into the ci_param table:
(param_id, param_type, item_name, item_value) values
(0, 1, 'packed_result size', [packed_result
value])
where [packed_result value] is the size of your set metric. The
internal server maximum is 30000 when packed_result size is not set.
• If the default value for the packed_result size in the ci_param table is not
compliant with your database configuration, the following error message
appears when you create a model-based metric:
(Load Model error error during the uudecode - size
problem )- 147
Process Analysis
• After you have migrated the Rules Engine, the formulas of new, long
rules vanish after a refresh.
chapter
10 Portal Integration Kit
SharePoint web parts
Viewing issues
• In the Microsoft Sharepoint portal, you may need to adjust the layout
options to view a report in the Document View web part:
• From the Modify Shared Web Part tool pane, expand the
Appearance section, and set the width and height for the display
area.
Use Pixels as the unit of measure.
Viewing issues
• The help files may not display correctly in the browser for some Asian
languages. The workaround is as follows:
• From the View menu, select Encoding, and then click “Unicode
(UTF-8)”.
Documentation
• For the latest version of the documentation, see “Product Documentation
on the Web” at the following site: http://support.businessobjects.com/
documentation/.
• The System Requirements section in the Portal Server installation guide
states that Microsoft Windows Server 2000 or 2003 is required; however,
the Microsoft Windows Server is not required when you install the Portal
Integration Kit on a UNIX system.
• For this release, the documentation is unavailable in Swedish or
Portuguese.
chapter
11 Semantic Layer
Designer
Designer
• The SQL syntax for Derived tables is not supported by Informix
databases.
• Although Oracle 8.x is not supported, it is available in the list of database
middleware in the Create a Connection wizard.
• You cannot create a connection with IBM DB2 if the IBM DB2 client is
installed after installing BusinessObjects.
Workaround: Install your IBMDB2 client before installing
BusinessObjects.
• The creation of universes from Metadata Exchange (File > Metadata
Exchange) is not supported on database schemas containing tables and
columns whose names contain special characters (such as: \ / @ * ,
space character).
• A universe object for which the property "can be used in result" is not
selected causes an error to occur when Web Intelligence queries
involving that object are run.
• You must install the BusinessObjects XI Release 2 Integration Kit for SAP
before you can create and use SAP OLAP universes.
• Sample universes and reports are installed in the
<INSTALLDIR>\Samples folder, where <INSTALLDIR> is the Business
Objects installation directory.
If you get a connection error when importing a sample universe to
Designer, or a "Universe can not be found" error message when
refreshing a sample report, refer to the online version of the release
notes for further information on how to solve this problem.
Connection Server
A Web Intelligence query can not be run when Connection Server is operating
in server mode.
chapter
12 Report Conversion Tool
Conversion
Conversion
• In Web Intelligence, the crosstab has horizontal and vertical lines
missing. This happens with crosstab that include functions such as
percentage.
• A cell with only wrap text and long text shrinks both in height and in width.
• After conversion, the Date format and Boolean format in a cell are
mapped to custom format, but not with a similar format.
• In the log file, entries for dangling references appear instead of missing
references.
• A custom sort on formula/Variable is not converted. In addition, internal
error occurs when view Result is selected.
• LastExecutionDate differs after migration.
• Custom sorts are not converted in MDP documents on merged
dimensions.
• Some formulas show a #DATATYPE error after migration.
• It is impossible to switch to page mode in the Java Query Panel when
Margin has been decreased in Desktop Intelligence.
• When a multi-tab REP file is converted to WID, it does not keep the
original selected tab.
• A cell containing a call to external functions is replaced by blank cells.
• Multiple Query Filters using prompt with same text and different operand
type.
• A query that has prompts with the same question (text) but a different
MONO or MULTI setting and a different response type among string,
numeric and date returns an error message.
• After conversion, 2D charts on refresh have axis lines missing.
• Measure values are not placed properly in scatter charts.
• Chart axes are displayed in Web Intelligence even though they are not
displayed in Desktop Intelligence.
• The number format for chart axis values is not converted in Web
Intelligence.
• A Publish Failed error occurs when you attempt to convert two
documents with same name in the Conversion Status window.
• The conversion status of REP documents converted to Web Intelligence
format by the Report Conversion Tool is not applied consistently.
• Migration of break properties, filter, ranking and 2cube documents may
be incorrect.
User interface
• Clicking the Close button in of the Report Conversion Tool caption bar
does not close the tool.
• The Start Conversion Button is not enabled when documents are
selected using the shortcut menu command “Select categories and
subcategories".
Log files
• Log files are not generated correctly in the French version.
• The "Focus" field in the log file for page setup and VBA macros is empty.
• The “Focus” field in the log file for conversion to WID format of REP files
containing the Fill option for columns is empty.
• The error message text in the log file for chart legends has the chart title
entry.
• When no audit connection has been defined for the Report Conversion
Tool, an irrelevant error message (MIGTOOL_UNKNOWN_ERROR)
appears in addition to the correct error message when you try to write to
the audit log.
Workaround: Before using the Report Conversion Tool, define an audit
connection for it using the Central Configuration Manager (CCM).
Documentation
The Report Conversion Tool Guide says that reports from which breaks have
been removed have converted status. In fact, they have partly converted
status.
chapter
13 Web Intelligence
Formula language
Formula language
Referencing data outside a section
Web Intelligence now references data outside the current section in a formula
that uses the In or ForAll operators.
Example: The In and ForAll Operators in a section
Here is a sample report based on the Insland Resorts Marketing universe,
with the values now returned by Web Intelligence.
France
ReportFilter() function
The documentation states that the ReportFilter() function returns all
report filters when passed an empty string as a parameter. In fact the function
returns an empty string in this case.
RunningSum() function
The RunningSum() function returns incorrect values when used with the
Block keyword as an input or output context.
International issues
The functions appear in English in the interface when the interface language
is Japanase, Korean, Chinese (Simplified) or Chinese (Traditional).
Security
If you do not have the rights to view a universe, you do not see it in the list of
universes, but you can open a report that is based on a universe to which you
do not have access in the Java Report Panel.
Limits
The Web Intelligence software itself does not impose limits on documents (for
example, there is no limit on the number of columns that a table can contain).
However, limits are imposed by the following factors:
• Parameters set in the Central Configuration Manager (for example, the
maximum size of a list of values).
• The software/hardware environment in which Web Intelligence runs.
The limitations of the software/hardware environment mean that restrictions
such as the maximum number of columns in a table, the maximum number of
tables in a report or the maximum number of prompts in a document vary
from case to case; Business Objects cannot provide precise figures.
Error messages
• The help file for error message WIS 00020 is not available. The text of
the help is as follows:
Message:
The SQL generated by the query is invalid.
Cause:
The syntax of the SQL of your query is not valid.
Action:
If you have edited the SQL manually, verify its syntax. If the SQL is
generated directly by Web Intelligence, make a copy of it and see your
BusinessObjects administrator.
• The help file for error message WIS 00022 is not available. The text of
the help is as follows:
Message:
Invalid identifier [identifier] at position [position].
Cause:
A formula contains an element that is not in the report.
Action:
Correct the formula.
• The help file for error message WIS 00024 is not available. The text of
the help is as follows:
Message:
Incompatible object data types in the subquery filter.
Cause:
The subquery attemps to compare objects of different data types (for
example a measure with a dimension.)
Action:
Edit the subquery to use compatible object types.
Change source
After you change the source of a report, hidden dimensions become visible.
International issues
When the traditional Chinese font MingLiU is used in charts in Web
Intelligence, the X-Axis label, Y-Axis label and legend title are not displayed
properly.
Workaround: Use the Arial Unicode font to display traditional Chinese text in
Web Intelligence charts.
1. Install the Arial Unicode font.
2. Stop the Web Intelligence Report Server
3. Modify the following entry in fontalias.xml, located in
<InstallDir>\BusinessObjects Enterprise 11.5\win32_x86\fonts.
<FONTATTRIBUTE BOLD=”false” ITALIC=”false”
LOGICAL=”MingLiU”
PHYSICAL=”mingliu.ttc,1:ARIALUNI.TTF” />
to
<FONTATTRIBUTE BOLD=”false” ITALIC=”false”
LOGICAL=”MingLiU” PHYSICAL=ARIALUNI.TTF” />
4. Start the Web Intelligence Report Server.
Drill
An error occurs when you attempt to run a query in HTML mode after drilling
out of scope then attempting to activate query drill mode.
Sometimes it is not possible to modify a table in Interactive HTML when
working in query drill mode.
Document linking
When a call to OpenDocument contains a invalid value for the sType
argument, Web Intelligence gives an HTTP 500 error.
Data providers
Web Intelligence throws an error when you click Undo after you run a
duplicated or newly-inserted data provider, then try to edit the data provider.
Custom sorts
When you merge dimensions on which custom sorts are defined, the custom
sorts are lost.