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.


TM1Connect Subset - Advanced 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. In the TM1Connect plug-in, the user has the ability to change the member selection for the information to be returned by using the Customize button in the Filters tab.

TM1Connect - Filter Members

By disabling this option, any user customizations will be ignored.

hmtoggle_arrow1        Include Hierarchy        

Include Hierarchy option group adds columns to the results which effectively Flatten the hierarchy so that QlikView 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.