Posts tagged ‘OLAP’

Turn OLAP data into Geo Charts

instantOLAP contains a flexible GEO chart engine which allows to present your OLAP data as colorful maps with custom texts, color codings, icons and other visualizations in multiple layers.

This (video) tutorial shows how to create GEO charts, starting with a simple background layer. Watch the video or continue reading to learn more about maps in instantOLAP.

Continue reading ‘Turn OLAP data into Geo Charts’ »

OLAP Cube, ROLAP, MOLAP, HOLAP: How to use Stores

The built in Offline Stores in instantOLAP allow to aggregate the classical cubes fully or partwise into light speed local data stores. With Offline Stores, you can realize all modern forms of OLAP storage: ROLAP (direct access to relational databases when querying data), MOLAP (fully aggregated cubes with high performance) or HOLAP (a hybrid mixture of both).

Continue reading ‘OLAP Cube, ROLAP, MOLAP, HOLAP: How to use Stores’ »

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.

Continue reading ‘Overlay charts’ »

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.

Continue reading ‘Remote control your OLAP server’ »

Free OLAP software license included!

Free OLAP licenseGood 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.

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.

excel1

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’ »

instantOLAP tutorial – Lesson 1: Installation

Since many things have changed between the versions 2.2 and 2.5, we will upgrade and extend our tutorial and to post it here lesson by lesson. This is the first part and it contains the basics like how to install and start the server:

  • Downloading and installing instantOLAP
  • Starting and stopping the server
  • Connecting the server with the Workbench
  • Installing a license-code
  • Opening the Web-Frontend

Continue reading ‘instantOLAP tutorial – Lesson 1: Installation’ »

Implementing data-based user access rules

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.

Continue reading ‘Implementing data-based user access rules’ »

“Query too complex”?

Because instantOLAP is usable as “adhoc” ROLAP tool, there is a maximum complexity for reports and a maximum number of loadable cube cells. When using adhoc-cubes, the system has to determine where to load which data from and which data is needed to populate the result or to calculate formulas.

Continue reading ‘“Query too complex”?’ »