Databases Reference
In-Depth Information
Level reference
With the level reference set, the data source should be arranged or organized from the
leaf node or bottom level to the top level or the dimension name. We consider the leaf
node to be
Level 0
, the next record is called
Level 1
, the next record is
Level 2
, and
so on, until we reach the top dimension level. For example:
Month
|
Quarter
|
Year
.
Parent-child reference
In the parent-child reference, the parent is followed by the child. Each record will
have a parent and then its child. For example, the
YEAR
member is the parent and
the
QUARTER
member is the child. The
QUARTER
level is also a parent since its
child members are the months.
For this example, we have used the generation reference.
GEOGRAPHIC
REGION
REGION
ALIAS
CITY
ALIAS
DEALER
NAME
DEALER
ALIAS
HUB
CITY
NorthAmerica
NA
Central
Detroit
Detroit
Detroit
Detroit
DTW
Motor City EssCar
Motown EssCar
Phord City EssCar
East Side EssCar
Midwest EssCar
Soldier Field EssCar
Capone EssCar
St. Valentines EssCar
12045
12046
12047
12084
17801
17802
17803
17804
NorthAmerica
NA
Central
DTW
NorthAmerica
NA
Central
DTW
NorthAmerica
NA
Central
DTW
NorthAmerica
NA
Central
Chicago
Chicago
Chicago
Chicago
ORD
NorthAmerica
NA
Central
ORD
NorthAmerica
NA
Central
ORD
NorthAmerica
NA
Central
ORD
As shown in the figure above, we can see two things:
• First, we see that the irst record in the data ile is a header record, which
usually describes something about the data file itself such as the column
names. This can be skipped by setting
1
in the
Number of lines to skip
in
the
Header
section of the
Data Source Properties
as shown in the screenshot.
Then click on
OK
.
