Abstract

Using a simplified financial reporting example, we examine how traditional data warehouses are put together. We then propose an improved method for creating data warehouses: using the categorical query language CQL. Finally we demonstrate how CQL enables the early identification of and solution to many common data warehousing problems, reducing the risk of failure and increasing project implementation speed.