You can use the following procedure to refresh data in an OLAP data cube. By default, most OLAP data cubes are refreshed every 5 minutes. However, you can manually refresh the data to ensure you’re accessing the latest information from the data warehouse.

To refresh OLAP data cube information

  1. In the Service Manager console, click Data Warehouse, expand it, and then click Cubes.

  2. In the Cubes pane, select a cube name, and then under Tasks, click Process Cube.

  3. Click OK to close the Process Cube dialog box.

To validate OLAP data cube refresh

  1. Select an OLAP data cube and verify that the date and time information under Last Processed Date has been updated since you processed the cube and that the cube Status is listed as Processed.