Process the Analysis Services Database to Update Structure for Our Discretization Settings
We will process the Analysis Services database within
which we have been working, and then browse the Sick Leave Hours attribute
members to confirm that we have provided preliminary answers to the client’s
stated requirements.
1.
Right-click
the Analysis Services project atop the tree in the Solution Explorer.
2.
Select Process
... from the context menu that appears, as shown in Illustration 9.
Illustration 9: Select Process ... to Process the Analysis Services Project
3.
Click Yes on
the dialog telling us that the server content appears out of date, and asking
if we would like to build and deploy the project first, which appears as
depicted in Illustration 10.
Illustration 10: Click Yes to Build and Deploy the Project First ...
Information updates on the server, and then the Process
Database dialog appears, as shown in Illustration 11.
Illustration 11: The Process Database Dialog Appears ...
4.
Click the Run
button on the dialog.
The Process
Progress viewer appears, and generates periodic status updates for various
processing events. When processing is complete, we see a Process succeeded
message appear in the Status bar in the lower part of the viewer, as depicted
in Illustration 12.
Illustration 12: Process Succeeded Massage Appears ...
5.
Click the Close
button on the Process Progress viewer to dismiss the viewer.
6.
Click the Close
button on the Process Database dialog to dismiss the dialog.
We are now ready to return to the Dimension Designer
browser to examine the results of our handiwork.
Browse the Newly Discretized Attribute with the Dimension Browser
1.
Click the Browser
tab in the Dimension Designer.
2.
Ensure that Sick
Leave Hours remains selected in the Hierarchy selector atop the Browser tab.
3.
Click the Reconnect
button atop the tab, as shown in Illustration 13.
Illustration 13: Partial Browser View - before Reconnecting
The browser details update, and (assuming the All
Employees level remains expanded in the browser), we see ten groups appear, as
depicted in Illustration 14.
Illustration 14: The Discretized Attribute Member’s Groups
We see
the groups appear, as expected. Ten groups have been created, based upon the
algorithm selected by the Clusters discretization method.
» 
Comment and Contribute
