Create a LASR Star Schema

To create a LASR star schema:
  1. Select LASRthen selectCreate a Star Schema.
  2. Drag and drop tables or data queries from the SAS Folders tree onto the workspace. Keep the following suggestions in mind:
    • Drag and drop the fact table first and then the dimension tables.
    • Any input tables that are not already in a SAS LASR Analytic Server library are loaded to memory when the star schema is run.
    • If a dimension table shows the incomplete table status icon, then it usually indicates that the data builder could not determine the join condition for the dimension table. Position your pointer over the icon for information about how to correct the incomplete table status.
    • If a dimension table shows the invalid table status icon, then it usually indicates that the table is from a different SAS LASR Analytic Server library than the output table. You must use one SAS LASR Analytic Server library only.
  3. (Optional) If you do not want a column from the dimension table in the output table, select the column in the table in the workspace, right-click, and select Remove Column.
    Note: All of the columns from the fact table are automatically selected and required to be included in the output table.
  4. (Optional) Click the Joins tab to review the columns that are used to generate the output table.
  5. (Optional) Specify a different column prefix. For more information, see Column Prefixes.
  6. Click the Output tab, and specify a name for the output table.
  7. Click the Save button, and specify a name and location for the LASR star schema.
  8. Click the Run button to generate the output table.
Copyright © SAS Institute Inc. All rights reserved.