SELECT fact_1_id, fact_2_id, fact_3_id, fact_4_id, SUM(sales_value) AS sales_value, GROUPING_ID(fact_1_id, fact_2_id, fact_3_id, fact_4_id) AS grouping_id FROM dimension_tab GROUP BY GROUPING SETS(fact_1_id, fact_2_id), GROUPING SETS(fact_3_id, fact_4_id) ORDER BY fact_1_id, fact_2_id, fact_3_id, fact_4_id; FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 1 1 2737.4 5 1 2 1854.29 5 1 3 2090.96 5 1 4 2605.17 5 1 5 2590.93 5 1 6 2506.9 5 1 7 1839.85 5 1 8 2953.04 5 1 9 2778.75 5 1 10 2334.06 5 1 1 2241.01 6 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 1 2 3155.39 6 1 3 2061.7 6 1 4 2125 6 1 5 2555.41 6 1 6 3088.2 6 1 7 2231.46 6 1 8 1919.89 6 1 9 2426.51 6 1 10 2486.78 6 2 1 3512.69 5 2 2 2847.94 5 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 2 3 2972.5 5 2 4 2534.06 5 2 5 3115.99 5 2 6 2775.85 5 2 7 2208.19 5 2 8 2358.55 5 2 9 1884.11 5 2 10 2027.16 5 2 1 2477.54 6 2 2 2283.71 6 2 3 2581.7 6 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 2 4 2390.3 6 2 5 2554.86 6 2 6 2822.58 6 2 7 2755.76 6 2 8 2926.36 6 2 9 3032.31 6 2 10 2411.92 6 1 1 1219.69 9 1 2 488.22 9 1 3 1260.44 9 1 4 1370.92 9 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 1 5 1497.94 9 1 6 1098.28 9 1 7 580.29 9 1 8 782.34 9 1 9 885.86 9 1 10 832.41 9 1 1 894.62 10 1 2 984.7 10 1 3 739.83 10 1 4 1228.08 10 1 5 1049.75 10 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 1 6 1443.91 10 1 7 947.72 10 1 8 995.02 10 1 9 790.4 10 1 10 942.36 10 2 1 837.28 9 2 2 907.75 9 2 3 772.12 9 2 4 1012.42 9 2 5 946.7 9 2 6 893.08 9 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 2 7 1174.44 9 2 8 992.51 9 2 9 746 9 2 10 1095.48 9 2 1 1084.54 10 2 2 1083.33 10 2 3 645.13 10 2 4 465.48 10 2 5 624.32 10 2 6 1346.18 10 2 7 998.45 10 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 2 8 1053.82 10 2 9 1140.75 10 2 10 935.78 10 3 1 1419.23 9 3 2 958.84 9 3 3 1355 9 3 4 814.99 9 3 5 1174.59 9 3 6 1037.81 9 3 7 643.84 9 3 8 1132.65 9 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 3 9 812.29 9 3 10 924.78 9 3 1 1003.24 10 3 2 964.76 10 3 3 1167.03 10 3 4 1077.64 10 3 5 1005.02 10 3 6 1114.5 10 3 7 643.47 10 3 8 1067.79 10 3 9 1115.66 10 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 3 10 1114.91 10 4 1 1515.66 9 4 2 1243.5 9 4 3 640.06 9 4 4 1007.17 9 4 5 1324.01 9 4 6 1424.95 9 4 7 686.9 9 4 8 1153 9 4 9 1509.06 9 4 10 819.81 9 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 4 1 1037.52 10 4 2 1648.92 10 4 3 890.2 10 4 4 858.48 10 4 5 1166.91 10 4 6 1106.11 10 4 7 1233.89 10 4 8 1277.33 10 4 9 1260.96 10 4 10 843.8 10 5 1 1258.23 9 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 5 2 1103.92 9 5 3 1035.84 9 5 4 933.73 9 5 5 763.68 9 5 6 828.63 9 5 7 962.57 9 5 8 1251.09 9 5 9 709.65 9 5 10 688.74 9 5 1 698.63 10 5 2 757.39 10 FACT_1_ID FACT_2_ID FACT_3_ID FACT_4_ID SALES_VALUE GROUPING_ID ---------- ---------- ---------- ---------- ----------- ----------- 5 3 1201.21 10 5 4 885.62 10 5 5 1264.27 10 5 6 900.08 10 5 7 1163.69 10 5 8 452.29 10 5 9 1151.05 10 5 10 1061.85 10 140 rows selected. SQL>