Using JNDI connection for Mondrian 4 in Pentaho BA Server


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


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

Spock Testing – Spock tutorial

What is Spock?

Spock is a unit testing framework that in great extent utilizes Groovy’s syntax making your tests comprehensible and easy on the eyes. Although it is a Groovy technology you can use it to test your Java classes as well. What is the most important is that Spock makes writing tests fun. And I really mean it.

Why Spock?

I have to admit that even knowing all the benefits of TDD and tests over all I considered writing them as little pain in the neck. How has that changed when I started using Spock?

Continue reading Spock Testing – Spock tutorial

Master Coder Challenge #3 : Number systems converter

About competition

Quite recently Cybercom company announced a Master Coder challange. The competition will be divided into 10 stages, each of them involving a programming task. Despite missing two first assignments I have taken up the gauntlet and completed task #3.

The goal in this stage was to create a number system converter. Converter should be able to handle systems in the range of 2 to 36. For the working application (successfully converting numbers between systems) you would get 200 points. It was possible to get additional 20 points for introducing an exceptional solution. However, it was prohibited to use conditional statements, and conditional expressions. Thus, for every if, else or switch in your code you would be given respectively -5, -10 or -20 points. Numbers should be represented by following characters:
0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, T, U, V, W, X, Y, Z
Continue reading Master Coder Challenge #3 : Number systems converter

What is Groovy?

Groovy is Java

If you are a bit unwilling of learning a new language, imagine you really don’t have to do that! That’s the most amazing thing about Groovy: you can start using it with just some basic experience with Java. How is that possible you ask, the answer is really simple. When you run a Groovy script it will be first compiled to the same JVM bytecode as standard Java classes and then executed by the JVM itself. Hence you can write Groovy scripts in pure Java. What is more, you will be able to use all the libraries written for Java in your scripts (i.e. Spring, Hibernate, Log4j). You have to admit that’s really cool!
Continue reading What is Groovy?