Databases Reference
In-Depth Information
tABle 7.10
Market Basket Analysis BI View with Driver Hierarchy
Driver
Quantity
Sum
Corr
Quantity
Sum
Corr
Count
Sum
Hierarchy
Key
Corr
Object Key
Driver
Dollars Sum
Driver
Count Sum
Corr
Dollars Sum
Quantity
Ratio
Dollars
Ratio
Count
Ratio
1124
15
7
$72.10
2
2
$30.62
1
28.5714%
42.4688%
50.0000%
1124
16
7
$72.10
2
1
$12.21
1
14.2857%
16.9348%
50.0000%
1124
43
7
$72.10
2
3
$42.96
1
42.8571%
59.5839%
50.0000%
1124
57
7
$72.10
2
1
$9.09
1
14.2857%
12.6075%
50.0000%
1124
64
7
$72.10
2
1
$12.37
1
14.2857%
17.1567%
50.0000%
1124
87
7
$72.10
2
1
$16.87
1
14.2857%
23.3981%
50.0000%
6543
15
9
$118.65
3
2
$30.62
1
22.2222%
25.8070%
33.3333%
6543
57
9
$118.65
3
3
$27.27
2
33.3333%
22.9836%
66.6667%
6543
78
9
$118.65
3
5
$67.20
2
55.5556%
56.6372%
66.6667%
6543
87
9
$118.65
3
1
$16.87
1
11.1111%
14.2183%
33.3333%
6543
98
9
$118.65
3
2
$4.90
2
22.2222%
4.1298%
66.6667%
9792
0
7
$90.07
4
0
$0.00
1
0.0000%
0.0000%
25.0000%
9792
16
7
$90.07
4
3
$36.63
2
42.8571%
40.6684%
50.0000%
9792
43
7
$90.07
4
4
$57.28
2
57.1429%
63.5950%
50.0000%
9792
64
7
$90.07
4
2
$24.74
2
28.5714%
27.4675%
50.0000%
9792
78
7
$90.07
4
5
$67.20
2
71.4286%
74.6086%
50.0000%
9792
98
7
$90.07
4
2
$4.90
2
28.5714%
5.4402%
50.0000%
