Data Federator Release Notes
BusinessObjects Data Federator XI Release 2
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
Copyright
Third-party
contributors
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.
DB2 is a registered trademark of IBM Corporation in the United States and other countries.
Java, Sun, and other names of Sun Microsystems products are trademarks or registered
trademark of Sun Microsystems, Inc. in the United States and other countries.
Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.
Microsoft, Windows, Windows NT, Access, Excel, SQL Server, and other names of Microsoft
products referenced herein are either registered trademarks or trademarks of Microsoft
Corporation in the United States and/or other countries.
MySQL is a registered trademark of MySQL AB in the United States, the European Union and
other countries.
Oracle is a registered trademark of Oracle Corporation. All other names of Oracle products
referenced herein are trademarks or registered trademarks of Oracle Corporation.
UNIX is a registered trademark of The Open Group.
All other product and company names mentioned herein are the trademarks of their
respective owners.
Copyright © 2006 Business Objects. All rights reserved.
Business Objects products in this release may contain redistributions of software licensed
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
Data Federator Release Notes
Introduction
chapter
Introduction
1
About this guide
About this guide
This document contains important information about known issues with this
release.
You should read this entire document before installing Data Federator.
Business Objects information resources
For more information and assistance, see Appendix A: Business Objects
Information Resources. This appendix describes the Business Objects
documentation, customer support, training, and consulting services, with links
to online resources.
4 Data Federator Release Notes
Data Federator Release Notes
Known issues and limitations
chapter
Known issues and limitations
2
Known issues
Known issues
BusinessObjects Data Federator XI Release 2
783
Warning icon on incorrect type for function arguments is not automatically
removed when you correct the type.
Workaround: add a meaningless space in the formula, and click Save.
1193
Data Federator does not push expressions to the database management
system when the expression is an argument of a function that is not pushed.
This could lead to different computed values when the same expression is
both pushed and not pushed in the same query.
Query examples:
select (D0-3.15), abs(D0-3.15) from /wrappers/jdbc/
mysql_push_test/TEST_TYPES
select ((D0-3.15) = abs(D0-3.15)) from /wrappers/jdbc/
mysql_push_test/TEST_TYPES
In both examples, the function abs() is calculated by Data Federator.
Therefore, the first expression
management system, while the second expression
calculated by Data Federator. If the database management system uses a
different algorithm than Data Federator, then two expressions could have a
different result.
(D0-3.15) is calculated by the database
abs(D0-3.15) is
1344
Using browser navigation buttons results in unexpected behavior.
You should not use the browser back and refresh buttons to navigate through
the interface.
1392
When clicking on a disabled/inactive element in the treeview, the previouslyselected element looses the focus.
1673
The minus sign “-” without surrounding spaces is not supported inside
formulas.
6 Data Federator Release Notes
1723
1754
1784
1798
Known issues and limitations
Known issues
You must place a space before and after the minus sign in formulas.
In some cases, on Windows Server 2003 when clicking on Select all in the
Query tool pane, a runtime javascript error occurs.
In these cases, add the columns one by one.
When adding two case statement rules at the same time and all of them are
incorrect, when you try to edit one of the incorrect rules, the other rule may be
displayed.
When using a comma-separated value (CSV) file as a datasource, if the file
has a column that contains the character "\n", but lines in your file are
separated by "\n\r", Data Federator will split the line in the wrong place.
The "\tab" sequence (backslash, literally followed by the string "tab") in the
separator of a text file is interpreted by Data Federator as the tab character.
Therefore, files containing this exact character sequence as a separator are
not supported.
2
1852
1856
Currently, Data Federator Designer is opened with a URL which is created by
the installer.
Windows opens the URL with the default internet browser which might be
something else than Internet Explorer.
Data Federator Designer does not work with anything else than Internet
Explorer, so the URL shortcut is not useful if the default browser is not
Internet Explorer.
You cannot add domain and lookup rows from an imported text file if Data
Federator Query Server and Data Federator Designer are on different
machines.
WORKAROUNDS:
• Populate the lookup or domain table by hand.
Data Federator Release Notes 7
Known issues and limitations
2
Known limitations
1859
1864
1896
• Copy the uploaded file to the Data Federator Query Server machine by
hand to a specific location (this does not work if Data Federator Query
Server and Data Federator Designer are on different operating systems).
In the Datasheet frame, the vertical scrollbar cannot be seen if there are a lot
of columns.
WORKAROUND: use the mouse scroll wheel to scroll.
Mapping rules are not ordered in the treeview. The order might change when
Data Federator Query Server is restarted.
When accessing an MS Access database, where the MS Access database
and Data Federator Query Server are in different machines, while trying to
connect from Data Federator to the Access database, the following
connection error appears.
"Connection to 'jdbc:odbc:MSAccess_DSN' failed: '(unknown)' is not a valid
path. Make sure that the path name is spelled correctly and that you are
connected to the server on which the file resides."
WORKAROUND: Stop the DataFederator.QueryServer service (in Control
Panel > Administrative Tools > Services. Then, start the the
DataFederator.QueryServer service using the following commands in a DOS
window:
cd C:\Program Files\DataFederator\LeSelect\
bin\startup.bat
The connection to the MS Access database succeeds.
Known limitations
BusinessObjects Data Federator XI Release 2
1507
The functions CONVERT and CAST are available in the Data Federator
Administrator but not in Data Federator Designer. In Data Federator
Designer, the “convert” functions such as toTimestamp() or toInteger() can be
used instead.
8 Data Federator Release Notes
1607
1753
Known issues and limitations
Known limitations
A predicate that uses a function that returns a boolean can be defined as
follows:
1. match(S20.HomePhone,'0[0-68].*' = true
which is equivalent to:
2. match(S20.HomePhone,'0[0-68].*'
Format 2 is not accepted in Data Federator Designer while it is accepted in
Data Federator Administrator. Use format 1 in Data Federator Designer.
When you delete a case in a case statement, the corresponding case
disappears, but it is removed only when you click Save.
You must click the delete icon, then click Save to delete a case from a case
statement.
2
Data Federator Release Notes 9
Known issues and limitations
2
Known limitations
10 Data Federator Release Notes
Business Objects Information Resources
appendix
Business Objects Information Resources
A
Documentation and information services
Documentation and information services
Business Objects offers a full documentation set covering its products and
their deployment. Additional support and services are also available to help
maximize the return on your business intelligence investment. The following
sections detail where to get Business Objects documentation and how to use
the resources at Business Objects to meet your needs for technical support,
education, and consulting.
Documentation
You can find answers to your questions on how to install, configure, deploy,
and use Business Objects products from the documentation.
What’s in the documentation set?
View or download the Business Objects Documentation Roadmap, available
with the product documentation at http://www.businessobjects.com/support/.
The Documentation Roadmap references all Business Objects guides and
lets you see at a glance what information is available, from where, and in
what format.
Where is the documentation?
You can access electronic documentation at any time from the product
interface, the web, or from your product CD.
Documentation from the products
Guides in Adobe PDF format are available in the product installation
directories.
Documentation on the web
The full electronic documentation set is available to customers on the web
from support web site at: http://www.businessobjects.com/support/.
Documentation on the product CD
Look in the docs directory of your product CD for versions of guides in Adobe
PDF format.
12 Data Federator Release Notes
Business Objects Information Resources
Customer support, consulting and training
Send us your feedback
Do you have a suggestion on how we can improve our documentation? Is
there something you particularly like or have found useful? Drop us a line,
and we will do our best to ensure that your suggestion is included in the next
release of our documentation: documentation@businessobjects.com.
Note: If your issue concerns a Business Objects product and not the
documentation, please contact our Customer Support experts. For
information about Customer Support visit: http://www.businessobjects.com/
support/.
Customer support, consulting and training
A global network of Business Objects technology experts provides customer
support, education, and consulting to ensure maximum business intelligence
benefit to your business.
How can we support you?
Business Objects offers customer support plans to best suit the size and
requirements of your deployment. We operate customer support centers in
the following countries:
• USA
• Australia
• Canada
• United Kingdom
• Japan
A
Online Customer Support
The Business Objects Customer Support web site contains information about
Customer Support programs and services. It also has links to a wide range of
technical information including knowledgebase articles, downloads, and
support forums.
http://www.businessobjects.com/support/
Data Federator Release Notes 13
Business Objects Information Resources
A
Customer support, consulting and training
Looking for the best deployment solution for your company?
Business Objects consultants can accompany you from the initial analysis
stage to the delivery of your deployment project. Expertise is available in
relational and multidimensional databases, in connectivities, database design
tools, customized embedding technology, and more.
For more information, contact your local sales office, or contact us at:
http://www.businessobjects.com/services/consulting/
Looking for training options?
From traditional classroom learning to targeted e-learning seminars, we can
offer a training package to suit your learning needs and preferred learning
style. Find more information on the Business Objects Education web site:
http://www.businessobjects.com/services/training
14 Data Federator Release Notes
Useful addresses at a glance
Address Content
Business Objects product
information
http://www.businessobjects.com
Product documentation
http://www.businessobjects.com/
support
Business Objects Documentation
mailbox
documentation@businessobjects.com
Online Customer Support
http://www.businessobjects.com/
support/
Business Objects Consulting
Services
http://www.businessobjects.com/
services/consulting/
Business Objects Education
Services
http://www.businessobjects.com/
services/training
Business Objects Information Resources
Useful addresses at a glance
Information about the full range of
Business Objects products.
Business Objects product
documentation, including the
Business Objects Documentation
Roadmap.
Send us feedback or questions
about documentation.
Information on Customer Support
programs, as well as links to
technical articles, downloads, and
online forums.
Information on how Business
Objects can help maximize your
business intelligence investment.
Information on Business Objects
training options and modules.
A
Data Federator Release Notes 15
Business Objects Information Resources
A
Useful addresses at a glance
16 Data Federator Release Notes
Loading...