Create Custom Subsets with Top and Bottom Categories

Use the Custom Subset wizard in PowerPlay Web Explorer to create custom subsets that include categories having either the highest or lowest values of a specific measure.

Users can dynamically select the number of categories to include in the subset, such as the top ten or the bottom 25.

Steps

1. Open a report or cube, click the Custom Subset tool on the toolbar, and proceed through the first few pages of the wizard, selecting
   • the dimension to be used as the basis for the custom subset
   • the option to create a dynamic custom subset by measure
   • the measure to be used as the basis for the custom subset
   • the option to create a custom subset by number of categories
2. In the Create Custom Subset by Measure Value pane, instead of including values by range, click the option to include values by top (sorted in descending order) or bottom (sorted in ascending order).
3. Type the number of categories to include in the subset definition.
4. Select the required dimension level as the starting point for the subset definition and select an appropriate scoping option.
5. When you finish defining your custom subset, click Finish and confirm that the dimension tree is updated to contain your new custom subset, with the filtered levels changed accordingly.

Automation developers must update any scripts that include the command to create custom subsets by measure. Although users of the current release can still explore reports and cubes with preexisting custom subsets and bookmarks, older PowerPlay versions cannot show the new subset definitions. Instead, they open as an empty custom subset.