<< Click to Display Table of Contents >>

Subset properties are used to control the information that is returned from a dimension, including what members to return, whether to flatten hierarchies, sorting order, as well as member attributes.


View Subset Properties


Setting Subset Properties

On the basic subset properties screen the following properties are available:

hmtoggle_arrow1        Dimension Name        

hmtoggle_arrow1        Subset Name

hmtoggle_arrow1        Member Selection Method

Previewing Subsets

Once you have made all the required property settings, you can preview the results by pressing the Preview button. This will display the dimension in a grid layout similar to the one shown below:

Subset Preview


If you need to see how the dimension elements will be returned in a JSON or XML format, you can simply click on the appropriate radio button at the top of the screen. The results will be similar to the following:


Subset Preview - JSON



NOTE: Previewing a subset in JSON or XML format displays only how a dimension preview would look in either of these formats. When the subset is used in a view, this is not how the view is returned. Use Preview on the View Properties page to preview how the results of the view will be returned in JSON or XML format (see Managing Cube Views for details)