SELECT fact_1_id, fact_2_id, fact_3_id, SUM(sales_value) AS sales_value FROM dimension_tab GROUP BY fact_1_id, CUBE (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 132 rows selected. SQL>