Database Reference
In-Depth Information
Adding tables to the data model
You can add tables to a model either from the same data source or from a new one.
To add more tables to your model, perform the following steps:
1. Open up the
FirstCubeTabular
project.
2. Click on the
Existing Connections
button:
3. Click on the available connection and then click on the
Open
button.
4. Choose the
Select from a list of tables and views to choose the data to
import
option and click on
Next
.
5. Add the following tables to your model:
•
FactResellerSales
•
DimEmployee
•
DimReseller
•
DimGeography
6. Click on
Finish
.
7. The click on
Close
.
When you have imported the tables, the data and the relationships between the newly
imported tables will be added to your model. However, you will not get the relation-
ships between the newly imported tables and the existing tables. Instead, you need
to add these relationships manually. Perform the following steps to do this:
1. Click on the
Diagram
button in the lower right hand corner.
2. Mark the
OrderDateKey
column in the
FactResellerSales
table and drag-
and-drop it on the
DateKey
column in the
DimDate
table.
3. Perform the same step with the
DueDateKey
and the
ShipDateKey
columns.
4. Drag the
SalesTerritoryKey
column from the
DimEmployee
table and drop it
on the
SalesTerritoryKey
column in the
DimSalesTerritory
table.
Search WWH ::
Custom Search