2.0.67 - Feature updates, August 9, 2021

IBM® Planning Analytics for Microsoft Excel was refreshed on August 9, 2021 to include the following features and notices.

Updates to each version of Planning Analytics for Microsoft Excel are cumulative. To see what was new in previous releases, see What's new in Planning Analytics for Microsoft Excel.

In a future release of Planning Analytics for Microsoft Excel, we will expand the formula failure behavior to simplify error identification. #VALUE errors will denote incorrect formula construction, including bad input type. #NUM errors will specifically represent a numeric error in a formula. A #NUM error could mean that the input(s) are not in the range of valid metadata. Currently, all formula failures show #VALUE, which can be an ambiguous Excel error indicator.

Sort nested rows in Cognos Analytics explorations

You can now sort on the innermost nested row of a Cognos Analytics exploration in Planning Analytics for Microsoft Excel. In previous versions, the Sort option was unavailable when an exploration was configured with nested rows.

Note that sorting on a Cognos Analytics exploration in Planning Analytics for Microsoft Excel corresponds to the sorting behavior in Cognos Analytics, where sorting is supported only on the innermost row of a nested Crosstab and is not supported in relational Crosstabs.

For more information on sorting in a Cognos Analytics exploration, see Sort rows by values or names.