Cheat Sheet for LASR Star Schemas
|
Task
|
How to Begin in the
Data Builder
|
|---|---|
|
Add a data source.
|
Drag and drop the tables
from the SAS Folders tree onto the workspace. You must drag and drop
the fact table first and then the dimension tables.
|
|
Change the join condition
of a dimension column.
|
On the Joins tab,
double-click the Dimension Column cell.
|
|
Change the join condition
of the fact column.
|
On the Joins tab,
double-click the Fact Column cell.
|
|
Specify a different
column prefix.
|
On the Inputs tab
on the right pane, choose a different table name from the drop-down
menu.
|
|
Delete a column from
a dimension table.
|
Right-click on the column
in the table in the workspace, and select Remove Column.
|
|
Save a LASR star schema.
|
On the toolbar, click
 .
|
|
Run a LASR star schema.
|
After saving the LASR
star schema, on the toolbar, click
 , and select Run to run the
LASR star schema.
|
|
Schedule the LASR star
schema to run.
|
After saving the LASR
star schema, on the toolbar, click
 . In the Schedule dialog
box, specify information.
|
|
View the results of
a LASR star schema.
|
After you preview or
run the LASR star schema, click the Results tab.
|
Copyright © SAS Institute Inc. All rights reserved.