Dynamic Schema Processor : Modify Mondrian Schema in run time

Problem

You have a Mondrian Schema uploaded to the BA Server and you would like to modify it in the run time. For instance in our project we change it for every user authenticated to the platform to apply security restrictions. This modification aims to limit records that users are able to see in reports based on that Mondrian Schema.

Continue reading Dynamic Schema Processor : Modify Mondrian Schema in run time

Pentaho BA Server: Analysis Report Performance Test – Part 1

Problem

Few days ago we were told by the pilot users of our BA Server that for few minutes their performance when creating reports drastically dropped. Our initial guess was that probably it was somehow related to one of the ETL processes running in the background. We started monitoring the database, but we did not see nothing interesting. Hence we decided to get deeper insight into the performance of the BA server itself. My colleague decided to use JMeter but me, I wanted to see whether Selenium engine can get me somewhere.

Continue reading Pentaho BA Server: Analysis Report Performance Test – Part 1

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