1 . | Use a different technique to associate logical columns
with logical levels. Drag the logical columns from the Time Detail
logical level (not from the D1 Time logical table) to their
corresponding levels in the H1 Time logical dimension. This is a
convenient technique when logical columns are buried deep in the
business model.
|
|||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 . | Delete all remaining columns from the Time Detail level except for Calendar Date so that only Calendar Date
is associated with the Time Detail level. Notice that deleting objects
from the hierarchy does not delete them from the logical table in the
business model. |
|||||||||||||||||||||
3 . | Set the logical keys for the H1 Time logical dimension according to the following table:
|
Create a Logical Dimension for Customer
1 . | Use either technique to create a logical dimension with a level-based hierarchy named H3 Customer
for the D3 Customer logical table with the following levels, columns,
and keys. Hint: Create the levels first, then double-click a logical
column to open the Logical Column dialog box and use the Levels tab to
associate the logical column with a logical level.
Set Customer Number as the primary key for the Customer Detail level. Your results should look similar to the screenshot: |
---|
No comments:
Post a Comment