Improved error messages and error handling

Error toast messages displayed in Universal Report in Planning Analytics Workspace websheets have been improved.

There are two new kinds of error messages that can be displayed in Universal Reports: MDX error messages and parser error messages.

The following image shows the MDX error message:

An MDX result is responsible for the row and column member names, toggles for the row & columns, and the data in their intersections. An MDX query has many elements, including the slicer values, an eligible server name, data source, a cube, and anything else required by your MDX query. When the generated MDX can not be evaluated, an MDX error toast message is shown. If an MDX error is shown, you can click the Show format areas button on the IBM® Planning Analytics for Microsoft Excel toolbar and check the datasource, the server, the slicers, and the TM1Set formula values for missing or incorrect data. Most of these values are auto-generated when creating a Universal Report from IBM Planning Analytics for Microsoft Excel. More details on the MDX error can be found in the tm1web.log file.

The following image shows the parser error message:

A parser response contains information for the row and column axis, slicers, and hierarchy selections. When one of these key elements cannot be evaluated by the Universal Report, the parser error toast message is shown. If a parser error is shown, you can click the Show format areas button on the IBM Planning Analytics for Microsoft Excel toolbar and check the query, row axis sets, and column axis sets for missing or incorrect data. More details on the parser error can be found in the tm1web.log file.