Yeah finally is Analysis Office 2.8 available. It took a long time. Here is a overview what’s new.

• In the prompt dialog you can clear all values
• In the prompt dialog you can insert easily ranges with „value“ „space“ „minus“ „space“ „value“ e.g. 2018 – 2019
• You can display Dimension Groups in the Query.
• The used dimensions are highlighted in the design panel
• You can easily select the access mode in the property view
• Variants in the prompt dialog are now in alphabetical order
• You can easily get the admin or user guide by pressing F1 in the ribbon menu or the help on this function in the insert function dialog. The sam works for the customize user interface and the
  technical configuration.

This are some sweet features even not everything is running smoothly.

If someone finds another interesting point, let me know.

These posts might also be interesting:

• What’s new in Analysis Office 2.7 SP7
• What’s new in Analysis Office 2.7 SP2
• What’s new in Analysis Office 2.7
• What’s new in Analysis Office 2.6 SP3

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.

Since last week the latest version of Analysis Office is available. I installed it right away and want to test it. And what I have to see? You cann’t add hierarchies into the rows or columns of
your crosstab. I tried to record it maybe you can see it in the video below.

Does nobody test basic functions before releasing a new version? But they also fixed some bugs from previous versions.

• Analysis Office: Red borders around valid new line cells (s-note 2831840)
• AO: Documents opened from a BI Platform system are not displayed in Recent Documents List of AO (s-note 2848548)
• Analyis Office: Content of new line cells is overwritten by content of other crosstab cells when opening workbook (s-note 2861063)
• Analysis Office: Design rules formats of master crosstab not applied to dependent crosstab (s-note 2849041)
• Analysis Office: Exception when closing workbook in case ‚Remove Data Before Saving‘ is active (s-note 2854979)
• Analysis Office: Inconsistent behavior if RSADMIN parameter BICS_NEW_LINE_CHECK_ENABLED is set to blank or not existing (s-note 2844345)
• Analysis Office: Performance Tuning (s-note 2821386)
• Error after assigning attributes or while dragging them (s-note 2852220)
• Filter of a planning function not set (s-note 2851131)
• Grouped Crosstabs: „No Applicable Data“ in all Cells of the Dependants (s-note 2858675)
• Login to SAC System fails due to not receiving a valid X-XSRF token from the root url (s-note 2853284)
• New Lines – Value suggestion is not working for cell if display is combination of Text and Key (s-note 2859180)
• New Lines and Format Cells entries not disabled in context menu while running Analysis for Office in embedded Excel (s-note 2860401)
• RFC_METADATA error after upgrading BW server (client part) (s-note 2861026)
• Refresh does not work when refreshing via Workbook_SAP_Initialize event (s-note 2848410)
• Scheduling fails if Workbook contains several Styles Definitions for same Name (s-note 2840608)

I hope SAP will release soon a serivce pack 1 for Analysis Office 2.8 and fix the problem with the hierarchy, because at the moment Analysis Office 2.8 is not useable.

Update 09.12.19:

As described in the comments, it works on SAP BW 7.5 SP11 and my test was on a SAP BW 7.5 SP16.

These posts might also be interesting:

• Analysis Office 2.7 SP8 is available
• Analysis Office 2.7 SP6 is available
• Analysis Office 2.7 SP5 is available
• Analysis Office 2.6 SP3 is available

This week I discussed with a colleague. He ask if there is any way to filter multiple entries in a hierarchy because there is no Paste or Upload function in the
hierarchy filter dialog.

So he selects the nodes he needed manually. This could be very frustrating and time intense if you have a lot of nodes you want to select. But there is a smarter way to filter multiple hierarchy
nodes either via Paste or Upload. How it works I show you in this post.

First add your dimension into the rows.

Make a right click on the dimension and select the option Use only hierarchy Product Hierarchy for Filter. The term Product Hierarchy comes from your dimension. In
my case the Product Hierarchy.

And when you now select Filter By Range, the following filter dialog will be shown, where you get a Paste or Upload function.

Now you can paste or upload your values and click OK. Your data will be filtered. When you now remove the the option Use only hierarchy for filter, the hierarchy
wil be displayed again.

If you have any questions or problems, just leave a comment or write me an email.

These posts might also be interesting:

