How to process a cube
SQL Server 2000
To process a cube
- In the Analysis Manager tree pane, under the database that contains the cube, expand the Cubes folder.
- Right-click the cube, and then click Process.
- In the Process a Cube dialog box, click Full Process, and then click OK.
- In the Process dialog box, wait for the cube to finish processing, or click Stop to halt and cancel processing.
After processing completes, but before you close the Process dialog box, you can view the SQL statement used to process the cube.
Note Newly processed cubes are visible to end users only after they reconnect to the server computer.