Download Elixir Data Designer User Manual

Composite DataSources
and a State can't belong to more than one Country. "Year/Month" is not a valid hierarchy, because
"January" can occur in many years.
Figure 4.46. Add Hierarchy
On clicking the Next button, in the Cube Wizard appears as shown in Figure 4.47, “Cube Axes Screen”.
In this screen, the Column dimensions and Row dimensions can be added. The elements that are added
in the Column dimension windows will be displayed as the column fields in the output table. The
elements that are added in the Row dimensions window will be displayed as the row fields in the output
table. The hierarchy column added in the first screen can be made use of in this screen as a row or
column field. Use of a hierarchy is more efficient, as the system relies on the strict definition of each
child only having one parent. However an incorrect use of hierarchy, as illustrated by "Year/Month"
above will usually yield incorrect results.
Figure 4.47. Cube Axes Screen
60