OLAP is the acronym for On Line Analytical Processing. In general OLAP refers to an OLAP database, but in reality the database is accompanied by a number of related OLAP technologies. OLAP databases are different from Relational databases. OLAP databases are structured to perform multidimensional analysis of any kind of data, but typically business data. OLAPs have the capacity for complex calculations and are used for analysis, and sophisticated data modeling. Most Excel users are familiar with Relational databases with data stored in tables using rows and columns of data. OLAP databases have Dimensions with Elements and Attributes that are used to construct Cubes rather than tables. The data within OLAP Cubes typically comes from the data gathered in Relational databases. There are different kinds of OLAPs on the market today, MOLAP, ROLAP and HOLAP to name a few. Each has their own strengths and weaknesses.
Jedox Suite is the name of the OLAP database technology from Jedox AG of Freiburg, Germany, see www.Jedox.com. Jedox’s OLAP related technologies are referred to as the Jedox Suite and consist of a family of products. Jedox Suite is a memory based OLAP which Jedox calls a MOLAP. For the Excel user this memory-based implementation results in superior speed and performance in Excel. Jedox Suite allows write-back into the OLAP which is not common in OLAPs and this unique capability proves very powerful and extremely useful to the Excel user. It is supported by different operating systems but most importantly for the Excel user, Jedox Suite integrates into Excel for all versions and it appears as an Excel Add-in in the menu bar. Once experienced by the Excel user, it changes how planning, analysis, scenario evaluating and reporting are approached. Once you experience Jedox Suite… you will never be the same!