Table of contents
TOC
Collapse the table of content
Expand the table of content

Refresh OLAP data cube information in Service Manager

Bill Anderson|Last Updated: 3/13/2017
|
1 Contributor

Applies To: System Center 2016 - Service Manager

You can use the following procedures in Service Manager to refresh data in a Microsoft Online Analytical Processing (OLAP) data cube and then validate that it was refreshed. By default, most OLAP data cubes are refreshed every 24 hours. However, you can manually refresh the data to ensure that you are accessing the latest information from the data warehouse.

If necessary, you can also manually process an OLAP data cube outside of the processing job.

To refresh OLAP data cube information using the Service Manager console

  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 that the OLAP data cube was refreshed in the Service Manager console

  • 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.

To manually refresh OLAP data cube information

  • Run the following script for the OLAP data cube of your choice.

    Update etl.CubePartition set  
    
    watermarkbatchid = 0  
    
    where cubename = 'ComputerCube'  
    
© 2017 Microsoft