SAP BusinessObjects Xcelsius 2008 Fix Pack 3.4 Release Notes
■ Xcelsius 2008 FP 3.4
2010-12-03
Copyright
© 2010 SAP AG. All rights reserved.SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP
Business ByDesign, and other SAP products and services mentioned herein as well as their respective
logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business
Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web
Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the
United States and in other countries. Business Objects is an SAP company.All other product and
service names mentioned are the trademarks of their respective companies. Data contained in this
document serves informational purposes only. National product specifications may vary.These materials
are subject to change without notice. These materials are provided by SAP AG and its affiliated
companies ("SAP Group") for informational purposes only, without representation or warranty of any
kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The
only warranties for SAP Group products and services are those that are set forth in the express
warranty statements accompanying such products and services, if any. Nothing herein should be
construed as constituting an additional warranty.
2010-12-03
Contents
About these notes ..................................................................................................................5Chapter 1
About Release Numbering......................................................................................................7Chapter 2
Installation...............................................................................................................................9Chapter 3
3.1
3.2
3.3
3.4
3.5
3.6
4.1
4.2
4.3
4.4
5.1
5.2
5.3
5.4
5.5
Installation Requirements.........................................................................................................9
Error uninstalling Xcelsius 2008 with Fix Pack 1.1....................................................................9
Missing xcelsius.msi file...........................................................................................................9
Installation stops at registration of .dll files.............................................................................10
Installing Xcelsius 2008 on Windows 7...................................................................................10
Error installing Xcelsius 2008 SP3 Fix Pack 3.4......................................................................11
Known Issues in Xcelsius 2008 FP3.4..................................................................................13Chapter 4
Cross-domain deployment issue due to change in Adobe Flash Player 10 security.................13
Snapshot function..................................................................................................................13
Hierarchies with BICS connection..........................................................................................13
Unsupported Excel function: INDIRECT..................................................................................13
Known Issues in Xcelsius 2008 FP3.3..................................................................................15Chapter 5
Mandatory field in SAP ECC Web Services...........................................................................15
Exporting to PDF....................................................................................................................15
To enter or change the keycode on Windows 7......................................................................15
Accessing the Add-on manager or to add or remove an Add-on Manger in Windows 7..........15
Adobe Flash Player requirements...........................................................................................16
6.1
7.1
7.2
Known Issues in Xcelsius 2008 FP3.2..................................................................................17Chapter 6
Chart mouse-over values are truncated if you use one of four special characters (",', &,>)......17
Known Issues in Xcelsius 2008 FP3.1..................................................................................19Chapter 7
Opening files created in older versions of Xcelsius.................................................................19
Illegal characters in a worksheet name...................................................................................19
2010-12-033
Contents
7.3
7.4
7.5
7.6
7.7
7.8
7.9
8.1
8.2
8.3
8.4
8.5
8.5.1
8.5.2
8.5.3
8.6
8.6.1
8.6.2
8.6.3
8.6.4
8.6.5
8.6.6
8.7
8.7.1
8.8
8.8.1
8.8.2
8.8.3
8.8.4
Components with a Dynamic Visibility property state that is invalid .......................................19
Mouse pointer appears to stick in grid component.................................................................20
Globalization support.............................................................................................................20
Use Default Query Data without selecting Refresh Before Components Are Loaded ............20
Unnecessary rows and columns are ignored by a BICS web service .....................................20
Data not inserted if Dynamic Visibility property is hidden ......................................................20
COM exception when logging onto SAP after upgrading on Vista .........................................21
Known Issues in Xcelsius 2008 SP3.....................................................................................23Chapter 8
Launching Xcelsius 2008 - Error Message..............................................................................23
User Account Control and Manage Add-Ons ........................................................................23
Font size after upgrading to Xcelsius 2008.............................................................................23
Printing SWFs in PowerPoint..................................................................................................23
Export Issues.........................................................................................................................24
Export to HTML with long filename.........................................................................................24
Export to HTML model size difference between SWF file and HTML file................................24
Component size when exporting to PDF or PPT.....................................................................24
Components..........................................................................................................................25
Slide Show transition types....................................................................................................25
Flash memory management and the SWF Loader component ...............................................25
Multiple Slide Show components in HTML missing items ......................................................26
Interaction with components behind charts.............................................................................26
Selecting and Binding multiple components may result in multiple bindings for one property...26
Dynamic visibility behavior......................................................................................................27
Connectivity...........................................................................................................................27
BusinessObjects Xcelsius Enterprise 2008............................................................................27
Microsoft Excel......................................................................................................................28
Microsoft Excel stops responding..........................................................................................29
Microsoft Excel Functions......................................................................................................29
IFERROR Excel function not supported..................................................................................30
Optimize Spreadsheet option and "&" character.....................................................................31
2010-12-034
About these notes
About these notes
These release notes contain information about this release of SAP BusinessObjects Xcelsius 2008 Fix
Pack 3.4.
Read the entire document before installing your Business Objects software. After the release of the
software, any late breaking issues will be added to the
online at: http://help.sap.com/content/bobj/overview/index.htm.
Note:
To be sure you have the most up-to-date information, consult the online release notes.
SAP BusinessObjects Release Notes
available
2010-12-035
About these notes
2010-12-036
About Release Numbering
About Release Numbering
Xcelsius 2008 is the initial release of this product, and may be referred to unofficially as Xcelsius 2008
RTM.
Xcelsius 2008 SP3 is the third service pack (SP) release and contains a collection of updates, fixes,
enhancements and additional features. Service packs are considered major releases, and all affected
documentation is updated.
Xcelsius 2008 Fix Pack 3.4 is the fourth fix pack for SP3 and contains a collection of patches or bug
fixes, but does not contain any enhancements or additional features. Fix packs are considered minor
releases, and documentation updates are limited to
Release Notes
and
Fixed Issues
.
The fix pack numbering is structured as follows: [Service Pack Number].[Fix Pack Number]. For example,
if there were a third fix pack for a fourth service pack, it would be “Fix Pack 4.3”. Any future Service
Packs and Fix Packs will follow the above outlined numbering system. Fix packs should only be applied
to the service pack they pertain to.
Note:
Users can verify which release of Xcelsius 2008 they have installed from the Help menu, Help > About
Xcesius. The dialog box displays the "Xcelsius Version" number and the "Build Number". Previous
releases correspond to the following numbers:
Build NumberXcelsius VersionXcelsius Release
12,1,0,1215.0.0.99Xcelsius 2008 (RTM)
12,1,0,2475.0.0.99Xcelsius 2008 SP1
12,1,1,3445.1.1.0Xcelsius 2008 FixPack 1.1
12,2,0,6085.2.0.0Xcelsius 2008 SP2
12,2,1,665.2.1.0Xcelsius 2008 FixPack 2.1
12,3,0,6705.3.0.0Xcelsius 2008 SP3
12,3,1,7765.3.1.0Xcelsius 2008 FixPack 3.1
12,3,2,8645.3.2.0Xcelsius 2008 FixPack 3.2
12,3,3,9735.3.3.0Xcelsius 2008 FixPack 3.3
12,3,4,10385.3.4.0Xcelsius 2008 FixPack 3.4
Starting with the release of Fix Pack 1.1, the "Xcelsius Version" number will correspond to the Fix Pack
numbering structure noted above. The version number will be structured as follows: [Product
Version].[Service Pack Number].[Fix Pack Number].0.
2010-12-037
About Release Numbering
2010-12-038
Installation
Installation
3.1 Installation Requirements
Xcelsius 2008 requires the ability to write files to the registry and installation directory. If Xcelsius 2008
is unable to access and write the files, the installation will fail. Xcelsius 2008 requries the following
permissions for the specified operating systems:
RequirementOperating System
Current user must be an Administrator or have Administrator-level rightsWindows 7
Windows Vista
For a complete list of system requirements and supported platforms, see the
Xcelsius 2008 Supported Platforms
complete installation instructions, see the
available on the SAP Help Portal at http://help.sap.com.
• Current user must be an Administrator or have Administrator-level rights
• User Account Control must be disabled
Current user must be an Administrator or have Administrator-level rightsWindows XP
document available at http://www.sdn.sap.com/irj/boc/articles. For
SAP BusinessObjects Xcelsius 2008 Installation Guide
3.2 Error uninstalling Xcelsius 2008 with Fix Pack 1.1
If Fix Pack 1.1 has been applied, when attempting to uninstall SAP BusinessObjects Xcelsius 2008 to
install Service Pack 3, an error occurs.
Workaround: Uninstall Fix Pack 1.1 before uninstalling Xcelsius 2008.
SAP BusinessObjects
)
3.3 Missing xcelsius.msi file
2010-12-039
Installation
If you previously installed SAP BusinessObjects Xcelsius 2008 SP2 or SP1, before you install SAP
BusinessObjects Xcelsius 2008 SP3, you must uninstall the previous version. If you deleted the source
files for the SP1 or SP2 installation, when you attempt to uninstall Service Pack 3, an error occurs:
The file <filepath> is not a valid installation package for Xcelsius 2008.
Try to find the installation package Xcelsius.msi in a folder from which you
can install Xcelsius 2008.
The location for the xcelsius.msi file for Service Pack 3 is not accepted.
This error is due to a Microsoft known issue: Error 1706 "No Valid Source Could Be Found" When
Installing MSI File from Removable Media.
As a workaround, if possible, save a copy of the xcelsius.msi file from the previously installed version
in the location where the previous program source files were saved and then uninstall Xcelsius.
If you do not have access to the source files for the previously installed release, follow the steps to
resolve the issue on the Microsoft support site at http://support.microsoft.com/kb/299803.
Note:
If you have trouble uninstalling your previous version, the MS Installer Fix Utility might help. Download
it from http://download.microsoft.com/download/e/9/d/e9d80355-7ab4-45b8-80e8-
983a48d5e1bd/msicuu2.exe.
3.4 Installation stops at registration of .dll files
When installing SAP BusinessObjects Xcelsius 2008 SP3, any firewall or network security application
(e.g., McAfee, Norton) that blocks the connection to the remote installation source files prevents the
installer from removing the previously installed release and the installation stops at the registration of
the .dll files in the registry.
Workaround: Before installing SAP BusinessObjects Xcelsius 2008 SP3, do one of the following:
• Copy the Xcelsius source files to the local drive where you are installing the program.
• Disable any firewall or network security application (e.g., McAfee, Norton) that may block the access
to the remote source files.
3.5 Installing Xcelsius 2008 on Windows 7
To install Xcelsius 2008 SP3 successfully on Windows 7, you first need to manually install Microsoft
Visual C++ 2005 SP1 Redistributable Package. Microsoft Visual C++ 2005 SP1 Redistributable Package
is located on the installation CD, in a folder with the format: %\package\redist%.
2010-12-0310
Installation
3.6 Error installing Xcelsius 2008 SP3 Fix Pack 3.4
The following error may occur after installing Xcelsius 2008 SP3 Fix Pack 3.4:
"The program might not have installed correctly".
To solve this problem, reinstall the product using the "Reinstall using recommended settings" option.
2010-12-0311
Installation
2010-12-0312
Known Issues in Xcelsius 2008 FP3.4
Known Issues in Xcelsius 2008 FP3.4
4.1 Cross-domain deployment issue due to change in Adobe Flash Player 10 security
For Flash Player 10 (FP10) and FP (later than 1.0.115.0), there is new security policy that, if FP10 or
later than FP9 tries to request a customized cross-domain file (non-root location), a master cross-domain
file must be placed in the root location. (Flash Player could directly request the customized cross-domain
in earlier versions.)
For more information, refer to http://www.adobe.com/devnet/flashplayer/articles/fplayer9_security.html.
4.2 Snapshot function
In Xcelsius 2008 SP3 Fix pack 4, if a dashboard has an XML data connection, the Snapshot function
does not work.
4.3 Hierarchies with BICS connection
Xcelsius 2008 does not support hierarchies with a BICS connection in the current release.
4.4 Unsupported Excel function: INDIRECT
The INDIRECT function is not supported in Xcelsius X5.
2010-12-0313
Known Issues in Xcelsius 2008 FP3.4
2010-12-0314
Known Issues in Xcelsius 2008 FP3.3
Known Issues in Xcelsius 2008 FP3.3
5.1 Mandatory field in SAP ECC Web Services
It is a known issue that the SAP Enterprise Resource Planning Central Component Web Services
require the mandatory field "soapAction" to be included in the soap header. If the attribute "soapAction"
is missing, manually add the attribute with an empty string such as: "soapAction=".
5.2 Exporting to PDF
In Xcelsius 2008, the default format for exporting to PDF is "Acrobat 9.0 (PDF 1.8)". If Acrobat Reader
8.0 is installed, the default exported PDF cannot be opened. If using Acrobat Reader 8.0 or older,
change the format to "Acrobat 6.0 (PDF 1.5)" before exporting to PDF.
5.3 To enter or change the keycode on Windows 7
To enter or change the keycode on Windows 7 you need to run Xcelsius as an administrator.
To run Xcelsius as an administrator:
• Right-click START > Programs > Xcelsius 2008, and select Run as Administrator.
5.4 Accessing the Add-on manager or to add or remove an Add-on Manger in
Windows 7
To access the Add-on manager or to add or remove an Add-on Manager in Windows 7, you must run
Xcelsius as an administrator, or an error will occur.
To run Xcelsius as an administrator:
2010-12-0315
Known Issues in Xcelsius 2008 FP3.3
• Right-click START > Programs > Xcelsius 2008, and select Run as Administrator.
Note:
Note: If you do not perform both of these steps, Xcelsius may crash while accessing the Add-on Manager,
or may freeze while adding or removing an add-on.
5.5 Adobe Flash Player requirements
Adobe Flash Player 10.1.53 does not allow exported PowerPoint or Word files to play inside embedded
.swf files. To fix this issue, upgrade the Adobe Flash Player to 10.1.82.76 or higher.
2010-12-0316
Known Issues in Xcelsius 2008 FP3.2
Known Issues in Xcelsius 2008 FP3.2
6.1 Chart mouse-over values are truncated if you use one of four special characters
(",', &,>).
Chart mouse-over values are truncated if you use one of these four special characters ", ', &, >.
2010-12-0317
Known Issues in Xcelsius 2008 FP3.2
2010-12-0318
Known Issues in Xcelsius 2008 FP3.1
Known Issues in Xcelsius 2008 FP3.1
7.1 Opening files created in older versions of Xcelsius
When you open a file created in Xcelsius SP3 or any earlier version, a warning message appears:
"Xcelsius has detected the file you just opened has been created with an older version of Xcelsius.
Some model features may not function and the layout may differ. If you overwrite this file, you will not
be able to open it with a previous version of Xcelsius."
Save the file only if you do not want to open it again in a previous version of Xcelsius.
7.2 Illegal characters in a worksheet name
If the worksheet that you use in Xcelsius contains illegal characters in its name, the resulting dashboard
SWF might not be generated according to the design. This behavior is a known limitation.
A worksheet name must not start with a space. When the "Optimize Spreadsheet" option (found under
Preferences) is enabled, the worksheet name must not start with a < character, and it must not end
with a space.
7.3 Components with a Dynamic Visibility property state that is invalid
When dealing with components in which the state of the Dynamic Visibility property is invalid, SP3 has
a different behavior from previous releases.
To be considered valid, the Dynamic Visibility property must have a non-null value for both the Status
and Key fields. For dashboard models created in all previous releases, including any upgrade scenarios,
SP3 treats the component with the invalid state of Dynamic Visibility as hidden. For dashboard models
created in SP3, SP3 treats the component with an invalid state of Dynamic Visibility as visible.
2010-12-0319
Known Issues in Xcelsius 2008 FP3.1
7.4 Mouse pointer appears to stick in grid component
It is a known issue that the mouse pointer may appear to stick due to the use of a grid component in
the dashboard. To resolve this issue, reduce the number and complexity of the grid components in the
dashboard or use alternative components, if possible.
7.5 Globalization support
For SAP NetWeaver BW integration, some simple globalization is supported. The thousands and decimal
separators, days of the week, and months of the year follow the SAP SU3 settings.
• For dates, use a custom non-locale specific format of: d mmm yyyy
• For times, use a custom non-locale specific 24-hour clock format (without the AM/PM): hh:mm
7.6 Use Default Query Data without selecting Refresh Before Components Are Loaded
In this version of Xcelsius (FP3.1), you can select Use Default Query Data without having to check
Refresh Before Components Are Loaded. You can now use a Connection Refresh Button to
Refresh After Components Are Loaded but still select Use Default Query Data.
7.7 Unnecessary rows and columns are ignored by a BICS web service
When calling a BICS web service, if your query returns more rows and columns than are bound to the
spreadsheet in Xcelsius, the unnecessary rows and columns are now ignored.
7.8 Data not inserted if Dynamic Visibility property is hidden
When using the Dynamic Visibility property, a component will not insert data when the property is hidden.
2010-12-0320
Known Issues in Xcelsius 2008 FP3.1
7.9 COM exception when logging onto SAP after upgrading on Vista
After upgrading to Xcelsius 2008 FP3.1 on the Microsoft Vista platform, a COM Exception appears
during the SAP system logon process when you use the SAP NetWeaver BW Connection, or when you
select SAP > Open > Publish > Publish As from the menu in Xcelsius.
To resolve this issue, remove crypt32.dll and winhttp.dll from %Xcelsius_in
stalled_root%\Xcelsius\, for example "C:\Program Files\Business Objects\Xcel
sius\".
2010-12-0321
Known Issues in Xcelsius 2008 FP3.1
2010-12-0322
Known Issues in Xcelsius 2008 SP3
Known Issues in Xcelsius 2008 SP3
8.1 Launching Xcelsius 2008 - Error Message
If the Microsoft Windows temporary folder %temp% (For example, for Administrator, C:\Documents
and Settings\Administrator\Local Settings\Temp) does not exist, when launching SAP
BusinessObjects Xcelsius 2008, an error occurs:
"Microsoft Visual C++ Runtime Library" "RuntimeError! ..."
The workaround is to ensure that the Windows temporary folder exists in the default location before
launching Xcelsius.
8.2 User Account Control and Manage Add-Ons
If User Account Control (UAC) is enabled, the Manage Add-Ons menu item is not available in Xcelsius.
As a workaround, turn UAC off if you want to manage add-ons.
8.3 Font size after upgrading to Xcelsius 2008
After upgrading to SAP BusinessObjects Xclesius 2008 from Xcelsius 4.5, fonts appear visually
smaller in SWF files although, in the "Properties" panel, the font size is the same as it was in the earlier
version.
As a workaround, adjust the font sizes for models designed in Xcelsius 4.5 and upgraded to Xcelsius
2008 to accommodate the size difference.
8.4 Printing SWFs in PowerPoint
2010-12-0323
Known Issues in Xcelsius 2008 SP3
When users open Microsoft PowerPoint files that contain SWFs and print the slides before running the
Slide show, the printed slides are blank.
To print SWFs in PowerPoint, start Slide Show mode and open each slide before printing the file.
8.5 Export Issues
8.5.1 Export to HTML with long filename
If a model is exported to HTML and given a filename with more than 59 wide characters (UNICODE
filename), the exported HTML file cannot load the SWF file. In the exported HTML file, the SWF filename
is truncated after 59 wide characters.
As a workaround, use a filename that is 59 wide characters or less or manually modify the HTML file
to include the actual filename in <EMBED src="">.
8.5.2 Export to HTML model size difference between SWF file and HTML file
After exporting to HTML format, the size of the model in the HTML output is larger than it is in the SWF
output.
To change the size of the model in an HTML file, in your browser, view the source for the file and, in
the OBJECT tag, adjust the Height and Width settings.
Note:
In Firefox, to reduce the model size, you must also change the Height and Width settings in the EMBED
tag.
8.5.3 Component size when exporting to PDF or PPT
After exporting to Adobe PDF or Microsoft PowerPoint (PPT) format, the sizes of some components
are different than they were in the XLF and in the Preview, and they may not be aligned as they were
in design mode.
2010-12-0324
Known Issues in Xcelsius 2008 SP3
This behavior is caused by an Adobe Flash Player known issue. For more information, see the Adobe
Flash Player Bug and Issue Management system at http://bugs.adobe.com/jira/browse/FP-1090.
8.6 Components
8.6.1 Slide Show transition types
Slide Show transitions do not work as intended in design-mode and/or at run-time.
The following transition types work correctly during design-mode:
• Cover Left
• Cover Right
• Push Left
• Push Right
• Zoom
At run-time, only the Fade Smoothy transition type works as intended. The following transition types
have different behavior than intended:
Transition Behavior at run-timeTransition Selected
Push RightPush Left
Push LeftPush Right
Push UpUncover Left Up
8.6.2 Flash memory management and the SWF Loader component
The new web connectivity component, SWF Loader, is designed to load SWF files at run-time with
better memory management than the Slide Show component. However, it is still subject to the Adobe
Flash Player memory management method, which controls when inactive components are removed
from memory.
To avoid heavy memory consumption when using the SWF Loader:
• Reduce the number of SWF Loader and Slide Show components included in a single model
2010-12-0325
Known Issues in Xcelsius 2008 SP3
• Reduce the number of SWF files that the SWF Loader and Slide Show components in the model
must load concurrently at run-time.
8.6.3 Multiple Slide Show components in HTML missing items
If a model includes two or more Slide Show components, when the model is exported to HTML, one of
the Slide Show components may be missing some items in the child SWF.
If a model is missing items from a Slide Show, recreate the model using the SWF Loader component
instead of the Slide Show component.
8.6.4 Interaction with components behind charts
In Crystal Xcelsius 4.5, when a Chart was placed over top of another component that had interaction
enabled, users could still interact with the component behind the chart. In SAP BusinessObjects Xcelsius
2008, when a chart covers another component, users cannot interact with the covered component by
default.
To allow users to interact with components behind a chart:
1.
Select the Chart component and open the "Properties" panel.
2.
Click the Appearance view and on the Layout tab, set the following options:
• Under "Chart Area", deselect the Show Chart Background option.
• Under "Plot Area", deselect the Show Fill option.
8.6.5 Selecting and Binding multiple components may result in multiple bindings
for one property
When you select multiple components and bind a property to a value, if the component selected first
does not have a binding for the property and the component selected second did,then the second
component will have two bindings for that property value. Since a single property cannot be bound to
multiple values, the property sheet for the second component will display the existing value rather than
the new value. To change the binding value, you must first delete the existing binding and then bind
the property to the new value.
2010-12-0326
Known Issues in Xcelsius 2008 SP3
8.6.6 Dynamic visibility behavior
In Xcelsius 2008 SP3, for a component to be hidden using "Dynamic Visibility" when the model runs,
a valid value must be specified in both the Status box and in the Key box for dynamic visibility. If a
Status value is specified and the Key value is not, the component remains visible in the model.
In Xcelsius 2008 SP2, components were hidden whenever a value was specified in the Status box,
regardless of whether the Key value was set.
Workaround: If a value is entered in the Status box for dynamic visibility, ensure a Key value is also
set.
1.
Select the component and open the "Properties" panel.
2.
In the "Properties" panel, click Behavior > Common.
3.
Under "Dynamic Visibility", if a value is set in the Status box, set an appropriate value in the Key
box.
Note:
If the component is not required for the model, remove it to reduce the file size of the SWF file and
improve overall performance.
8.7 Connectivity
8.7.1 BusinessObjects Xcelsius Enterprise 2008
8.7.1.1 Live Office
8.7.1.1.1 Live Office Compatibility Mode Open from BusinessObjects Enterprise
Even if "Live Office Compatibility Mode" is enabled, the Live Office application does not provide the full
functionality from within Xcelsius 2008 as is provided from within Microsoft Office applications. For
2010-12-0327
Known Issues in Xcelsius 2008 SP3
example, you cannot open Microsoft Excel spreadsheets that are saved in InfoView. Other unavailable
functionality includes publishing spreadsheets to BusinessObjects Enterprise and refresh options.
To workaround this issue, use the Live Office functionality in Microsoft Excel and then import the Live
Office-enabled spreadsheet into Xcelsius.
8.7.1.1.2 Live Office-enabled Spreadsheets decrease performance
If a model includes a Live Office-enabled spreadsheet, performance when generating SWF files
decreases by about 10%. Performance is reduced even if the Live Office connection is disabled.
8.7.1.2 Viewing Parent SWF Hosted in BusinessObjects Enterprise InfoView with
Local Child content
Problem: Exporting a SWF (parent) to BusinessObjects Enterprise that has local content (e.g. a child
swf, or image) stored on a local PC. The parent SWF can be viewed in InfoView but it cannot load the
child content.
Workaround: There is no workaround for this. This is an Adobe security restriction. The Adobe Flash
Player 9 does not allow a SWF hosted on a URL (For example, BusinessObjects Enterprise InfoView
or a website) to load a file that is stored on a local file system. Parent SWF files hosted in
BusinessObjects Enterprise InfoView must have child content that is also hosted in BusinessObjects
Enterprise InfoView.
For more information, see the
website at http://www.adobe.com/devnet/flashplayer/articles/fplayer9_security.html
Security Changes in Flash Player 9
8.7.1.3 Portal data connection checkbox behavior
If a Portal Data Connection is added to a model for an IBM WebSphere connection with Connection
Type set to None and Parameter Type set to CheckBox, when users select the checkbox on the IBM
Websphere Portal, the insert value is -1. When the checkbox is not selected the insert value is null.
8.8 Microsoft Excel
document available on the Adobe
2010-12-0328
Known Issues in Xcelsius 2008 SP3
8.8.1 Microsoft Excel stops responding
If both Xcelsius and Microsoft Excel are used simultaneously on the same system, Microsoft Excel may
stop responding.
To minimize the possibility for this issue to occur, do the following:
• Ensure that all Microsoft Excel updates are installed.
• When working with both Xcelsius and Excel at the same time, always start Xcelsius first and then
start Excel.
8.8.2 Microsoft Excel Functions
Array Formulas (entered using Ctrl + Shift + Enter)
Issue: Xcelsius 2008 does not support Microsoft Excel array formulas.
Condition: Formula is an array formula, entered using Ctrl + Shift + Enter, enclosed
between braces {} e.g. ={SUM(B2:D2*B3:D3)}.
Behavior: Incorrect calculation is returned by Xcelsius 2008.
DATEVALUE(date_text)
Issue: Xcelsius 2008 does not support Microsoft Excel's internal text-based date format.
Condition: Date_text is entered in non-numeric format, e.g. January 1, 2008.
Behavior: Xcelsius 2008 will return #VALUE!. Excel will return its internal date value.
Functions with “optional” parameters
For Excel functions that have parameters which are optional, or have values that can be
omitted, it is recommended to provide values for these parameters. Omitting values for
optional parameters may prevent your visualization from rendering.
INDEX(array, row_num, column_num)
Issue: Xcelsius 2008 calculates INDEX as a value, not a cell reference. Therefore, it cannot
be combined with other functions that use cell references.
Condition: Other functions combined with INDEX requiring a cell reference, i.e.
SUM(A1:INDEX(…)).
Behavior: Xcelsius 2008 calculates a value, creating an error for other functions that use
cell references.
IRR(values, guess)
Issue: Xcelsius 2008 returns incorrect calculation if the guess value is negative.
2010-12-0329
Known Issues in Xcelsius 2008 SP3
Condition: Guess value is negative.
Behavior: Xcelsius 2008 returns blank. Excel returns a valid IRR value.
SUMIF(range, criteria, sum_range)
Issue: Xcelsius 2008 does not calculate an expanded sum_range if range cell selection is
larger than sum_range cell selection.
Condition: Range cell selection is larger than sum_range cell selection.
Behavior: Xcelsius 2008 only calculates cells selected in the sum_range; Excel calculates
an expanded sum_range based on the larger cell selection of range.
SUMPRODUCT((Condition1)*(The range to sum))
Issue: Xcelsius 2008 does not support the use of SUMPRODUCT ((Condition1)*(The range
to sum)).
Condition: ((Condition1)*(The range to sum)) is not supported.
Behaviour: The function returns #VALUE when run. Xcelsius 2008 only supports the use
of SUMPRODUCT(Range1,Range2, ...).
SUMXMY2, SUMX2MY2, and SUMX2PY2 functions
Issue: When SUMXMY2, SUMX2MY2, or SUMX2PY2 functions are set to an error message
such as #Value!, in run-time, Xcelsius 2008 returns the value NaN instead of #Value!.
TEXT(value, format_text)
Issue: Xcelsius 2008 doesn't support formatting Excel internal numbering scheme into
year.
Condition: Value is between Excel's minimum and maximum year (in number form); for
mat_text value is e.
Behavior: The formula =TEXT(1,“e”) Xcelsius 2008 returns e; Excel returns value 1900.
VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) and
HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)
Issue: Microsoft Excel and Xcelsius 2008 produce different calculation results on duplicated
lookup_value in table_array. Microsoft has reported a known issue with these functions.
Conditions:
- Range_lookup value is omitted or set to TRUE.
- Lookup_value in table_array is duplicated (two or more times).
- The values in the first column oftable_array are sorted in ascending order.
Behavior: Xcelsius 2008 will return the value from the FIRST row/column found in the ta
ble_array; Excel will return the value from the LAST row/column in the table_array.
8.8.3 IFERROR Excel function not supported
2010-12-0330
Known Issues in Xcelsius 2008 SP3
In the SAP BusinessObjects Xcelsius 2008 User Guide and online help, IFERROR is mistakenly listed
as a supported Excel function. The IFERROR function is not supported in Xcelsius 2008.
8.8.4 Optimize Spreadsheet option and "&" character
If a worksheet in the embedded spreadsheet has a name that contains the “&” character and, on the
Excel Options dialog box, the Optimize Spreadsheet option is enabled, components with data binding
to that worksheet may not display the data properly during preview and runtime.
Workaround: Disable the Optimize Spreadsheet option.
1.
Click File > Preferences > Excel Options .
2.
Under "Optimize Spreadsheet", deselect Enable.
3.
Click OK.
2010-12-0331
Known Issues in Xcelsius 2008 SP3
2010-12-0332
Loading...