Creating an OLAP Cube

1. To create an OLAP Cube, from the menus choose:

   Analyze > Reports > OLAP Cubes...

   

2. Select Months with service, Age in years, Household income in thousands, # of available services, and Average monthly expense as the summary variables.
3. Select Churn within last month and Geographic indicator as the grouping variables.
4. Click Statistics.

   

5. Deselect Sum, Percent of Total Sum, and Percent of Total N from the Cell Statistics list.
6. Select Median and add it to the Cell Statistics list.
7. Click Continue.
8. Click Title in the OLAP Cubes dialog box.

   

9. Type Descriptive Statistics as the title.
10. Type By Customer Churn and Geographic Region as the caption.
11. Click Continue, and then click OK in the OLAP Cubes dialog box.