Using REST API to upload Mondrian Schema – Documentation mistake

Problem

You would like to use REST API to upload a Mondrian Schema to the BI Server but for some mysterious reason, you receive a failure response. Continue reading Using REST API to upload Mondrian Schema – Documentation mistake

Apply Dynamic Schema Processor to a report created in the Report Designer

Problem

Imagine that you have a custom Dynamic Schema Processor in your BA Platform that is responsible for changing Mondrian schema every time an Analyzer Report is executed. For example we do it to apply some additional security layer. Now lets say you want to create a report in the Report Designer, publish it to the BA Server, but at the same time you would like to reuse the existing Dynamic Schema Processor to modify the data present in that report. In our case: to apply security restriction by limiting records that the user will see when he/she opens this report in BA Server.

Continue reading Apply Dynamic Schema Processor to a report created in the Report Designer

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