Question: how are olap cubes created?
Answer: Processing of an OLAP cube occurs when all the aggregations for the cube are calculated and the cube is loaded with these aggregations and data. Dimension and fact tables are read, and the data is calculated and loaded into the cube. ... OLAP cube processing consists of two separate tasks: Dimension processing.