Microsoft Office Tutorials and References
In Depth Information
Repeat the same steps for the rest of the dimensions, and click Save All. Refresh the
window, and notice that all columns now appear under attributes and have been added to
To add hierarchies, drag and drop the attribute or attributes from the Attributes pane to
the Hierarchies pane. Repeat the step for all of the dimensions. When you’re done, go back
to the Cube Structure window.
On the left in the Measures pane, you now have only one measure—Fact Sales Order
Details Count. To create more measures, simply right-click on the Measures window and
choose New Measure.
From the New Measure dialog box, select the option “Show all columns.”
For the Usage option, select Sum as the aggregation function. Then choose
Dim_SalesTerritory as the Source Table and SalesYTD as Source Column, and click OK.
This provides a new measure, Sales YTD, by summing the values from a given territory
against the available dimensions.
All is well at this time. Your final window looks something like what’s shown in Figure 1-45 .
Figure 1-45. The AW Sales Data Project sample
Now right-click the project properties and check the deployment options. Leaving the
options as is deploys the project to the local SQL Server. Right-click the project properties
again, and select Deploy.
Search JabSto ::