Chapter 4. Using the cube model for summary tables optimization 179
T6."REGION_ID"
),
(
T2."CAMPAIGN_TYPE_DESC",
T2."CAMPAIGN_TYPE_CODE",
T2."CAMPAIGN_DESC",
T2."CAMPAIGN_ID",
T2."STAGE_DESC",
T2."STAGE_ID",
T2."CELL_DESC",
T2."CELL_ID",
T2."PACKAGE_DESC",
T2."PACKAGE_ID",
T2."COMPONENT_DESC",
T2."COMPONENT_ID",
T3."GENDER_DESC",
T3."GENDER_FLAG",
T5."DEPARTMENT_DESC",
T5."DEPARTMENT_ID",
T6."ENTERPRISE_DESC",
T6."ENTERPRISE_KEY",
T6."CHAIN_DESC",
T6."CHAIN_KEY",
T6."REGION_DESC",
T6."REGION_ID",
T6."DISTRICT_DESC",
T6."DISTRICT_ID"
Basically, what the grouping sets describe is how the MQT is to be aggregated
across the dimension hierarchies. If you compare this to the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.