Database Reference
In-Depth Information
11.
Note how the diagram on the left side of this dialog window describes the
relationships between the dimensions and the measure groups using symbols.
12.
Click oK to close the Define Relationship dialog window.
13.
Verify that the Dimension Usage tab displays, as shown in Figure
11-29
.
Figure 11-29.
The Dimension Usage tab after configuration
14.
Note how the icons now indicate nonregular relationship types.
Verify Your Design with the Browser Tab
Now that we have made our changes, let's process the cube and then use the browser tab to verify that our
design is correct.
1.
Right-click the cube file in Solution Explorer called
DWPubsSalesVer1.cube
and
choose Process from the context menu.
2.
if a message box appears indicating that changes need to be uploaded to this
deployment, click Yes to accept deployment and then Yes to accept your changes
overwriting the existing cube. The Process Cube dialog window will appear.
3.
Click Run to start the processing. When processing completes, click Close to close
the processing windows.
4.
Click the browser tab in the cube designer window.
5.
Drag and drop measures and dimensions from the treeview to create a result that
looks like the one displayed in Figure
11-30
.
