Database Reference
In-Depth Information
Figure 11-30.
Browsing the DimAuthors dimension
As we conclude this exercise, review the values in the report to make sure they are accurate. We provided some
SQL code for this in Listing 11-1, but for now we will assume that all are correct and move on to our next topic.
in this exercise, you made changes to the cube using the Cube Structure tab and the Dimension Usage tab.
You then processed the cube and verified that the changes were successful using the browser tab. Next we
focus on the other tabs that come with the cube designer.
The Calculations Tab
The Calculations tab enables you to create named MDX expressions, also known as
calculated members
. Typically
these calculated members are used to create additional measures, but they can also be used to create additional
dimensional attributes.
An example of an additional measure is acquiring the total price of an individual sale by multiplying the
quantity by the price of the product. An additional dimensional member example is combining countries into
groups such as combining Mexico, Canada, and the United States into one member called North America.
The Calculations tab consists of three basic sections: the Script Organizer and Calculation Tools panes
on the left side of your screen and the script-editing area on the right (Figure
11-31
).
