Database Reference
In-Depth Information
a
Fiscal
Quarter
QuarterNo
...
FiscalYear
FiscalYear
...
Time
Month
Date
...
MonthName
...
Calendar
Quarter
QuarterNo
...
CalendarYear
CalendarYear
...
b
Calendar
Year 2011
Calendar
time
Calendar
Q1 2011
Calendar
Q2 2011
...
...
Jan 2011
Feb 2011
Mar 2011
Apr 2011
May 2011
Jun 2011
Fiscal
time
Fiscal
Q1 2011
Fiscal
Q2 2011
...
Fiscal
Year 2011
Fig. 4.9
An alternative hierarchy. (
a
)Schema.(
b
) Examples of instances
Category
CategoryName
Description
...
Department
DepartmentName
Description
...
Product
ProductNumber
ProductName
Description
Size
DistributorName
...
DistributorDivision
DistributorRegion
DivisionName
Responsible
...
RegionName
Area
...
Fig. 4.10
An example of parallel independent hierarchies
parallel dependent hierarchies given in Fig.
4.11
represent a company that
requires sales analysis for stores located in several countries. The hierarchy
StoreLocation
represents the geographic division of the store address, while
the hierarchy
SalesOrganization
represents the organizational division of the
company. Since the two hierarchies share the
State
level, this level plays
different roles according to the hierarchy chosen for the analysis. Sharing
Search WWH ::
Custom Search