Suppose that a data warehouse contains 20 dimensions, each with about five levels of granularity.
(a) Users are mainly interested in four particular dimensions, each having three frequently accessed levels for rolling up and drilling down. How would you design a data cube structure to support this preference efficiently?
(b) At times, a user may want to drill through the cube to the raw data for one or two particular dimensions. How would you support this feature?