Home > Articles > Data > SQL Server

  • Print
  • + Share This
Like this article? We recommend

Reprocessing the Cube to Include Drillthrough

We will now reprocess the cube to make our drillthrough enhancements permanent.

  1. Select the Tools top menu item.

  2. Select Process Cube on the cascading menu, as shown in Figure 8.

    Figure 8Figure 8 Select Process Cube (circled in red).

We can also click the Process Cube button (shown in Figure 9) to accomplish the same thing.

Figure 9Figure 9 Process Cube button.

We receive another warning about saving the cube (unless we made it a special point to save it after our changes and immediately before the last step.)

  1. Click OK.

A dialog box appears, warning us about aggregations and giving us the opportunity to take advantage of the Storage Wizard to help us with the aggregation design process. The dialog box appears in Figure 10.

Figure 10Figure 10 "Just say no" to Storage Design.

  1. Click No to continue.

    The Process a Cube dialog box appears. Here we can select from three processing options:

    • Incremental update
    • Refresh data
    • Full Process

We are also given the option to incrementally update the dimensions of this cube, as well as to specify additional cube-processing options. We will select Full Process and leave all else as-is, as shown in Figure 11.

Figure 11Figure 11 Select Full Process.

  1. Select the Full Process radio button.

  2. Click OK.

The cube begins processing, displaying a Process log window. Once it has finished, a green message across the bottom of the log window indicates this, as shown in Figure 12.

Figure 12Figure 12 Processing was completed successfully.

  1. Click Close on the Process log window.

  • + Share This
  • 🔖 Save To Your Account