reyemsaibot

SAP BI Blog about SAP BW/4HANA, Analysis for Office and SAP HANA - by Tobias Meyer

What’s new in Analysis Office 2.4

Since yesterday Analysis for Office 2.4 is available. You can download it with a S-User under Support Packages and Patches >>
By Alphabetical Index (A-Z) >> A >> SBOP Analysis Office >> SBOP Analysis MS Office 2.4
.

 

The SAP help page isn’t updated yet. But I think it would be updated in the next days.

A new feature is to protect your workbook. You can choose between the complete workbook and only
sheet protection. It seems like a stripped down protection from Microsoft Excel. Why this should be necessary must be clarified.

SAP Analysis for Office Protect Workbook
SAP Analysis for Office Protect Workbook
SAP Analysis for Office Protect Workbook Options
SAP Analysis for Office Protect Workbook Options


Also a new feature is to load and save comments directly from the SAP Business Objects BI platform. How this exactly works I
have to discover. A really cool feature is the Customize User Interface where you can
easily configure different user interface. Maybe you can also configure them through the file system
settings
.

SAP Analysis for Office Customize User Interface
SAP Analysis for Office Customize User Interface

You can now define in the properties of the design panel to set a dimension to No Display.

SAP Analysis for Office Design Panel Properties
SAP Analysis for Office Design Panel Properties

The Table Design Rules editor now has a copy button, if the previous restrictions are obsolete now, have to be seen. You can now also exlcude copy and paste values from clipboard or file.

Values for clipboard copy and paste
Values for clipboard copy and paste
SAP Analysis for Office add filter via clipboard
SAP Analysis for Office add filter via clipboard


Also new is Link Dimension. This means when you filter on the main Crosstab it will also affect the linked Crosstabs. You can see the little icon that indicates the Crosstabs are
linked.

SAP Analysis for Office Link Dimension
SAP Analysis for Office Link Dimension
SAP Analysis for Office Dimension Linked
SAP Analysis for Office Dimension Linked


A really cool feature is Group Crosstabs. This means, that you combine to Crosstabs to one.

SAP Analysis for Office Group Crosstabs
SAP Analysis for Office Group Crosstabs
SAP Analysis for Office Components View Group Crosstabs
SAP Analysis for Office Components View Group Crosstabs


Here is the result of the Group Crosstabs.

SAP Analysis for Office Group Crosstabs
SAP Analysis for Office Group Crosstabs

So a first look at Analysis for Office 2.4 is done. I hope SAP release the necessary help files so we can found more about this version.

author.


I am Tobias, I write this blog since 2014, you can find me on twitter and youtube. If you want you can leave me a paypal coffee donation. You can also contact me directly if you want.

Kommentare

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert