Using InetSoft's BI Software to Access Multidimensional Databases

The multidimensional database is another way to provide data for OLAP operations. Taking the place of tables in relational databases, multidimensional databases organize data into cubes that contain measures and dimensions. This technology is often referred as MOLAP. The primary benefit of using MOLAP is enhanced performance because of pre-aggregation.

MOLAP has no industry standard query language, although a few popular mechanisms exist. The Data Modeler uses these technologies to access meta¬data from MOLAP databases and present it uniformly. Because the meta data from a MOLAP database contains all of the information needed for the InetSoft data modeler engine, models for multidimensional databases are automatically created by the Data Modeler.

Multidimensional databases are most commonly provided by a part of a relational database. Both the Microsoft SQL Server Analysis Services and Oracle OLAP server are OLAP add-ons. ESSbase is a specialized multidimensional database that is also marketed as an IBM OLAP server as an add-on to the DB2 database server.

#1 Ranking: Read how InetSoft was rated #1 for user adoption in G2's user survey-based index Read More

For supported OLAP databases, the New Data Source wizard will ask if an OLAP domain should be created at the last step. A ‘Yes’ answer will instruct the Data Modeler to create a special node called ‘Domain’ under the data source. ‘Domain’ captures all cubes inside the multidimensional database that define the dimensions and measures.

why select InetSoft
“Flexible product with great training and support. The product has been very useful for quickly creating dashboards and data views. Support and training has always been available to us and quick to respond.
- George R, Information Technology Specialist at Sonepar USA

Connecting the BI App to MS SQL Server Analysis Service

In order to use a Microsoft SQL Server OLAP domain, it is necessary to create a SQL Server JDBC data source. The OLAP domain uses Microsoft Analysis Services for the OLAP server.

For Microsoft SQL Server 2000, the following JAR files must be included in the system classpath:

  • msbase.jar
  • mssqlserver.jar
  • msutil.jar

For Microsoft SQL Server, the following JAR file must be included in the system classpath:

  • sqljdbc.jar

Connecting the BI App to an Oracle OLAP Server

In order to use an Oracle OLAP domain, it is necessary to create an Oracle JDBC data source. The following files, which can be downloaded from the Oracle website for Oracle 10g, must be included in the system classpath:

  • ojdbc14.jar
  • nls_charset12.jar
  • collections.jar
  • olap_api.jar
  • xmlparserv2.jar

Connecting the BI App to a DB2 OLAP Server

In order to use an Essbase OLAP data source, it is necessary to create a DB2 JDBC data source. The ess_japi.jar file from the Essbase Enterprise Server installation must be included in the system classpath.