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.

Default Value UseKeyForHierarchySelection
Default Value UseKeyForHierarchySelection
Changed Value UseKeyForHierarchySelection
Changed Value UseKeyForHierarchySelection

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.

Default Value AllowOverwritingOfDimensionNames
Default Value AllowOverwritingOfDimensionNames
Changed Value AllowOverwritingOfDimensionNames
Changed Value AllowOverwritingOfDimensionNames

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.

Default Value UseQueryVariantsForViews
Default Value UseQueryVariantsForViews
Changed Value UseQueryVariantsForViews
Changed Value UseQueryVariantsForViews

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.

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.

Analysis Office - The Comprehensive Guide 4th edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.7 and contains 299 Pages.
59,99 €
Analysis Office - The Comprehensive Guide 3rd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.6 and contains 272 Pages.
39,99 €
Analysis Office - The Comprehensive Guide 2nd edit
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.4 and contains 243 pages.
29,99 €
Analysis Office - The Comprehensive Guide
Analysis Office - The Comprehensive Guide is a pdf book about SAP BusinessObjects Analysis Office. It is based on Analysis Office 2.3 and contains 227 Pages.
9,99 €

Write a comment

Comments: 0