Analysis (MDDA) refers to the process of
summarizing data across multiple levels (called
dimensions) and then presenting the results in a
multi-dimensional grid format. This process is
also referred to as OLAP, Data Pivot., Decision
Cube, and Crosstab.
component can be used to perform MDDA. Three
types of dimensions can be defined:
and Value. Column and Row dimensions are used to
define summarization levels and Value dimensions
are used to specify calculations.
The process of MDDA is best
explained via an example. Suppose that our dataset
contains the following sales information:
The Crosstab component can be
used to produce a grid showing the total, average
and number of sales summarized by state for each
month. The output of the report is shown below.