Release
Document Version: 1.4 SP8 - 2014-07-31
What's New Guide: SAP
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
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: SAP BusinessObjects Analysis, edition for Microsoft Office
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
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: SAP BusinessObjects Analysis, edition for Microsoft Office
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.
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: SAP BusinessObjects Analysis, edition for Microsoft Office
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:
● ShowQueryDesigner to define if the 'Call Query Designer' icon should be displayed in the ribbon tools group.
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: SAP BusinessObjects Analysis, edition for Microsoft Office
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.
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: SAP BusinessObjects Analysis, edition for Microsoft Office
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.
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: SAP BusinessObjects Analysis, edition for Microsoft Office
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.
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: SAP BusinessObjects Analysis, edition for Microsoft Office
Important Disclaimers on Legal Aspects
This document is for informational purposes only. Its content is subject to change without notice, and SAP does not warrant that it is error-free. SAP MAKES NO WARRANTIES, EXPRESS OR IMPLIED, OR OF MERCHANTABILITY, OR FITNESS FOR A PARTICULAR PURPOSE.
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 specifically disclaims any liability with respect to this document and no contractual obligations or commitments are formed either directly or indirectly by this document.
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. Regarding link classification, see: http:// help.sap.com/disclaimer.
What's New Guide: SAP BusinessObjects Analysis, edition for Microsoft Office
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.
