Creating Subsets

In this exercise you create subsets for the dimension newdim, which is created by the dimension process.

Procedure

  1. 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);
  2. Execute the process.
  3. In the Server Explorer, expand the newdim dimension and view the newly created subsets.