Excel Add-In Version 8.0.0

June 18, 2021 - Build 569

The supported versions of Excel include the following: Excel 2010, Excel 2013, and Excel 2016. Although not explicitly supported, there are currently no known issues when using the add-in with Excel 2007.

The supported versions of Essbase include 9.3.0 and higher.

This release contains the following changes:

  • Ancestor On Top - Essbase 19c supports the ability for a user to set whether ancestors are positioned at the top or the bottom of related child members in the results of a zoom operation. #2493

    To enable this capability, an administrator must set the Essbase server-side application config setting, SSANCESTORONTOP, to True.

    In 8.0, an ancestor position Ancestor On Top Essbase option is supported.


    To prevent the option from being displayed in the Essbase Options dialog, the ancestorOnTop showInTaskPane setting can be set to "false" in the deployment configuration file. By default, the value is "true".

  • Member Select: For an ASO cube, the Member Select dialog no longer includes the Attribute Calculation dimension in the Dimension dropdown list. ASO cubes only support the Sum attribute calculation. #2458