Schema-scoped named sets are used with members that belong to a dimension.
-
From Schema Tree View, right-click the Named Sets folder, and select New Named Set.
The Schema Element Properties View appears in the right pane.
- In the Name box, type a name for the new named set.
-
Click in the Caption box.
The caption automatically fills with the same name as the measure.
The caption displays and can be localized to different languages in the BI client application. See Cube Schema Localization.
-
Type the MDX expression in the MDX Expression box and click Validate Expression to validate the MDX expression.
See MDX Expressions in Calculations, Supported MDX Functions and Operators and MDX Validation Errors.
This figure shows the MDX Topcount function. It is also valid to enter a comma-separated list within braces of fully qualified members for the set.
- From the Hierarchy list, select a hierarchy in which this named set displays in BI client applications.
-
In the Display Folder box, type a display folder in which this folder displays in BI clients applications.
The following figure shows a newly-created display folder in Excel called Sets.