Databases Reference
In-Depth Information
tABle 7.8
Market Basket Analysis BI View with Correlation Hierarchy
Driver
Object
Key
Driver
Quantity
Sum
Driver
Dollars
Sum
Driver
Count
Sum
Corr
Quantity
Sum
Corr
Dollars
Sum
Corr
Count
Sum
Hierarchy
Key
Quantity
Ratio
Dollars
Ratio
Count
Ratio
15
0
3
$45.93
2
0
$0.00
1
0.0000%
0.0000%
50.0000%
15
1124
3
$45.93
2
5
$56.21
1
166.6667%
122.3819%
50.0000%
15
6543
3
$45.93
2
2
$24.58
1
66.6667%
53.5162%
50.0000%
16
1124
3
$36.63
2
5
$56.21
1
166.6667%
153.4535%
50.0000%
16
9792
3
$36.63
2
4
$48.80
2
133.3333%
133.2241%
100.0000%
43
1124
4
$57.28
2
2
$15.89
1
50.0000%
27.7409%
50.0000%
43
9792
4
$57.28
2
4
$44.14
2
100.0000%
77.0601%
100.0000%
57
1124
3
$27.27
2
2
$15.89
1
66.6667%
58.2692%
50.0000%
57
6543
3
$27.27
2
7
$94.07
2
233.3333%
344.9578%
100.0000%
64
1124
2
$24.74
2
5
$56.21
1
250.0000%
227.2029%
50.0000%
64
9792
2
$24.74
2
4
$48.80
2
200.0000%
197.2514%
100.0000%
78
6543
5
$67.20
2
5
$67.54
2
100.0000%
100.5060%
100.0000%
78
9792
5
$67.20
2
4
$56.58
2
80.0000%
84.1964%
100.0000%
87
1124
1
$16.87
1
2
$15.89
1
200.0000%
94.1909%
100.0000%
87
6543
1
$16.87
1
3
$42.96
1
300.0000%
254.6532%
100.0000%
98
6543
2
$4.90
2
5
$67.54
2
250.0000%
1378.3673%
100.0000%
98
9792
2
$4.90
2
4
$56.58
2
200.0000%
1154.6939%
100.0000%
