Recoverability
An OLAP server, if it crashes, should be able to recover without corrupting the aggregated cubes, view designs, reports, queries, Meta data etc.
Restart Point
If an OLAP server is in the refresh mode OR is in the process of distribution of reports, any crash and shutdown should not force the administrators from the zero point. It should grace-fully re-start from last checkpoint.
Notifications
Just like any transaction system, the batch processing of refresh and distribution of information should be done along with notification of exceptions in form of emails OR SMS.
Data loss
Even if views, reports, Meta data etc. are corrupted, the same should be able to built using the logs OR the back-ups.
Logs
Detailed logs of system activities in terms of data, sequence, start time-end time; messages, counts etc., should be maintained.
|
