desktop OLAP (DOLAP)

DesktopOLAP (DOLAP) is a special form of Multidimensional OLAP( MOLAP), in which the multidimensional data is not stored on a server, but directly on the personal computer or notebook.

As in Multidimensional OLAP, the data in Desktop OLAP is stored in a multidimensional structure rather than in a relational database. However, this is not done on the OLAP server, as in normal MOLAP, but on the local computer. This means that the multidimensional data can be evaluated and used in other ways offline, i.e. without a connection to a central server. Furthermore, risks such as non-functioning Internet connections can be avoided. A typical user group for DOLAP is, for example, field service consultants.

Like MOLAP, DOLAP is not suitable for large volumes of data. For this reason, DOLAP solutions should be formed from data that has been aggregated in advance.