Microsoft Office Tutorials and References
In Depth Information
Figure 1-39. SSAS Dimension Wizard
Choose the attributes Month Name, Quarter, and Year in our sample, and change the
attribute types to Month, Quarter, and Year, respectively, as shown in Figure 1-39 .
Provide a logical name for the dimension (Dim_Date in our case), and click Finish.
This creates the Dim_Date.dim dimension in the Dimensions folder in your project.
In Solutions Explorer, right-click the Cubes folder and choose New Cube to bring up the
Cube Wizard welcome screen. Click Next.
On the Select Creation Method screen, choose “Use existing tables” and then click Next.
From the available “Measure group tables” list, select the fact table or click the Suggest
button. (See Figure 1-40 .)
Search JabSto ::