OLAP Service

The OLAP Service is a service that stores data in multidimensional in-memory databases and provides the data to other services.

The data is pre-aggregated in the cubes which contributes to improved performance of the OLAP database.

There can be multiple databases. Cases of insufficient response times and higher load characteristics on the OLAP computer, you may need to scale vertically with additional memory or CPU to that specific computer.

You can improve the overall handling of multiple OLAP databases by running them on separate OLAP cluster nodes. One OLAP database runs on one computer and cannot be distributed over several computers.

The OLAP Service scales with:

  • The number of users connected to the database.

    OLAP Service calculates the data requested by each user, on demand. Multiple users can use the OLAP database in parallel. This means that if you add more processor cores, the performance of OLAP Service improves for multiple users.

  • The size of the OLAP databases.

    The number and size of the loaded cubes affect the size and the memory consumption of the data model. The size of a cube depends on the number of dimensions the number of elements in the dimensions, and the number of values stored.

    Because of the pre-aggregation of the data, the file sizes on disk do not match the size of the database in memory.

    When cubes are not used for a certain configurable time, the OLAP database can unload them from memory.

  • The number and complexity of rules.