Use unnamed members in set consolidations

A set consolidation can now be based on named and unnamed set members.

Previously, set consolidations could be based only on existing, named set members.

To create a set consolidation, click the Set consolidations menu option. This option is available from multiple places in the application: from the dimension tile overflow menu (shown in the image below), from the column and row right-click menu, from the thumbs right-click menu, and also from the Fields panel tile menus.

In the Set consolidations dialog box, you can select the set (named or unnamed) and calculation type. By default, the Calculation name changes based on your selections. If you type a custom name, the name stays constant, no longer reacting to your selections.

To add an unnamed set member (new in this release), from the Set drop-down menu, click Set Editor.

In the Set editor , select different members to add to the list of sets for your calculation.

The new members are added at the end of the list in the Set box, and can be used to create the set consolidation.

For more information, see Add a set consolidation to a view.