Intermediate measure 136,871 group aggregation size Intermediate measure 39% group aggregation reduction in size compared to fact size 2 Data measure group fact 14,839 40,522 368,548 425,369 size Data measure group 36,600 322,247 378,106 13,356 aggregation size Data measure group 10% 10% 13% 11% aggregation reduction in size compared to fact size Intermediate measure 9,881 16,502 159,701 197,263 group fact size Intermediate measure 4,576 7,807 87,524 116,768 group aggregation size Intermediate measure 54% 53% 45% 40% group aggregation reduction in size compared to fact size 3 Data measure group fact 9,603 42,570 393,858 472,568 size Data measure group 527 1,123 9,024 11,409 aggregation size Data measure group 95% 97% 98% 98% aggregation reduction in size compared to fact size Intermediate measure 4,093 group fact size Intermediate measure 1,704 group aggregation size Intermediate measure 58% group aggregation reduction in size compared to fact size Intermediate Intermediate measure 98% measure group fact size reduction group size between cube design 1 comparison and 3
Intermediate measure group aggregation size 136,871 Intermediate measure group aggregation reduction in size compared to fact size 39% 2 Data measure group fact size 14,839 40,522 368,548 425,369 Data measure group aggregation size 13,356 36,600 322,247 378,106 Data measure group aggregation reduction in size compared to fact size 10% 10% 13% 11% Intermediate measure group fact size 9,881 16,502 159,701 197,263 Intermediate measure group aggregation size 4,576 7,807 87,524 116,768 Intermediate measure group aggregation reduction in size compared to fact size 54% 53% 45% 40% 3 Data measure group fact size 9,603 42,570 393,858 472,568 Data measure group aggregation size 527 1,123 9,024 11,409 Data measure group aggregation reduction in size compared to fact size 95% 97% 98% 98% Intermediate measure group fact size 4,093 Intermediate measure group aggregation size 1,704 Intermediate measure group aggregation reduction in size compared to fact size 58% Intermediate measure group size comparison Intermediate measure group fact size reduction between cube design 1 and 3 98%