OLAP system should not impose any artifi cial restrictions on the number of dimensions or
aggregation levels.
In addition to these 12 rules, a robust production-quality OLAP system should also support com-
prehensive database management tools, the ability to drill down to detail level, incremental
database refresh and SQL interface.
15.5.1 OLAP Tools
OLAP tools are based on the concepts of multi-dimensional databases and allow a sophisticated
user to analyse the data using elaborate, multi-dimensional, complex views. There are three main
categories of OLAP tools, known as multi-dimensional OLAP (MOLAP or MD-OLAP ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.