Refreshing Data Cubes

Vision data cubes must be refreshed (updated with current data from the Vision transactional database) on a regular basis. By default, the refresh process occurs automatically every night at midnight. A Vision system administrator can modify the time that the automatic refresh occurs or perform additional refreshes on demand using with Microsoft SQL Server Management Studio.

The time it takes to rebuild the data warehouse and refresh the data cubes depends on many factors, such as hardware and server settings. The rebuild process has been performance-tuned to process as quickly as possible.

What happens to existing reports that contain dimensions that have had name changes?

Existing reports that contain a dimension that had its name changed must be refreshed. Then, you must re-add the dimension, with the new name, to the report design.

Example: A report contains the dimension named Vendor, and your system administrator changes the label from Vendor to Consultant. After you refresh the report, the dimension named Vendor is removed from the report, and the name Consultant does not replace it. You must select Consultant from the PivotTable Field List to re-add it to the report.