SELECT fact_1_id, fact_2_id, fact_3_id, SUM(sales_value) AS sales_value FROM dimension_tab GROUP BY CUBE (fact_1_id, fact_2_id, fact_3_id) ORDER BY fact_1_id, fact_2_id, fact_3_id; FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 1 1 1 381.61 1 1 2 235.29 1 1 3 270.7 1 1 4 634.05 1 1 5 602.36 1 1 6 538.41 1 1 7 245.87 1 1 8 435.54 1 1 9 506.59 1 1 10 513.13 1 1 4363.55 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 1 2 1 370.97 1 2 2 259.31 1 2 3 509.68 1 2 4 668.64 1 2 5 614.99 1 2 6 298.12 1 2 7 466.98 1 2 8 479.95 1 2 9 575.89 1 2 10 550.23 1 2 4794.76 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 1 3 1 607.06 1 3 2 470.61 1 3 3 514.79 1 3 4 367.72 1 3 5 415.19 1 3 6 390.99 1 3 7 440.98 1 3 8 642.67 1 3 9 461.13 1 3 10 407.11 1 3 4718.25 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 1 4 1 834.37 1 4 2 471.72 1 4 3 339.45 1 4 4 337.9 1 4 5 409.88 1 4 6 719.47 1 4 7 390.67 1 4 8 595.08 1 4 9 890.73 1 4 10 398.18 1 4 5387.45 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 1 5 1 543.39 1 5 2 417.36 1 5 3 456.34 1 5 4 596.86 1 5 5 548.51 1 5 6 559.91 1 5 7 295.35 1 5 8 799.8 1 5 9 344.41 1 5 10 465.41 1 5 5027.34 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 1 1 2737.4 1 2 1854.29 1 3 2090.96 1 4 2605.17 1 5 2590.93 1 6 2506.9 1 7 1839.85 1 8 2953.04 1 9 2778.75 1 10 2334.06 1 24291.35 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 2 1 1 838.08 2 1 2 252.93 2 1 3 989.74 2 1 4 736.87 2 1 5 895.58 2 1 6 559.87 2 1 7 334.42 2 1 8 346.8 2 1 9 379.27 2 1 10 319.28 2 1 5652.84 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 2 2 1 466.31 2 2 2 648.44 2 2 3 262.44 2 2 4 343.78 2 2 5 331.71 2 2 6 594.96 2 2 7 707.46 2 2 8 512.56 2 2 9 170.11 2 2 10 545.25 2 2 4583.02 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 2 3 1 812.17 2 3 2 488.23 2 3 3 840.21 2 3 4 447.27 2 3 5 759.4 2 3 6 646.82 2 3 7 202.86 2 3 8 489.98 2 3 9 351.16 2 3 10 517.67 2 3 5555.77 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 2 4 1 681.29 2 4 2 771.78 2 4 3 300.61 2 4 4 669.27 2 4 5 914.13 2 4 6 705.48 2 4 7 296.23 2 4 8 557.92 2 4 9 618.33 2 4 10 421.63 2 4 5936.67 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 2 5 1 714.84 2 5 2 686.56 2 5 3 579.5 2 5 4 336.87 2 5 5 215.17 2 5 6 268.72 2 5 7 667.22 2 5 8 451.29 2 5 9 365.24 2 5 10 223.33 2 5 4508.74 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 2 1 3512.69 2 2 2847.94 2 3 2972.5 2 4 2534.06 2 5 3115.99 2 6 2775.85 2 7 2208.19 2 8 2358.55 2 9 1884.11 2 10 2027.16 2 26237.04 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 1 1 1219.69 1 2 488.22 1 3 1260.44 1 4 1370.92 1 5 1497.94 1 6 1098.28 1 7 580.29 1 8 782.34 1 9 885.86 1 10 832.41 1 10016.39 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 2 1 837.28 2 2 907.75 2 3 772.12 2 4 1012.42 2 5 946.7 2 6 893.08 2 7 1174.44 2 8 992.51 2 9 746 2 10 1095.48 2 9377.78 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 3 1 1419.23 3 2 958.84 3 3 1355 3 4 814.99 3 5 1174.59 3 6 1037.81 3 7 643.84 3 8 1132.65 3 9 812.29 3 10 924.78 3 10274.02 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 4 1 1515.66 4 2 1243.5 4 3 640.06 4 4 1007.17 4 5 1324.01 4 6 1424.95 4 7 686.9 4 8 1153 4 9 1509.06 4 10 819.81 4 11324.12 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 5 1 1258.23 5 2 1103.92 5 3 1035.84 5 4 933.73 5 5 763.68 5 6 828.63 5 7 962.57 5 8 1251.09 5 9 709.65 5 10 688.74 5 9536.08 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE ---------- ---------- ---------- ----------- 1 6250.09 2 4702.23 3 5063.46 4 5139.23 5 5706.92 6 5282.75 7 4048.04 8 5311.59 9 4662.86 10 4361.22 50528.39 198 rows selected. SQL>