SELECT fact_1_id, fact_2_id, fact_3_id, SUM(sales_value) AS sales_value, GROUPING_ID(fact_1_id, fact_2_id, fact_3_id) AS grouping_id 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 GROUPING_ID ---------- ---------- ---------- ----------- ----------- 1 1 1 381.61 0 1 1 2 235.29 0 1 1 3 270.7 0 1 1 4 634.05 0 1 1 5 602.36 0 1 1 6 538.41 0 1 1 7 245.87 0 1 1 8 435.54 0 1 1 9 506.59 0 1 1 10 513.13 0 1 1 4363.55 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 1 2 1 370.97 0 1 2 2 259.31 0 1 2 3 509.68 0 1 2 4 668.64 0 1 2 5 614.99 0 1 2 6 298.12 0 1 2 7 466.98 0 1 2 8 479.95 0 1 2 9 575.89 0 1 2 10 550.23 0 1 2 4794.76 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 1 3 1 607.06 0 1 3 2 470.61 0 1 3 3 514.79 0 1 3 4 367.72 0 1 3 5 415.19 0 1 3 6 390.99 0 1 3 7 440.98 0 1 3 8 642.67 0 1 3 9 461.13 0 1 3 10 407.11 0 1 3 4718.25 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 1 4 1 834.37 0 1 4 2 471.72 0 1 4 3 339.45 0 1 4 4 337.9 0 1 4 5 409.88 0 1 4 6 719.47 0 1 4 7 390.67 0 1 4 8 595.08 0 1 4 9 890.73 0 1 4 10 398.18 0 1 4 5387.45 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 1 5 1 543.39 0 1 5 2 417.36 0 1 5 3 456.34 0 1 5 4 596.86 0 1 5 5 548.51 0 1 5 6 559.91 0 1 5 7 295.35 0 1 5 8 799.8 0 1 5 9 344.41 0 1 5 10 465.41 0 1 5 5027.34 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 2 1 1 838.08 0 2 1 2 252.93 0 2 1 3 989.74 0 2 1 4 736.87 0 2 1 5 895.58 0 2 1 6 559.87 0 2 1 7 334.42 0 2 1 8 346.8 0 2 1 9 379.27 0 2 1 10 319.28 0 2 1 5652.84 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 2 2 1 466.31 0 2 2 2 648.44 0 2 2 3 262.44 0 2 2 4 343.78 0 2 2 5 331.71 0 2 2 6 594.96 0 2 2 7 707.46 0 2 2 8 512.56 0 2 2 9 170.11 0 2 2 10 545.25 0 2 2 4583.02 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 2 3 1 812.17 0 2 3 2 488.23 0 2 3 3 840.21 0 2 3 4 447.27 0 2 3 5 759.4 0 2 3 6 646.82 0 2 3 7 202.86 0 2 3 8 489.98 0 2 3 9 351.16 0 2 3 10 517.67 0 2 3 5555.77 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 2 4 1 681.29 0 2 4 2 771.78 0 2 4 3 300.61 0 2 4 4 669.27 0 2 4 5 914.13 0 2 4 6 705.48 0 2 4 7 296.23 0 2 4 8 557.92 0 2 4 9 618.33 0 2 4 10 421.63 0 2 4 5936.67 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 2 5 1 714.84 0 2 5 2 686.56 0 2 5 3 579.5 0 2 5 4 336.87 0 2 5 5 215.17 0 2 5 6 268.72 0 2 5 7 667.22 0 2 5 8 451.29 0 2 5 9 365.24 0 2 5 10 223.33 0 2 5 4508.74 1 FACT_1_ID FACT_2_ID FACT_3_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ----------- ----------- 1 6250.09 6 2 4702.23 6 3 5063.46 6 4 5139.23 6 5 5706.92 6 6 5282.75 6 7 4048.04 6 8 5311.59 6 9 4662.86 6 10 4361.22 6 50528.39 7 121 rows selected. SQL>