System health and maintenance

This section explains the actions required to perform a health check on an OLAP database.

Check application logs for errors or warnings.
Check possible performance issues by looking for long-lasting operations.
Check the save, backup, and restore procedures.
Ensure data integrity and verify cube structures by examining potential plausibility issues.
Example of a plausibility issue:

High-level summaries, such as total sales, may hide underlying fraudulent, or erroneous transactions. If the underlying data is unreliable, the aggregated number is misleading.
Test the user access and security settings.