New experience view now on modeling workbench
The new experience view (or exploration) and new set editor are now available on the modeling workbench. Along with an improved look and feel, this new experience interface has several usability improvements and enhancements. Until now, the new experience interface was only available in Planning Analytics Workspace books.
Using the new experience view
The new experience view offers flexible options to view, analyze, and organize data. Features in the new experience view are also now more accessible.
- A more guided and intuitive experience
The new view's improved design offers a more guided experience without compromising its capabilities. For example, the new view now guides you to the drop zone when you drag a dimension to a different location in the grid.
You can use the icons in the grid
to:- See the cube in the data tree.
- Expand or collapse the overview.
- See benched dimensions.
- Select hierarchy, iconography, context information, and section headers to customize your view.
Each dimension tile in the grid now has a menu icon next to it from which you can:- Open the set editor.
- Remove, replace, or add related hierarchy.
- Move the dimension to the bench.
- Manually move the dimension right or left, or to a row, column, or context.
- Limit the number of sets for a dimension (Customize sets)
Depending on the number of dimensions or the size of the view, all dimensions might not display.
To see dimensions that are hidden from the view, click the More dimensions menu in the Context, Row, or Column area.
From the More dimensions menu, you can drag dimensions to the Context, Row, or Column area and vice versa. You can also move dimensions that appear within the More dimensions menu.
You can click the menu next to the member's name to open the set editor, move the dimension to the bench, see move options, and more.
- Target selecting
toggle for asymmetric calculation
The new Target selecting toggle is used to create an asymmetric calculation. You no longer need to select the individual button on the row or column headers to create an asymmetric calculation. Instead, enable Target selecting and select the members that you want to use in the asymmetric calculation. Right-click a selected member and click Calculation options.
Using the new set editor
The new set editor can be accessed only through the new view. If you open a set as a separate tab from the data tree, it still uses the classic interface.
To open the set editor, click the menu icon next to a dimension in the view and select Open set editor.
You can also double click the dimension tiles or click the Set Editor icon in the dimension menu to open the set editor.
As with the new view, the new set editor offers an improved flow, a more intuitive experience, and flexible options to edit your set.
- Set menu
With the Set menu, you can now change the set from within the set editor.
- Improved MDX panel
Click MDX to see the MDX panel and script. You can edit the script in the panel and click Commit to apply your changes to the current set.
- Settings
menu
The Settings menu offers options to customize the display for your set.
Enable Compact header under the General section to reduce the size of the set editor header and see more members.
You can also remove icons from all members for a simplified display with the Icons property under General.
- Multi-select activity display
When you select multiple members in Available members or Current set, an activity bar now displays with your selection information and available options.
- Improved features
The Search and Filter features in the new set editor are now more intuitive and improved for usability. The filter feature allows you to filter a set by one or more attributes to choose the available members that appear in the set. The search feature lets you search for members in the set editor. You can use both features to include members in a set that match specific criteria.
The new experience set editor also offers the ability to delete sets from within the set editor.