View Custom Subset Definitions

If a dimension filter or a crosstab row or column contains a custom subset, the Explain window in PowerPlay Web Explorer shows a concise description of the custom subset definition, next to an identifiable icon.

For example, instead of just the subset name, subset categories are listed in the form of searchable strings, ranges, or contains expressions. Starting points and scope may also be shown.

The detailed text can be viewed and modified in the Custom Subset wizard. However, the following does not appear in the Explain window:

• categories in a static pick list
• explicitly included categories or categories with discarded results
• in custom subsets by measure, the top (root) level of a dimension.

Steps

1. In PowerPlay Web Explorer, open a crosstab.
2. On the toolbar, click the Create Custom Subset tool.
3. Proceed through the wizard, choosing either a pick list, name, measure range, or count as the basis for your custom subset.
4. As appropriate, select either the categories, measure, count or range for your subset, defining a contains expression as required.
5. Click Finish to save your custom subset definition.
6. Right-click a row, column, or cell in the crosstab and click Explain.
7. Scroll as necessary, and observe the detailed description of your custom subset.

The text appears under any filters and, for multiple custom subsets, under an appropriate heading.