Create a LASR Star Schema
To create a LASR star
schema:
-
Select
LASRCreate a Star Schema.
-
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
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
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
, and specify a name and location for the LASR star
schema.
-
Click
to generate the output table.
Copyright © SAS Institute Inc. All rights reserved.