17. Click OK to
accept the selection.
Measure dialog closes, and we see the new measure appear (default name of Customer
Id: the underscore character is removed) in the Measures folder.
in the Measures folder, if required.
click the downward arrow beneath the Cube Tree to open the Properties
Click the Basic
default Name of Customer Id to the following:
following into the empty Description box, just below the Name
Distinct Count - Customers
Click the box
to the right of the Aggregate Function property label (at the bottom of
the Basic tab), to enable the selector.
Count in the Aggregate Function selector.
The Basic tab of the Properties pane
appears, with our modifications, as shown in Illustration 12.
Distinct Customers Measure - Properties Pane - Basic Tab
Click the Advanced
tab of the Properties pane.
Ensure that Big
Integer is selected for the Data Type property, as depicted in Illustration
13: Distinct Customers Measure -
Properties Pane - Data Type Tab
the Unit Sales measure in the Measures folder.
from the context menu that appears, as shown in Illustration 14.
14: Select Delete from the Context Menu
Measure Delete dialog appears, as depicted in Illustration 15.
15: Confirm Measure Delete Dialog
Sales measure disappears from the Measures folder.
Perform steps 27
through 29 above for all members of the Measures folder, except
the new one we created above, Distinct Customers.
cube will have no measures except the DISTINCT COUNT measure we have
created. The idea here is that, once we have finished designing our new cube,
it will contain only this single measure and an identical set of dimensions to
those found in the cube whose performance we are intent upon improving (in the
case of our exercise, the Sales sample cube). It is far simpler, since
our Sales cube has already been designed, to clone it, as we have, and
eliminate the unwanted objects to achieve our ends, than to build a new
cube from scratch. We are also assured, using this approach, that the
dimensions will, indeed, precisely mirror those in the original Sales cube,
a requirement important to our achieving success.
clear out any remaining, unneeded objects in the DISTINCT cube.
Expand the Calculated
Members folder below the Measures folder in the cube tree, if
Using the same
approach taken with each of the measures we deleted above, delete each of the
Expand the Actions
folder below the Measures folder in the cube tree, if necessary.
Using the same
approach taken with each of the measures we deleted above, delete any actions
cube is now prepared structurally for its intended use. Let's process the cube
to activate our changes, and to finalize its preparation for its role in
optimizing distinct count operations.
--> Process Cube to initialize the processing
steps, as shown in Illustration 16.
Initiating Cube Processing ...
the Cube dialog appears, informing us that the cube must be saved before we
to allow processing to proceed, as depicted in Illustration 17.
Illustration 17: Save
the Cube Dialog
box appears, stating that the cube has no aggregations, and asking if we wish
to design them at this time, as shown in Illustration 18.
Aggregations Message Box - Just Say "No"
to skip designing aggregations at present.
the Processing Method dialog appears.
Processing is the
default, and only, option, as the cloned cube has not been processed
since the structural changes we have made to it.
the Processing Method dialog appears, as depicted in Illustration 19.
Illustration 19: The Select
the Processing Method Dialog
settings at default, click OK.
Processing begins, and runs rapidly, as
evidenced by the Process viewer's presentation of processing log events
in real time. The Processing cycle ends and the success of the
evolution is indicated by the appearance of the Processing Completed
Successfully message (in green letters) at the bottom of the viewer, as
shown in Illustration 20.
Indication of Successful Processing
returned to the Cube Editor. We can now browse the data and see our new
Distinct Customers measure in action.
Click the Data
tab, if necessary.
refreshed Data View, data appears in the default formation, ready for
manipulation and review, although we stop here only to view our handiwork. The
Data View, depicting the Distinct Customers measure, appears in Illustration
Illustration 21: Our New
Distinct Customers Measure in the Data View
have a processed cube, consisting of dimensions identical to those that exist
in the Sales cube, together with the single distinct count
measure, Distinct Customers, that we have created to store our distinct
customer count information. We are ready to leave the new cube, and to move to
the next step of integrating it into our overall solution for enhancing
performance of distinct counts in our Sales data.
--> Exit from the main menu.
Editor closes, and we are returned to Analysis Manager.