We’ve been asked how to realize an overlay chart and how to place multiple ranges inside a single chart, so this article will show, using a simple example, how to do this.

Basically, each chart in instantOLAP is bound to a single pivot table. Overlay charts work generally in the same way, but because an overlay chart is composed from… Continue reading

Before you can connect a database server with instantOLAP or any other Java application, you need a to install a matching database driver. For Java systems, you will need a driver which implements the Java JDBC standard and almost all database vendors provide a JDBC driver for their product.

Because of copyright reasons, only a few drivers are included in the instantOLAP standard distribution (an open source driver for Sybase… Continue reading

The instantOLAP console allows to remote control you OLAP server, e.g. to rebuild a dimension or model after the source database changed. Learn about how to use the console and its commands. Continue reading

Some of our customers asked how to implement access rules (for dimensions and keys) based on data stored in their database. This is useful e.g. for sales information systems where sales representives only may see customers of the region they are responsible for and if this representive/region relationship is stored in the database.

This article describes how to implement such access rules in two steps for the… Continue reading

Ever experienced a “Query too complex” message when running a report in instantOLAP? Read here to solve the problem. Continue reading