Advanced Dimension Design - Professional SQL Server Analysis Services 2005 with MDX - page 359

2. Launch the Business Intelligence Wizard from the menu
Cube → Add Business Intelligence or by clicking on the Add Busi-
ness Intelligence icon (first icon in the Cube Structure tab). If
you see the Welcome screen press next.
3. In the Choose Enhancement page select Define time intelligence
as shown in Figure 8-32 .
Figure 8-32
4. In the Choose Target Hierarchy and Calculation page you need to select
the calculations as well as hierarchy in Time dimension that is expected
to use the calculations. In the drop down list box for Use the following
hierarchy to analyze time calculations you will see the four Time dimen-
sions Dim Time, Order Date, Delivery Date, and Ship Date. All these cube
dimensions are role playing dimensions of the database dimension Dim
Time. Select the multi-level hierarchy in the cube dimension Order Date as
shown in Figure 8-33 . Select the calculations Year to Date, Year Over Year
Growth, and Year Over Year Growth % and press Next.