Query 1: Aggregations with CUBE and ROLLUP
Analysis of ROLLUP
Starting with a simple query we took the quarterly facts table and aggregated the data for each quarter for all the years.
P1 Assignment: Dimensional Modeling
ERD Diagrams - Dimensions:
Below is the snapshot of the fact tables and dimensions that we have created.
In all we have added 8 dimensions