How to: Create a Named Set
You create a named set by using the Calculations view in Cube Designer. Cube Designer can be accessed from Business Intelligence Development Studio. You can create and view a named set only if the cube is in a processed state. After you create the named set, it becomes available to users after you re-deploy.
To create a named set
Open the cube for which you want to create a named set, and then click the Calculations tab.
On the toolbar, click New Named Set, and then in the expression pane, do the following:
- Under Name, type a name for the named set.
- Under Expression, create a Multidimensional Expressions (MDX) expression to define the named set. You can either type the expression manually, or you can drag and then drop items from the Metadata and Functions tabs.
See Also
Concepts
Other Resources
Calculations How-to Topics (Analysis Services)