october 2019.

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 0 Comments