2.0.70 - Feature updates, December 20, 2021

IBM® Planning Analytics for Microsoft Excel was refreshed on December 20, 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.

New API functions to run evaluations

The Evaluate functionality can now be used in a VBA macro in Planning Analytics for Microsoft Excel. Previously, Planning Analytics for Excel did not support the Evaluate command.

Two new methods are now available with which the Evaluate functionality can be used in Planning Analytics for Excel:
  1. You can use the EvaluateSynchronous function, which behaves like Excel's Evaluate formula.
  2. You can turn on Planning Analytics for Excel’s single pass mode with the SinglePassMode Boolean flag and run evaluations with Excel’s Evaluate formula.

For more information, see EvaluateSynchronous (https://ibm.github.io/paxapi/#evaluatesynchronous).