SAP BusinessObjects Analysis, edition for Microsoft Office
Document Version: 1.4 SP9 - 2014-10-15
What's New Guide
Table of Contents
1
About this guide . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3
2
About the documentation set. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4
3
New and changed features in Analysis, edition for Microsoft Office 1.4. . . . . . . . . . . . . . . . . . . . . 6
4
New and changed administration options in Analysis, edition for Microsoft Office 1.4. . . . . . . . . . 8
5
Changes in Analysis, edition for Microsoft Office 1.4 SP1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
6
Changes in Analysis, edition for Microsoft Office 1.4 SP2. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
7
Changes in Analysis, edition for Microsoft Office 1.4 SP4. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
8
Changes in Analysis, edition for Microsoft Office 1.4 SP5. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12
9
Changes in Analysis, edition for Microsoft Office 1.4 SP6. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
10
Changes in Analysis, edition for Microsoft Office 1.4 SP7. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
11
Changes in Analysis, edition for Microsoft Office 1.4 SP8. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15
2
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
What's New Guide
Table of Contents
1
About this guide
The What's New guide for SAP BusinessObjects Analysis, edition for Microsoft Office, provides a complete list of
the new and modified features for SAP BusinessObjects Analysis since the previous release. It also comprises a
list of all new and changed administration tasks for SAP BusinessObjects Analysis.
What's New Guide
About this guide
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
3
2
About the documentation set
The documentation set for SAP BusinessObjects Analysis, edition for Microsoft Office, comprises the following
guides and online help products:
Tip
The guides and tutorials are regulary updated and enhanced. Make sure that you have the latest version by
checking the SAP Help Portal and SAP Community Network on a regular basis.
Administrator Guide
The Administrator Guide contains detailed information that a user needs to install, configure and administer the
edition for Microsoft Office. The guide is available on the SAP Help Portal.
User Guide
The User Guide contains the conceptual information, procedures and reference material that a user needs to
create and analyze Microsoft Excel workbooks and Microsoft PowerPoint slides with the edition for Microsoft
Office. The guide is available on the SAP Help Portal.
Online Help
The online help contains the same information as the User Guide. It can be called by pressing the Help button in
the Setting group on the Analysis tab. To access context sensitive help, move the mouse cursor to a field in the
ribbon and select F1. For dialogs, you can access context sensitive help by selecting F1 when the dialog is open.
What's New Guide
The What's New guide for SAP BusinessObjects Analysis, edition for Microsoft Office, provides a complete list of
the new and modified features for SAP BusinessObjects Analysis since the previous release. The guide is available
on the SAP Help Portal.
eLearning Tutorials
The tutorials show you how to use SAP BusinessObjects Analysis. They give you a quick introduction to different
features so that you can learn the basics of working with the Add-In. They also give you a first impression of the
4
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
What's New Guide
About the documentation set
look and feel. The tutorials are available in the SAP Community Network at http://scn.sap.com/docs/DOC-7679?
refer=product-help
.
Note
SAP BusinessObjects Analysis, OLAP edition, although related very closely to SAP BusinessObjects Analysis,
edition for Microsoft Office, has its own documentation set, including its own user guide and online help.
What's New Guide
About the documentation set
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
5
3
New and changed features in Analysis,
edition for Microsoft Office 1.4
You can find more detailed information on the features listed below in the User guide for SAP BusinessObjects
Analysis, edition for Microsoft Office.
Creating and administrating workbooks
You can store workbooks to the SAP BusinessObjects Business Intelligence platform XI 4.1.
With this platform, you can save Analysis objects as Analysis Workbook and Analysis Presentation. If you open
these objects from the BI launch pad, Analysis is started automatically and the data sources are connected.
Refreshing data sources
With the Refresh All icon in the ribbon, you can now refresh the data sources regulary with data from the server.
With the property Reset Data Source on Opening Workbook on the Components tab in the design panel, you can
define that the initial state of a query or query view defined in the BEx Query Designer, will be displayed when you
open a workbook.
Access Mode for member display
With the access mode, you can define which members of a dimension are dispayed in the in the crosstab or in the
Filter by Member dialog. The access mode is only available if you select the check box Allow Access Mode to be
Changed in the Advanced Settings dialog.
Calling the BEx Query Designer
You can call the Query Designer from Analysis to check the definition of a query and to change it according to your
needs.
Inserting waterfall charts
You can display data of one key figure in a vertical or horizontal waterfall chart. Waterfall charts are specialised
bar charts consisting of an initial and final state and delta values showing the changes between the start and end
state.
6
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
What's New Guide
New and changed features in Analysis, edition for Microsoft Office 1.4
Working with formulas
The function SAPGetUniformScaling is new. It returns the unit/scaling information for a specific dimension
member combination.
Working with macros
The following API methods are changed/enhanced with release 1.4:
●
SAPExecuteCommand
The command RefreshData is new.
Working with hierarchies
The different versions of an hierarchy for a dimension are now displayed in the design panel with the version
number available in brackets after the hierarchy name.
For time-dependent hierarchies, you can specify wether all time-dependent hierarchies for a dimension should be
available in the design panel or only the hierarchy for a selected period. To display all time-dependent hierarchies
for a dimension, select the Show All Time-Dependent Hierarchies in Analysis Tab check box in the Advanced
Settings dialog.
Additionally, you can activate and deactivate hierarchies in the design panel to switch between hierarchical and
flat presentation.
Creating web applications
You can transfer components in an Analysis workbook to the SAP BusinessObject Design Studio to create a web
application. You can then modify the web application with the design studio.
What's New Guide
New and changed features in Analysis, edition for Microsoft Office 1.4
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
7
4 New and changed administration options
in Analysis, edition for Microsoft Office 1.4
You can find more detailed information on the options listed below in the Administration guide for SAP
BusinessObjects Analysis, edition for Microsoft Office.
Supported BI Platforms
SAP BusinessObjects Analysis 1.4 supports SAP BusinessObjects Business Intelligence platform 4.1. If you use
the 4.1 platform with Analysis 1.4, Microsoft .NET Framework 3.0 or 3.5 must be installed on the client PC.
Available Settings
The following settings are new:
●
8
ShowQueryDesigner to define if the 'Call Query Designer' icon should be displayed in the ribbon tools group.
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
What's New Guide
New and changed administration options in Analysis, edition for Microsoft Office 1.4
5
Changes in Analysis, edition for Microsoft
Office 1.4 SP1
With SP1, the following changes and modifications are available in Analysis 1.4.
Working with formulas
The function SAPListOfMembers has a new parameter: Count. You can use it to specify the number of members
that is returned by the formula.
Filtering data
You can filter for one member directly in the crosstab with a double-click on the respective member cell.
This function can be enabled/disabled with the registry setting EnableDoubleClick.
What's New Guide
Changes in Analysis, edition for Microsoft Office 1.4 SP1
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
9
6 Changes in Analysis, edition for Microsoft
Office 1.4 SP2
With SP2, the following changes and modifications are available in Analysis 1.4.
Working with macros
SAPExecuteCommand: The command AutoRefesh is new.
10
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
What's New Guide
Changes in Analysis, edition for Microsoft Office 1.4 SP2
7
Changes in Analysis, edition for Microsoft
Office 1.4 SP4
With SP4, the following changes and modifications are available in Analysis 1.4.
Creating and administrating workbooks
You can save and open workbooks in/from SAP Lumira Cloud.
Working with macros
SAPExecuteCommand: The command ShowPrompts is new.
Filtering Data by Member
If a dimension is selected that has more members than defined in the User settings, the filter dialog for mass data
is opened. In this dialaog, you initially see the selected members, but you can add all other members of the
dimension using hte input help.
The filter dialog for mass data can be disabled with the registry setting EnableMassDataSelector.
Configuration for SAP HANA
To use a local HANA connection, you have to enable SSO in the Windows ODBC Data Source Administrator.
Scheduling
You can schedule Analysis workbooks to automatically run at specified times in BI Launch Pad and Central
Management Console.
To enable scheduling, the Analysis BI platform Add-On must be installed.
What's New Guide
Changes in Analysis, edition for Microsoft Office 1.4 SP4
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
11
8 Changes in Analysis, edition for Microsoft
Office 1.4 SP5
With SP5, the following changes and modifications are available in Analysis 1.4.
Defining Style Sets for Crosstabs.
The SAP standard style SAPEmphasizedTotal is new. It is applied to all new workbooks and can be added manually
to existing workbooks.
Advanced Settings
The following settings are changed:
●
Show 'Call Query Designer' in Tools Group and Enable Data Source Reset is renamed to Show 'Launch Query
Designer' in Tools Group. The context menu entry Reset Data Source is now always enabled.
●
Allow Access Mode to be Changed is renamed to Show Access Mode for Member Display.
12
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
What's New Guide
Changes in Analysis, edition for Microsoft Office 1.4 SP5
9 Changes in Analysis, edition for Microsoft
Office 1.4 SP6
With SP6, the following changes and modifications are available in Analysis 1.4.
Working with formulas
The function SAPListOfMeasureFilters is new. The function returns a list of measure filters including BEx
conditions.
Analyzing data with the design panel
On the Infomation tab in the design panel, you can now see the BEx conditions as part of the filter section.
Configuring the Analysis Add-In Launcher
New parameter: UseRunningProcess to start the Analysis Add-In using an Microsoft Excel process that is already
running.
What's New Guide
Changes in Analysis, edition for Microsoft Office 1.4 SP6
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
13
10 Changes in Analysis, edition for Microsoft
Office 1.4 SP7
With SP7, the following changes and modifications are available in Analysis 1.4.
Configuration for SAP HANA
You can create local HANA connections in the Select Data Source dialog.
14
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
What's New Guide
Changes in Analysis, edition for Microsoft Office 1.4 SP7
11 Changes in Analysis, edition for Microsoft
Office 1.4 SP8
Configuring the Analysis Add-In Launcher
New parameter: BiSharedAddinLauncher.exe /app XLS /CreateProcess starts the Analysis Add-In using a new
process if Microsoft Excel 2013 is already running.
What's New Guide
Changes in Analysis, edition for Microsoft Office 1.4 SP8
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
15
Important Disclaimers and Legal Information
Coding Samples
Any software coding and/or code lines / strings ("Code") included in this documentation are only examples and are not intended to be used in a productive system
environment. The Code is only intended to better explain and visualize the syntax and phrasing rules of certain coding. SAP does not warrant the correctness and
completeness of the Code given herein, and SAP shall not be liable for errors or damages caused by the usage of the Code, unless damages were caused by SAP
intentionally or by SAP's gross negligence.
Accessibility
The information contained in the SAP documentation represents SAP's current view of accessibility criteria as of the date of publication; it is in no way intended to be a
binding guideline on how to ensure accessibility of software products. SAP in particular disclaims any liability in relation to this document. This disclaimer, however, does
not apply in cases of wilful misconduct or gross negligence of SAP. Furthermore, this document does not result in any direct or indirect contractual obligations of SAP.
Gender-Neutral Language
As far as possible, SAP documentation is gender neutral. Depending on the context, the reader is addressed directly with "you", or a gender-neutral noun (such as "sales
person" or "working days") is used. If when referring to members of both sexes, however, the third-person singular cannot be avoided or a gender-neutral noun does not
exist, SAP reserves the right to use the masculine form of the noun and pronoun. This is to ensure that the documentation remains comprehensible.
Internet Hyperlinks
The SAP documentation may contain hyperlinks to the Internet. These hyperlinks are intended to serve as a hint about where to find related information. SAP does not
warrant the availability and correctness of this related information or the ability of this information to serve a particular purpose. SAP shall not be liable for any damages
caused by the use of related information unless damages have been caused by SAP's gross negligence or willful misconduct. All links are categorized for transparency
(see: http://help.sap.com/disclaimer).
16
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
What's New Guide
Important Disclaimers and Legal Information
What's New Guide
Important Disclaimers and Legal Information
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
17
www.sap.com/contactsap
© 2014 SAP SE or an SAP affiliate company. All rights reserved.
No part of this publication may be reproduced or transmitted in any
form or for any purpose without the express permission of SAP SE
or an SAP affiliate company. The information contained herein may
be changed without prior notice.
Some software products marketed by SAP SE and its distributors
contain proprietary software components of other software
vendors. National product specifications may vary.
These materials are provided by SAP SE or an SAP affiliate company
for informational purposes only, without representation or warranty
of any kind, and SAP or its affiliated companies shall not be liable for
errors or omissions with respect to the materials. The only
warranties for SAP or SAP affiliate company 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.
SAP and other SAP products and services mentioned herein as well
as their respective logos are trademarks or registered trademarks
of SAP SE (or an SAP affiliate company) in Germany and other
countries. All other product and service names mentioned are the
trademarks of their respective companies.
Please see http://www.sap.com/corporate-en/legal/copyright/
index.epx for additional trademark information and notices.