Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Considering DISTINCT COUNT
6. Right-click on the Warehouse sample cube.
7. Select Edit from the context menu that appears, as shown in Figure 3.
Figure 3: Select Edit from the Context Menu
The Cube Editor opens. The Schema tab appears as depicted in Figure 4.
Figure 4: Cube Editor – Schema Tab for the Warehouse Sample Cube
We will be creating a measure in the Cube Editor to enable us to make our distinct Product counts. Distinct Count can only exist within the context of a measure.
8. Right-click the Measures folder in the Tree View to the left of the Schema tab.
A single-line context menu appears, as shown in Figure 5.
9. Select New Measure from the context menu.
Figure 5: Select New Measure from the Context Menu
The Insert Measure dialog appears.
10. Click-select product_id.
The Insert Measure dialog, selected measure circled in red, appears in Figure 6.
Figure 6: Select Product_Id from the Insert Measure Dialog