Overlay charts
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.
Release 2.6.1 Update 1
Today, we released the update 1 of our current version 2.6.1. This update is a pure service update and only contains bug fixes and small convenience improvements but no new features. As usual, you can download the update from our download page and you’ll find the release notes of the update in this post.
JDBC drivers
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 and Microsoft SQL-Server and a second driver for HSQLDB databases). For all other database servers, you can find the driver in the internet. This is a list of the common database servers and some internet addresses where to find the driver.
Release 2.6.1
Today we uploaded the next release of instantOLAP on our server. Version 2.6.1 is more than a service release, it also contains a number of nice frontend and backend features and improvements.
You can download the new version from our downloads page. You will also find a new version of our manual, reference and online documentation on our documentation page. Read this article to learn some details about the new version 2.6.1 and to read its release notes.
Remote control your OLAP server
There is an almost unknown tool within every instantOLAP installation, the instantOLAP Console, which allows to remote-control your instantOLAP server and to start, stop or rebuild models, to rebuild single dimensions or cubes or to perform a number of other operations.
The tool is very useful whenever instantOLAP loads its data from a data-warehouse and you want to rebuild certain models, dimensions or cubes after the ETL tool rebuild the warehouse or added new data to it.
This article describes, how to use the tool from batch-files or other Java applications (most ETL tools can call native Java commands) and which operations are available.
Release 2.6.0
From today, the new release 2.6.0 is available for download on our download page.
If you haven’t read about 2.6 before, have a look into our previous article Whats new in 2.6?. At a glance, the new version has some nice frontend improvements, it is faster and uses less memory, it is easier to use and it contains less restrictions. Read the release notes in this article for a complete list of all improvements and fixes.
And the new version contains a free administrator license for each new or existing customer. This also means, you will no longer need to request an evaluation license if you want to download and test instantOLAP. Just download the software, install it and start using the it without any time limit.
How to update instantOLAP in Apache Tomcat
Of course, you could just download the new installer of instantOLAP and install the application in the same path again. But this has a number of disadvantages: 1. The download of the complete installation is much larger, 2. all of your personal settings in the server or for the instantOLAP would get lost and 3. the demo reports and the access rights and some other repository elements will be re- or overwritten with its original state again.
Therefore, this article describes, how to update instantOLAP when using the Apache Tomcat application server with some easy steps. The Tomcat server is included in the standard distribution of instantOLAP.
Continue reading ‘How to update instantOLAP in Apache Tomcat’ »
Free OLAP user license included!
Good news for new and existing instantOLAP customers: Beginning from version 2.6, instantOLAP contains a build-in and free single user license!
If you are a new user, you can now download and use instantOLAP without the need to request an evaluation license. If you are an existing customer, you will have an additional and free license in your license pool after you updated to 2.6
The free license is an unlimited administrator license and never expires or contains any other restriction. With this license, you can build OLAP models and reports, evaluate instantOLAP for an unlimited period of time or set up your single user OLAP server without any costs.
instantOLAP 2.6 will be available at the end of september 2009, but you don’t have to wait and can download the preview version right now. Use this link to download and test the preview version.
What’s new in 2.6?
This month, we will publish our next version 2.6 and the fresh 2.6 beta will be available from today. Beside some new frontend features, this version will contain some significant improvements in its Cube structure. Read this article to learn about some of the new features and to download the beta version.
Release 2.5.3: Connect Excel and other ODBO / XML/A clients with instantOLAP
Today we released our next version of instantOLAP, including the first beta version our new ODBO / XML/A / MDX connector which opens the world of other OLAP clients to instantOLAP servers. With the new connector, you can query the instantOLAP server with Microsoft Excel or any other reporting client that supports the Microsoft ODBO standard or the webservice-based XML/A protocol.
The beta version of the connector will be available for free as a part of the following releases unless it reaches the production standard in version 2.6.
You can download the new release 2.5.3 from our download page. Beside the connector, it contains a small number of bug fixes and performance-improvements.
Continue reading ‘Release 2.5.3: Connect Excel and other ODBO / XML/A clients with instantOLAP’ »