Create Seed Data from a Cube

To create seed data from cube views, first define your definition or transactions using the Data Subset component. For more information, see the documentation about Data Subset.
tdm10
To create seed data from cube views, first define your definition or transactions using the Data Subset component. For more information, see the documentation about Data Subset.
  1. Open the Datamaker UI and select
    Data Subset, Design Extracts and Transactions
    from the main menu.
    The Data Subset UI opens.
  2. Define the definition or transaction in the Data Subset UI. 
    After the definition is created, save it to the repository. 
  3. To save the definition to the repository, select
    File, Save Extract to Repository
    from the main menu in the Data Subset UI. 
    For example, in the following example, the table PRODUCTS_BASE is linked through three tables to the PERSONS table. This definition is created in the Data Subset UI:
    Cube.png
  4. Navigate to the Datamaker UI. 
    You can now use this definition to extract a cube of data using these subset definitions. 
  5. To find the definition, use the
    Project Manager
    dialog to navigate to appropriate definition.
  6. Right-click the selected definition and select the
    Create Seed Data from Cube
    option.
    The
    Sample Options
    dialog opens.
  7. Select the appropriate connection to the sample data and click
    OK
    .
    The
    Choose Transaction
    dialog opens.
  8. Select the columns that you want to include in the data cube by right-clicking on a table and adding columns.
  9. Click the tick mark icon when you are done with the task.
  10. Enter a name for your cube and click
    OK
    .
    The
    Cube Generation Options
    dialog opens. This dialog includes options that help you define how to generate the cube.
    Note:
    For normal use cases, you can use the default values.
  11. Click the tick mark icon.
    A summary of the data is displayed.
    You can save the data as seed data using the save icon. You can also save the SQL and use it to create views or select statements by clicking the SQL icon.