Managing Dimension Subsets

Dealing with multi-hierarchy dimensions in TM1 can be challenging when trying to present to applications/components that rely on relational format.   Dimension subsets in  Enterprise Services  enable you to define not only how the dimension members are to be returned, but also the hierarchy and attributes associated with the dimension members all within a single web method call.   Subsets in Enterprise Services can provide superior control and better performance than TM1 WebSheets.   Some features include:

 

Returning dimension attribute information along with dimension members

Flattening of hierarchies into separate columns

Virtual formula based columns

Sorting and selecting members by attributes

Customized column mapping and element renaming

 

Enterprise Services Manager allows you to use existing TM1 subsets or create custom subsets to be published as web services.  These web services can then be used by applications to filter and control data retrieved from views.
 

Creating a Subset

To create a subset in Enterprise Services, simply click on the Dimensions section, and select an existing subset, or click on the dimension name if no TM1 subsets exist.  

 

Dimension Section

 

This will open a new tab with the name of the view in the content section of the Manager and display the properties of the subset similar to the image shown below.  

 

Managing Subsets

 

At this point, you can set the options required for this subset and press the Save or Save As button at the bottom of the screen.   This will create a copy of the subset in Enterprise Services and store it in the Enterprise Services server under the same dimension.  This will be reflected in the Object Navigation Section, denoted by a green world icon in the lower right corner.  

 

Note_200

NOTE:  For all member selection methods other than Subset, any changes to the original subset in TM1 will not affect what is defined in Enterprise Services.  This ensures application stability should the TM1 subset be updated or removed.

 

Views, subsets, processes, and chores must be named in accordance with XML web service naming conventions:

 

Names can contain letters, numbers, and other characters

Names cannot start with a number or punctuation character

Names cannot start with the letters XML (or XML, or XML, etc)

Names cannot contain spaces

 

Any name can be used, no words are reserved.  See http://www.w3schools.com/xml/xml_elements.asp for more details.

 

Deleting a Subset

Deleting a subset in Enterprise Services only removes the view definition it does not delete the subset in TM1.    To delete a subset in Enterprise Services, simply click on the subset to be deleted.  When the properties are displayed in the content section, simply click the Delete button.

 

 

Previewing a Subset

At any time during the process of setting options for a subset, you can preview the results of how the data will be returned to your applications.    Clicking on the Preview button will return the results first in a grid for ease in viewing, as shown below:

 

Subset Preview

 

You may also view the results in JSON or XML format by selecting the radio buttons at the top of the Preview dialog.

Subset Preview - JSON