Creating Subsets

You might have to edit the data source to point to region.csv in your TI_data directory. If you change the data source, you will be prompted to specify how process variables should be handled. Select Keep All Variables.

This example uses the TM1® TurboIntegrator functions SubsetCreate() and SubsetElementInsert() to create and populate dimension subsets.

The preview of the source file looks like this:

Here are the scripts for the process subsets:

Prolog>

#****GENERATED STATEMENTS START****

#****GENERATED STATEMENTS FINISH****

SubsetCreate('NewDim','Europe');

SubsetCreate('NewDim','US');

SubsetCreate('NewDim','ROW');

Metadata>

#****GENERATED STATEMENTS START****

#****GENERATED STATEMENTS FINISH****

SubsetElementInsert('NewDim',V4,V0,0);