Databases Reference
In-Depth Information
tABle 14.12
Market Basket Analysis BI View with Entities
Driver
Entity
Key
Corr
Entity
Key
Driver
Quantity
Sum
Driver
Dollars
Sum
Driver
Count
Sum
Corr
Quantity
Sum
Corr
Dollars
Sum
Corr
Count
Sum
Quantity
Ratio
Dollars
Ratio
Count
Ratio
1124
6543
7
$50.12
3
7
$92.28
3
100.0000%
184.1181%
100.0000%
1124
9792
7
$50.12
3
8
$85.16
3
114.2857%
169.9122%
100.0000%
6543
1124
9
$117.02
4
7
$50.12
3
77.7778%
42.8303%
75.0000%
6543
9792
9
$117.02
4
9
$102.03
4
100.0000%
87.1902%
100.0000%
9792
0
11
$132.65
5
0
$0.00
1
0.0000%
0.0000%
20.0000%
9792
1124
11
$132.65
5
7
$50.12
3
63.6364%
37.7836%
60.0000%
9792
6543
11
$132.65
5
9
$117.02
4
81.8182%
88.2171%
80.0000%
