Based on the collected data, a data warehouse has been constructed with sixteen
dimensions and an initial set of fact tables for data cube design and exploration.
2 6 Missaoui, Jatteau, Boujenoui, & Naouali
Copyright ?© 2007, Idea Group Inc. Copying or distributing in print or electronic forms without written permission of
Idea Group Inc. is prohibited.
The left-hand side (LHS) of Table 1 is a fact table which provides the number of
enterprises (NbEntr) according to three dimensions: duality, internal, and govern,
while the right-hand side (RHS) gives AvgAsset, a codification of the average company
asset according to the same set of dimensions. The value of AvgAsset is 1 when
the average asset is less than 1,000K and 2 otherwise. When Duality is set to 1,
this means that the CEO is also the board chairman. Dimension Internal represents
the proportion of Top Management sitting on the board, and its possible values are
1 (proportion < 10%), 2 (?‰? 10 and < 25%), and 3 (?‰? 25%). Govern expresses the
index of corporate governance quality (or simply quality index) and takes one of
the following values (from bad to good quality): 1 (quality < 40%), 2 (?‰? 40 and <
70%), and 3 (?‰? 70%).
Background
In this section, we first provide some background on data warehousing and OLAP
techniques. Then, we recall basic notions about the framework we use to identify
Fact ID Duality Internal Govern AvgAsset
1 0 1 2 2
2 0 1 3 2
3 0 2 1 1
4 0 2 2 2
5 0 2 3 2
6 0 3 2 1
7 0 3 3 1
8 1 1 2 2
9 1 1 3 2
10 1 2 1 1
11 1 2 2 2
12 1 2 3 2
13 1 3 1 1
14 1 3 2 2
15 1 3 3 1
Fact ID Duality Internal Govern NbEntr
1 0 1 2 23
2 0 1 3 20
3 0 2 1 1
4 0 2 2 50
5 0 2 3 23
6 0 3 2 16
7 0 3 3 3
8 1 1 2 4
9 1 1 3 4
10 1 2 1 1
11 1 2 2 32
12 1 2 3 3
13 1 3 1 2
14 1 3 2 30
15 1 3 3 4
Table 1.
Pages:
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481