Define Cube Dimensions and Create the View

Before you can build a cube view, create a subset of your data. To do so, start by designing a transaction, which includes all the tables you want to analyze. For more information about how to do this, see the documentation about Data Subset.
tdm10
Before you can build a cube view, create a subset of your data. To do so, start by designing a transaction, which includes all the tables you want to analyze. For more information about how to do this, 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. Extract your subset in the Data Subset UI.
    In the left pane, you can see a chain of all the applicable tables within the transaction.
  3. Navigate to the Datamaker UI and select the
    Data Profiler, Create Cube View
    option from the main menu.
    The
    Choose Extract
    dialog opens.
  4. Click the row of the extract for a check mark to appear, and click
    OK
    .
    The
    Sample Options
    dialog opens.
  5. Select the connection (source, target, or test case) from where you want to sample the data and click
    OK
    .
    The
    Choose Transaction
    dialog opens.
  6. Select the columns that you want to analyze. 
    These columns are important from a coverage standpoint and are used to drive the subset.
  7. After you select the columns, the
    Cube Generation Options
    dialog opens defining the details and dimensions of the view you are trying to create for your analysis.
    Note:
    At the top of the dialog, you have the opportunity to limit the number of results for each distinct combination. 
  8. Click the tick mark icon.
    Two types of SQL are created—one distinct and the other including the details that are visible in the SQL Window (you are taken to the SQL Window automatically).
  9. Pressing ALT + A converts the SQL to views within the database. 
    For more information about registering these views, see the information about the database cubes in this documentation.