OLAP cubes

Online analytical processing (OLAP) cubes summarize numerical data along defined dimensions and hierarchies. Financials & Supply Management Analytics for EPM Platform retrieves data stored in a relational database, transforms it into a multidimensional database, or datamart, and stores it in an OLAP cube. OLAP is an efficient way to aggregate data. OLAP works with numerical measures called facts. OLAP cubes are efficient at counting, summing, and averaging. OLAP databases store data differently than relational databases. Relational databases store data in two dimensions: Rows and columns. OLAP databases store data in multiple dimensions.