SpagoBI JPalo Engine

This SpagoBI external engine is based on the JPalo OLAP client. Palo Pivot is integrated with SpagoBI and interacts with the embedded Mondrian server via an XMLA connection.

1 Installation

The engine comes with both Mondrian Server and JPalo wrapped in a single web application.
To use this engine you need to switch to JDK 1.6. Unzip then SpagoBIJPaloEngine.war under Tomcat's webapps directory.

2 Configuration

2.1 Mondrian

In order to configure Mondrian to use a datasource as a JNDI resource, define resource in server.xml. Then configure it in SpagoBIJPaloEngine/META-INF/context.xml.
Suppose your JNDI datasource resource is named "jdbc/foodmartmondrian", then you need to configure DataSourceInfo tag in SpagoBIJPaloEngine/WEB-INF/datasources.xml
to use the correct JNDI resource.

<DataSourceInfo>Provider=mondrian;DataSource=java:comp/env/jdbc/foodmartmondrian;</DataSourceInfo>
.
Remember that you can even put multiple catalogs and datasources under Mondrian control, by setting them in datasources.xml file.

Further you have to place database schema FoodMart.xml (or the one you have prepared with all cubes defined), under SpagoBI resources folder. To be accessed by
Mondrian server, change Definition tag in SpagoBIJPaloEngine/WEB-INF/datasources.xml.

<Definition>file:<absolute_path_to_folder_under_resources_where_you_placed_schema>/FoodMart.xml</Definition>

2.2 Palo Pivot

Change settings in SpagoBIJPaloEngine/WEB-INF/classes/deploy_it.properties.
By default JPalo uses Hsql db to store its data, but it could eventually use Mysql. You can specify it by setting use.mysql=true otherwise you can set use.mysql=false.
By default JPalo uses http protocol to connect to Mondrian. If you want to change protocol to https set is.ssl=true otherwise set is.ssl=false.
More customization can be done:

  • jpalo.admin.user=[jpalo_username]
  • jpalo.admin.password=[jpalo_password]
  • jpalo.mondrian.connection.url=[mondrian_host]:[mondrian_port]
  • jpalo.mondrian.connection.service=SpagoBIJPaloEngine/xmla
  • jpalo.mondrian.connection.name=[name_of_mondrian_connection]
Once you have decided what kind of database JPalo is going to use to store views and connections, you need to edit the proper settings.
Case JPalo uses HSQL DB, change Hsql db settings in SpagoBIJPaloEngine/WEB-INF/classes/sql/hsql/credentials
  • jdbcDriver = org.hsqldb.jdbcDriver
  • jdbcURL = jdbc:hsqldb:file:[absolute_path_to_your_hsql_files]
  • jdbcPort = [port]
  • userName = [username]
  • userPassword = [password]
Case JPalo uses Mysql DB, change Mysql db settings in SpagoBIJPaloEngineWEB-INFclassessqlmysqlcredentials
  • jdbcDriver =com.mysql.jdbc.Driver
  • userPassword = [password]
  • userName =[username]
  • databaseName =[schema_name]
  • jdbcURL =jdbc:mysql://[database_host]:[port]

2.3 Engine Management

In SpagoBI web interface, define SpagoBIJPaloEngine:

  • Document type : On-line analytical processing
  • Url : [protocol]://[host]:[port]/SpagoBIJPaloEngine/com.tensegrity.wpalo.SpagoBIJPaloEngine/JPaloEngineStartServlet
  • Driver : it.eng.spagobi.engines.drivers.jpalo.JPaloDriver

3 Usage

Create new On-line analytical processing Document, using SpagoBIJPaloEngine.

new.jpg

Once you have saved the SpagoBI document, you can click on Templete build icon, that enables you to create/edit document's template.
Palo Pivot web interface enables you to create a new view on Mondrian connection.
Click on new-view-icon.gif and select "[jpalo_username] on [name_of_mondrian_connection]" from the options.
Create the view you are intersted on, by choosing the cube. Double click on the newly created view, to open it and edit.

newtemplate-jpalo.jpg

See Palo Pivot documentation if necessary.

Save the view by clicking on the Save button (do not choose Save as in this step).

SpagoBI user can now execute JPalo document. If the document is new, then there will be no subobjects and executing document will present tha base view saved
in the previous step.
SpagoBI user can edit the view and save his SpagoBI subobject by clicking on the Save SpagoBI subobject icon.

execute.jpg

Each user can now execute his own SpagoBI subobjects or edit them.

Tags:
Created by angioia on 2009/04/28 09:56
Last modified by Alessandra Toninelli on 2013/11/08 16:03

This wiki is licensed under a Creative Commons 2.0 license
XWiki Enterprise 2.7.33694 - Documentation