Create a LASR Star Schema
To create a LASR star
schema:
-
Select
LASR
Create a Star Schema.
-
Drag and drop tables or data queries from the SAS Folders
tree onto the
workspace. Keep the following suggestions in mind:
-
-
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](images/incompletestatus.png)
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](images/invalidstatus.png)
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.
-
(Optional) If you do not want a column from the dimension table in the output table,
then 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.
-
(Optional) Click the Joins tab to review the columns that are used to generate the output table.
-
(Optional) Specify a
different column prefix.
For
more information, see Column Prefixes.
-
Click the Output tab, and specify a name for the output table.
-
Click
![the Save button](images/save.png)
, and specify a name and location for the LASR star schema.
-
Click
![the Run button](images/play.png)
to generate the output table.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: January 8, 2019