Blog And Articles

Static Vs Dynamic Cubes

A cube is a multidimensional hierarchical data organization that underpins OLAP (Online Analytical Processing) and many other financial software tools. Cubes provide a fast way to analyze data and generate reports. A static cube is one in which the cube is created up front by computing all (or most) values and storing them in one static data structure. Any change or update must either recompute the cube from scratch or use sophisticated techniques to minimize the computational cost of updating the static cube.