Setting Advanced Subset Properties

For most cases, the basic and default settings of subsets is sufficient for most applications.   There are times, however, when additional capability or information is required, such as flattening hierarchies, or restricting which dimensions allow the member lists to be modified at run time.   These options you will find in the Advanced Properties page of the subsets.  

 

Advanced Subset Properties

 

The available advanced subset properties are:

hmtoggle_arrow1        Allow Member List to be Modified at Runtime        

This option enables (or disables) the ability for the user/application to control the list of dimension members to use when rendering the subset.  If this option is disabled, any parameters supplied in the URL for this dimension, which attempt to alter the member list, will be ignored.

hmtoggle_arrow1        Include Hierarchy        

Include Hierarchy option group adds columns to the results which effectively Flatten the hierarchy so that relationally aware applications or components (such as grids) can now provide native capabilities like filtering, sorting and grouping on the data returned from TM1.   Flattening can be performed on both level based dimensions and ragged (or non-uniform) dimensions.  

TM1 Dimension

Flattened Dimension

Level Based Hierarchy

Flattened Hierarchy

There are a number of options that can be applied when including (flattening) a hierarchy.  For a detailed explanation of these options and how they apply to level-based and ragged hierarchies, see topic Flattening Hierarchies.