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.