• Home
»
• Products
»
• Jedox OLAP

Jedox OLAP

"Jedox’s multidimensional database Jedox OLAP Server provides business users with a flexible business intelligence tool for planning, reporting, analysis and dashboarding. Jedox offers interesting options to implement all types of planning projects." Click here.

Jedox OLAP Server is a multidimensional in-memory OLAP Server.

All the data the Jedox OLAP Server holds is organized in cubes, dimensions, elements and element attributes. This model is so durable because it accurately reflects the way users think of their business. Jedox offers a model which is ideal for departmental solutions and self-service BI because it is particularly easy to use.

Performance by In-Memory Technology

The most rewarding aspect of the in-memory technology is the speed advantage. Compared to an old-style ROLAP system in-memory technologies have the potential to be as much as 100 times faster than an OLAP system with a disk based relational database. Speed is especially important for Jedox, as it supports multidimensional formulas and write-back of data. When the data in the cube changes, all aggregated numbers change as well as all calculation results are instantly available real-time. The cubes do not have to be reprocessed. They are ready to use as soon as the users defines them.

Real-Time Aggregation

Jedox’s real-time aggregation and calculation capability is particularly important, since Jedox view of business intelligence includes the planning – not just the analysis and reporting features of traditional OLAP. The Jedox Olap server works in memory and provides real time calculation, as well as cross data source calculations. The server supports multi-core and multi processor architectures, and offers a completely open API that can easily be accessed from any third party application.

Modelling made simple, even in Microsoft Excel

Jedox OLAP Server also supports real-time modelling. This means users can modify hierarchies and even create new cubes on the fly in the familiar Excel environment. The database returns new aggregated values immediately. Real time modelling is a powerful simulation feature, that lets planners play out what-if scenarios involving changes in their corporate structures. This is another reason why the Jedox designers chose in-memory technology when they started to implement Jedox OLAP Server.

Extend Jedox OLAP via open serial interfaces

Jedox OLAP offers a variety of ways t extend your application via API and standard serial interfaces. Serial interfaces in VBA, PHP, C++, Java and .NET allow Jedox OLAP to be extended. In this way partners and customers are able to provide further functionalities for Jedox OLAP. In the Premium Version we will additionally offer ODBO and XMLA as a serial interface.

Write-Back

In addition to providing a multi-dimensional data analysis of existing data, Jedox allows the input of new data directly into the cube and facilitates both top-down as well as bottom-up planning. This important characteristic makes Jedox different from relational OLAP servers.

User Rights

The Managing User Rights function is a feature available since Jedox 1.5. It enables you to manage access rights for databases, cubes, dimensions and dimension elements, users, user groups, cell data and selected system operations. You can define five different rights: Splash (writing into consolidated cells), Delete, Write, Read, None. These rights are assigned to the various user groups.

Jedox is multidimensional

Multidimensionality is an alternative way of organizing data in a database. In a relational database you are used to structures like tables, records and fields. In a multidimensional database you are thinking in terms of cubes and dimen