Database Reference
In-Depth Information
Figure 3.16 Final introspection step.
5. Select the desired dimension tables and click Next . Studio preselects what it
believes to be the dimension tables based on the keys/joins to the fact table. you
can either keep these selections or select new tables.
6. Accept, add, or edit the hierarchies and click Finish (Figure 3.16).
3.5 BuilDing hierarChies anD Custom noDes
once you have the data sources completely defined, the next step is to create dimen-
sion elements and hierarchies. In general, the process of setting up both types of
objects is simple. Dimension objects at their core are simply columns from tables or
text files. hierarchies are simply combinations of those elements. The most interesting
tips and tricks when working with Studio center on the creation and use of elements
and hierarchies.
3.5.1 Capabilities of Functions
one of the least used capabilities of Studio is Common Platform Language (CPL) func-
tions. CPL functions enable a host of features within Studio around creation unique and
dynamic hierarchies.
The simplest CPL functions are evident when extracting date-time elements from
a column with a relational date-time stamp that should not be confused with a date-
time hierarchy type. Figure 3.17 shows how right clicking on a date-time column allows
the selection of the option Create Date Elements .
once the date elements are created, the resultant nodes are essentially custom nodes
created with CPL functions. For instance, Figure  3.18 is an example of the Quarter
dimension element created using the right-click shortcut.
Search WWH ::




Custom Search