october 2019.

Decode an Analysis Office Workbook

The Analysis Office Workbook saves a lot of information in it. The Microsoft Excel format xlsx is a container which can save a lot of other information besides the normal data. When you rename a xlsx file to a zip file you can extract it with for example 7-Zip. Now you see the following folder structure.

Read More 6 Comments

Analysis Office - The Comprehensive Guide

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

Read More 0 Comments

Analysis Office 2.7 SP8 is available

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.

Read More 2 Comments