Creating Subsets
Procedure
- Open the process subsets in the
TurboIntegrator window.
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:
V0
V1
V2
V3
V4
Sweden
Scandanavia
Europe
International
Europe
Norway
Scandanavia
Europe
International
Europe
Denmark
Scandanavia
Europe
International
Europe
France
Europe
International
Worldwide
Europe
Germany
Europe
International
Worldwide
Europe
UK
Europe
International
Worldwide
Europe
Ireland
Europe
International
Worldwide
Europe
Holland
Europe
International
Worldwide
Europe
Spain
Europe
International
Worldwide
Europe
Italy
Europe
International
Worldwide
Europe
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);
- Execute the process.
- In the Server Explorer, expand the newdim dimension and view the newly created subsets.