Inject spring bean into Dynamic Schema Processor in Pentaho

Problem

When creating custom classes for Pentaho BA Server, we can ask Spring to create their instances for us, by simply putting necessary settings in one of the application context configuration files under ../biserver-ee/pentaho-solutions/system. But what if our new class has to be created outside of spring and we still need to inject dependencies from the context created for Pentaho? Particularly this becomes a problem when we would like to inject some dependencies into Dynamic Schema Processor.

Continue reading Inject spring bean into Dynamic Schema Processor in Pentaho

Using JNDI connection for Mondrian 4 in Pentaho BA Server

Context

In Mondrian 4 in Pentaho BA Server I explained how to create a datasource on top of Mondrian 4 Schema in the BA Server and later how to use it in Analyzer to create a basic report. The problem I could not overcome for a long time was how use a JNDI connection defined in tomcat inside a datasource definition. Luckily thanks to help given on Pentaho Forum I was finally able to solve the mystery.

Continue reading Using JNDI connection for Mondrian 4 in Pentaho BA Server

Mondrian 4 in Pentaho BA Server

Prerequisites

Should you be working with Pentaho CE (Community Edition) you will first have to enable the support of Mondrian 4 in your BI Server. As I am working with EE (Enterprise Edition, version 5.2) I will not be able to help you on this subject. However, the following article might be of some help: Mondrian 4, OSGi In Pentaho 5.1 CE. Once you have fullfilled all prerequisites or if you are using Enterprise Edition you are good to go.

Continue reading Mondrian 4 in Pentaho BA Server