Databases Reference
In-Depth Information
Figure 5-8
7. As shown in Figure 5-9 , the Dimension Wizard selects the columns
of all the table(s) that have been selected for the dimension you're
creating. Each selected column on this screen results in an equival-
ent attribute being created in the new dimension. Even though you
are building a dimension here, this dimension is going to be part of a
cube (which is described by the Unified Dimensional Model). The
UDM combines the best of the relational and OLAP worlds — one of
the important uses of the relational model is the ability to query each
column for reporting purposes. The columns in the relational table
are transformed to attributes of a dimension that can then be used
for querying from the UDM. Select all the attributes and click Next.
 
 
Search WWH ::




Custom Search