• Analysis Office  – The Comprehensive Guide 4th edition
• Analysis Office Size Limit of result set exceeded with small query
• Analysis Office 2.7 SP6 is available
• Analysis Office Data Source for Defining Formulas

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.

Now the book Analysis Office – The Comprehensive Guide 4th edition is now available via digistore24.com. You can use credit card, paypal and other payment options.

>>> https://www.digistore24.com/product/284862

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.

The latest version of Analysis Office is now available. It was released on 27.09.2019 and after the go live of my project is now done, I may have time to look more into Analysis Office
again. 

•  AO Prompt Selection makes Excel.exe freeze (s-note
  2836430)
• Analysis Office: Red borders around valid new line cells (s-note 2831840)
• Exception when opening or saving a workbook or data source after Log Off (s-note 2838591)
• RRI passes wrong context for axis tuple element (s-note
  2834404)
• SAPSetFilterComponent and Time Characteristics (s-note
  2829371)

As you can see in this version there is not many things fixed or maybe they found not more? But the What’s
new Guide lists some new file system settings (technical parameter)

• ForceWriteOlapConnectionInformationDuringWorkbookSave 
• UseDocumentDescriptionToConstructBIDocumentFileName
• UseDocumentDescriptionToConstructBWDocumentFileName
• SacHttpSessionPingInterval
• SearchFetchMemberLimit
• AllowOverwritingOfDimensionNames
• AllowOverwritingOfStructureMemberNames
• ReverseVariableProcessingOrderForHanaFromOldxml
• UseKeyForHierarchySelection
• UseQueryVariantsForViews

The admin guide now documented now all these parameters. A nice parameter is UseKeyForHierarchySelection, which allows you to define if you want to see the keys of a
hierarchy in the first coloumn or second column of your prompt.

As you can see, the user can now either see the description or the technical name in his selection. Another setting is the AllowOverwritingOfDimensionNames. The default value is true,
that means the user can overwrite the name of a dimension in the design panel.

The same works with the setting AllowOverwritingOfStructureMemberNames for structures. The best setting is UseQueryVariantsForViews. With this setting you can get the query
variant when you insert a query view.

As you can see in the right picture, I can access the variant of my query. This is really cool when I use a lot of variants. I know this service pack is not the hotest shit, but slowly it gets
better. I am still hoping for Analysis Office 2.8 with new features.

These posts might also be interesting:

• What’s  new in Analysis Office 2.7 SP7
• Analysis Office 2.7 SP5 is available
• Analysis Office 2.7 SP2 is available
• Analysis Office 2.5 – Technical Configuration

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.

Until the end of the month you can get my book with 30% off. Just use the discount code Summer2019. You can buy it here.

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.

It’s a kind of summer break at the moment and I haven’t done a lot for this blog in the last time. But SAP now release the 7th service pack of Analysis Office. 

You can now use the filtering data access mode with SAP Analytics Cloud data sources, analytic and planning models. There are also 3 new file system settings:

• ShowCutCopyPasteInGridContextMenu
• EnableImprovedAddInCompatibility
• UseSeparateDisplaySettingsForFilterDialog

The setting ShowCutCopyPasteInGridContextMenu allows you to sepcify whether the cut, copy and paste entries should be available in the context menu for a crosstab cell. The setting
EnableImprovedAddInCompatibility should improve the compatibility with other Microsoft Office add-ins. How this work we will see.

The setting UseSeparateDisplaySettingsForFilterDialog you can define if the display settings defined in the filter dialog should be saved with the workbook.

So as you can see nothing spectecularit fixes also a little bit:

• ALL: Current View Edition mode when a member start with the same characters that another member (s-note 2811124)
• ALL: during a customized drill through Excel remains frozen (s-note 2813223)
• ALL: last selection not saved when set to Base Level (s-note 2811297)
• AO 2.7 SP6: Office 2010 – Can’t open AO workbooks via launcher (s-note 2814329)
• Analysis Office Performance Issue when Refreshing Workbooks with Many Format (Design) Rules (s-note 2813968)
• ALL:Report options are truncated (s-note 2814791)

 I am still looking for Analysis Office 2.8, but now I am first enyoing my vacation.

These posts might also be interesting:

• What’s new in Analysis Office 2.7 SP2
• Analysis Office Data Source for defining formulas
• What’s new in Analysis Office 2.6 SP3
• What’s new in Analysis Office 2.6 SP2

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.