Chapter 4 Building Multidimensional Diagrams


Why build a multidimensional diagram?

The multidimensional diagram is used to design the cubes in an OLAP engine, together with the different analysis dimensions.

Business analysts use OLAP databases to send queries and retrieve business information from the different dimensions existing in the database.

Multidimensional analysis queries usually involve calculated lists, such as growth and decline rates and time-based comparisons. They aim at detecting trends and relationships. These types of queries are supported by an OLAP database, but not by an operational database.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.