Database Reference
In-Depth Information
Fig. 5.32
Browsing the Northwind cube in Excel
5.10 Definition of the Northwind Cube in Mondrian
Mondrian is an open-source relational online analytical processing (ROLAP)
server. It is also known as Pentaho Analysis Services and is a component of
the Pentaho Business Analytics suite. In this section, we describe Mondrian
4.0, which is the latest version at the time of writing this topic.
In Mondrian, a
cube schema
written in an XML syntax defines a mapping
between the physical structure of the relational data warehouse and the
multidimensional cube. A cube schema contains the declaration of cubes,
dimensions, hierarchies, levels, measures, and calculated members. A cube
schema does not define the data source; this is done using a JDBC connection
string. We give next the overall structure of a cube schema definition in
Mondrian using the Northwind cube:
<
Schema name=
'
NorthwindDW
'
metamodelVersion=
'
4.0
'
1
description=
'
Sales cube of the Northwind company
'
>
2
<
PhysicalSchema
>
3
...
4
<
/PhysicalSchema
>
5
<
Dimension name=
'
Time
'
table=
'
Time
'
...
>
6
...
7
<
/Dimension
>
8
<
Cube name=
'
Sales
'
>
9
<
Dimensions
>
10
...
11
<
/Dimensions
>
12
Search WWH ::
Custom Search