BusinessObjects Extended Analytics
Release Note
BusinessObjects Extended Analytics 7.0
Copyright
© 2008 Business Objects. All rights reserved. Business Objects owns the following
U.S. patents, which may cover products that are offered and licensed by Business
Objects: 5,295,243; 5,339,390; 5,555,403; 5,590,250; 5,619,632; 5,632,009;
5,857,205; 5,880,742; 5,883,635; 6,085,202; 6,108,698; 6,247,008; 6,289,352;
6,300,957; 6,377,259; 6,490,593; 6,578,027; 6,581,068; 6,628,312; 6,654,761;
6,768,986; 6,772,409; 6,831,668; 6,882,998; 6,892,189; 6,901,555; 7,089,238;
7,107,266; 7,139,766; 7,178,099; 7,181,435; 7,181,440; 7,194,465; 7,222,130;
7,299,419; 7,320,122 and 7,356,779. Business Objects and the Business Objects
logo, BusinessObjects, Business Objects Crystal Vision, Business Process On
Demand, BusinessQuery, Cartesis, Crystal Analysis, Crystal Applications, Crystal
Decisions, Crystal Enterprise, Crystal Insider, Crystal Reports, Crystal Vision,
Desktop Intelligence, Inxight, the Inxight Logo, LinguistX, Star Tree, Table Lens,
ThingFinder, Timewall, Let There Be Light, Metify, NSite, Rapid Marts, RapidMarts,
the Spectrum Design, Web Intelligence, Workmail and Xcelsius are trademarks or
registered trademarks in the United States and/or other countries of Business
Objects and/or affiliated companies. Business Objects is an SAP company. SAP
is the trademark or registered trademark of SAP AG in Germany and in several
other countries. All other names mentioned herein may be trademarks of their
respective owners.
Third-party
Contributors
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
2008-07-04
Contents
What's new 5Chapter 1
New features................................................................................................6
Technical changes.....................................................................................11
Known issues 13Chapter 2
Known issues in Designer.........................................................................14
Known issues in Analyzer..........................................................................15
New features in Designer.......................................................................6
New features in Analyzer.......................................................................8
Platforms..............................................................................................11
Analyzer language in standalone mode...............................................11
Analyzer General Options in standalone mode....................................12
Vista supported....................................................................................12
Rights to use Designer.........................................................................14
Reporting Category dimension not compatible with star schemas......14
Data source for fact table.....................................................................14
Custom fact tables not deployed in custom measures.........................14
Dynamic reports generated with a 3.5 cube.........................................15
Opening a 4.1 report in Excel 2007......................................................15
Fixed issues 17Chapter 3
Fixed issues in Designer............................................................................18
Importing solution with two hierarchies................................................18
Calculated member freezing the application........................................18
Star schema deployment failed because of the Period format.............18
Excluded consolidation dimensions: cube deployment failed..............18
BusinessObjects Extended Analytics Release Note 3
Contents
All detailed included the NA member...................................................18
Solution import with renamed hierarchies............................................19
Empty named set.................................................................................19
All default member for named level hierarchy......................................19
Characteristic value not selected and in the cube................................19
Hierarchy name after export.................................................................19
Import with custom calculated member................................................19
Custom fact tables caused deployment failure....................................20
Deploying a star schema on version 4.1 on a user defined dimension.20
Fixed issues in Analyzer............................................................................20
Losing the shift on the column header after an Eliminate Member......20
Warning message on sorting................................................................20
Asymmetry lost on a page header move..............................................21
Technical fixed issues................................................................................21
64 bits Itanium platform........................................................................21
Patch system........................................................................................21
Get More Help 23Appendix A
4 BusinessObjects Extended Analytics Release Note
What's new
1
What's new
1
New features
New features
New features in Designer
Importing and exporting solutions using the File menu
You can now export and import solutions directly from the Designer interface.
Auditing and deleting deployments
You can now display the list of all the deployments performed in all Designer
solutions linked to the current Financial Consolidation data source. From this
list, you can delete deployments' information from the Financial Consolidation
database tables that are no longer used.
Parent Child hierarchies and data members
Data members can be automatically created on the Parent Child hierarchies
of some dimensions. The data members are created automatically by default;
however, you can now choose not to create them.
Processing only parts of a cube
You can now choose to re-process only parts of the cube, meaning the
packages or consolidations (depending on the data level of the view).
Activating the creation of star schema deployments
When creating a deployment, by default you can now only create a cube
deployment. To create a star schema deployment, you must now activate a
key in the configuration file.
6 BusinessObjects Extended Analytics Release Note
What's new
New features
Limiting the number of members displayed for a merged dimension
By default, 5 000 members can be displayed for a merged dimension. In the
previous version, you had to change the default number in the configuration
file. You can now change the default number in the "Options" dialog box.
Creating the Reporting Category dimension and its members
The Reporting Category dimension (merges the Data Entry Period dimension
and the Category dimension) is not available by default. You can create it.
Sorting hierarchies
You can now perform sorting on each type of hierarchy. You can sort by
code, internal identifier or attribute.
1
Naming the members of a merged dimension
You can now name the members of a merged dimension by grouping together
the deployment names of the dimensions that make up the merged
dimension.
For Manual naming of merged dimension members, you can also copy and
paste the cells from Designer to Excel or from Excel to Designer, using the
copy and paste new buttons.
Extra-long descriptions
The extra-long descriptions of the Financial Consolidation database can now
be used in Designer.
BusinessObjects Extended Analytics Release Note 7
What's new
1
New features
Translating calculated members and named sets
You can now translate in all available languages the names of calculated
members and named sets.
Year prefix or suffix on Period and Data Entry period dimensions
For the hierarchies of the Period or Data Entry Period dimensions, you can
choose to add a year prefix or suffix to the quarters or semesters.
New features in Analyzer
Including named sets in a report
Named sets that have been created in Designer can now be included in
reports, using the "Report Manager" dialog box.
Displaying cubes and sheets in the Connection Manager
In the "Connection Manager" dialog box, you can now choose the way you
want to display the sheet/connection couples by clicking the Display by Sheet
or Display by Connection button.
Getting information on a cube
You can now display information on a cube, using the "Connection Manager"
dialog box.
Autofill function
In free mode, the standard autofill function enables you to automatically fill
in cells with all the members of the same level.
8 BusinessObjects Extended Analytics Release Note
Free report creation
In free mode, when you enter the exact names of the members you want to
retrieve, and press the Enter key, a green flash briefly appears in the cell,
indicating that the member has been recognized.
Totals placement
You can now choose to display totals to the left / right on an across axis.
Consequently, the option Default Totals to the Top has been renamed Default
Totals to the Top on Row Axis.
You can choose the totals placement:
• for all sheets, the "General Options" dialog box now displays the following
two options: Default Totals to the Top on Row Axis and Default Totals to
the Left on Across Axis.
• for a specific sheet, the "Sheet Options" dialog box now displays the
following four options in the Totals Placement area: Top, Bottom, Left,
Right.
What's new
New features
1
Multi-language cubes
In Free Mode reports, all members are now identified by a formula. This has
greatly enhanced report stability. Consequently also, multi-language cubes
are now supported in Analyzer.
Publishing a workbook on Infoview
You can now publish all the reports of a specific workbook on
BusinessObjects Infoview.
Installing and opening Analyzer
Once you are logged in to Infoview, you can:
• Install Analyzer.
BusinessObjects Extended Analytics Release Note 9
What's new
1
New features
• Open an existing Analyzer Workbook.
• Create an Analyzer Workbook.
Cache not activated
The metadata cache function is no longer activated by default. However,
you can reactivate it, using a registry key.
In most cases, thanks to free form report enhancements, it is not necessary
to activate the cache function.
Sorting in each level of the hierarchy
The new Sort Inside level option enables you to sort parent members and
their children in each level of the hierarchy, while still preserving the hierarchy.
Note: If this option is selected, and the Default Totals to the Top on Row
Axis option is not selected, the members are sorted, but the total is displayed
at the top and not at the bottom.
Managing dynamic charts
Charts can now be dynamically refreshed when modifying a report's data
range.
Multi-selection of members in page headers
You can now select several dimension members for a page header
dimension. A custom member is automatically created for the selection. You
can then manage the custom member as you would any other custom
member.
10 BusinessObjects Extended Analytics Release Note
Technical changes
Platforms
Due to major architecture evolutions, the following components are no longer
provided:
• The Reporter server and client
• The Configuration Manager
• BusinessObjects Extended Analytics Web
To support the integration into the BusinessObjects Enterprise XI R3 platform,
BusinessObjects Enterprise XI R3 Fix Pack 01 is now required.
The former components are replaced by:
• BusinessObjects Web Intelligence
• BusinessObjects Enterprise
• BusinessObjectsVoyager
What's new
Technical changes
1
The following version of BusinessObjects Financial Consolidation is
supported:
• BusinessObjects Financial Consolidation 10.5 SP1
Caution: only this version is supported
Analyzer language in standalone mode
The default language for Analyzer in stand alone mode is English.
To change the language, you must modify the following registry key:
[HKEY_CURRENT_USER\Software\Business Objects\Extended
Analytics\Analyzer]
"resources"="Cartesis.InformationDelivery.Analyzer.Resources.en.dll"
Replace en by one of the following:
• fr for French
• de for German
• es for Spanish
BusinessObjects Extended Analytics Release Note 11
What's new
1
Technical changes
• ja for Japanese
If the key [HKEY_CURRENT_USER\Software\Business Objects\Extended
Analytics\Analyzer] "resources" does not exist, Analyzer automatically looks
for the same key in
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\IDPrj.AnalyzerAddIn].
Analyzer General Options in standalone mode
The Analyzer General Options are now saved by user and no longer by
machine.
Vista supported
Windows Vista is now supported by Designer and Analyzer.
12 BusinessObjects Extended Analytics Release Note
Known issues
2
Known issues
2
Known issues in Designer
Known issues in Designer
Rights to use Designer
A user can use Designer if the two following rights are assigned to him:
• In the CMC (Central Management Console), the Design Cube right must
be checked.
• In Financial Consolidation, the Extended Analytics Administration right
must be checked.
Reporting Category dimension not compatible with star schemas
The new Reporting Category dimension is not supported by star schema
deployments.
Data source for fact table
When you delete in Designer a custom fact table that has already been
deployed, once the cube redeployed, the custom fact table is not deployed
anymore but the data source linked to the fact table still exist.
Custom fact tables not deployed in custom measures
When deploying a cube with custom fact tables, you can choose the
destination of the tables: on default measures or on custom measures. Once
deployed, the custom fact tables data that where assigned to custom
measures were deployed in default measures.
14 BusinessObjects Extended Analytics Release Note
Known issues in Analyzer
Known issues in Analyzer
Dynamic reports generated with a 3.5 cube
If a dynamic report has been generated with a version 3.5 cube and the cube
has not been redeployed since version 3.5, the dynamic report will not be
readable on a version 7.0 cube.
Note: If the cube has been redeployed at least once with version 4.1, the
dynamic report will work properly.
Tip: In order not to lose your report, you can copy and paste it in a connected
sheet. The report will lose its dynamic properties and will be in free form, but
you will save the data.
Opening a 4.1 report in Excel 2007
Known issues
2
To open a 4.1 report, you must fisrt open it in Excel 2003, refresh it and save
it. Then, you can open the report in Excel 2007.
BusinessObjects Extended Analytics Release Note 15
Known issues
Known issues in Analyzer
2
16 BusinessObjects Extended Analytics Release Note
Fixed issues
3
Fixed issues
3
Fixed issues in Designer
Fixed issues in Designer
Importing solution with two hierarchies
Importing a solution with particular settings from version 3.5 SP1 to version
4.0 failed.
When importing a solution containing two hierarchies which part of theirs
IDs are identical, the import now succeeds.
Calculated member freezing the application
When adding a calculated member expression containing more than 80
characters and no space character, Designer could be frozen.
Star schema deployment failed because of the Period format
On Oracle and SQL databases, when setting the Period Format as
"[Mon]-[YYYY] on Period and Data Entry Period dimensions, the star schema
deployment failed.
Excluded consolidation dimensions: cube deployment failed
If the five dimensions defining a consolidation are excluded, the cube could
not be deployed.
All detailed included the NA member
On single measure group, in an analysis dimension, the All detailed
aggregation included the NA member.
18 BusinessObjects Extended Analytics Release Note
Fixed issues in Designer
Solution import with renamed hierarchies
When renaming several named level hierarchies, the solution import from
version 3.5 SP1 to version 4.1 failed.
Empty named set
When a Named set was empty, the cube was not created and processed
correctly.
All default member for named level hierarchy
When more than one named level hierarchy are selected, the All member is
now available for selection as default member.
Fixed issues
3
Characteristic value not selected and in the cube
Amounts were available in the cube even though a new created characteristic
value was not supposed to be in the cube.
Hierarchy name after export
When exporting a renamed hierarchy from version 3.5 SP1 to version 4.1,
the custom name of the hierarchy was replaced by the default name.
Import with custom calculated member
When importing a custom calculated member in a solution from version 3.5
to version 4.1, the import failed.
BusinessObjects Extended Analytics Release Note 19
Fixed issues
3
Fixed issues in Analyzer
Custom fact tables caused deployment failure
Custom fact tables hosted on a SQL Server named instance could not be
deployed.
Deploying a star schema on version 4.1 on a user defined dimension
When deploying a star schema on version 4.1 on a user defined dimension,
member NA id=0 did not exist even though the Include NA member option
was checked.
Fixed issues in Analyzer
Losing the shift on the column header after an Eliminate Member
When setting the column header to -1 in the Report Manager and performing
an Eliminate Member on the column, an empty column is automatically
inserted. When trying to set the column header to -1 again, it was not taken
into account.
Warning message on sorting
When performing an attribute filtering on a column, and when modifying the
selection on the column, a message warning was appearing, indicating that
the sorting would not be correct on the rows.
20 BusinessObjects Extended Analytics Release Note
Asymmetry lost on a page header move
When moving the page header in an asymmetric report, the asymmetry was
lost.
Technical fixed issues
64 bits Itanium platform
Setups are now available for 64 bits Itanium platform.
Patch system
Cumulative patch system now works for Designer.
Fixed issues
Technical fixed issues
3
BusinessObjects Extended Analytics Release Note 21
Fixed issues
Technical fixed issues
3
22 BusinessObjects Extended Analytics Release Note
Get More Help
A
A
Get More Help
Online documentation library
Business Objects offers a full documentation set covering all products and
their deployment. The online documentation library has the most up-to-date
version of the Business Objects product documentation. You can browse
the library contents, do full-text searches, read guides on line, and download
PDF versions. The library is updated regularly with new content as it becomes
available.
http://help.sap.com/
Additional developer resources
https://boc.sdn.sap.com/developer/library/
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/
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
24 BusinessObjects Extended Analytics Release Note
Get More Help
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:
mailto: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/.
Business Objects product information
For information about the full range of Business Objects products, visit:
http://www.businessobjects.com.
A
BusinessObjects Extended Analytics Release Note 25
A
Get More Help
26 BusinessObjects Extended Analytics Release Note
Loading...