Thriller is a Java JDBC driver that executes MDX queries against an Essbase server, then maps the results back to a traditional JDBC ResultSet. It can be dropped in to such tools as ODI, FDMEE, JDBC-based database clients such as RazorSQL and SQuirreL, or just used with Java.

Currently, Thriller is not publicly available. Please email me if you’d like to use it.

Getting Started with Java

You can use the Thriller driver as you would any other JDBC driver. The JDBC URL syntax includes the server name, application, and cube to connect to, as shown here:

String embeddedSampleBasic = "jdbc:essbase:thriller://epm11124/Sample.Basic";
Class.forName("com.jasonwjones.hyperion.thriller.ThrillerDriver");
Connection conn = DriverManager.getConnection(embeddedSampleBasic, "admin", "password");

The Thriller JAR file should be on your class path. After creating the connection you can execute a query and fetch the result set.

Using in a Database Tool

Add the Thriller JAR file, specify the class name, and add other parameters as you normally would. In RazorSQL, your connection configuration might look like this:

RazorSQL connection configuration

You can try out the following query against Sample/Basic to see if things are working:

/**
*
* -- column.1.name = ENTITY
* -- column.1.type = VARCHAR
* -- column.2.name = ACCOUNT
* -- column.2.type = VARCHAR
* -- column.3.name = PERIOD
* -- column.3.type = VARCHAR
* -- column.4.name = VIEW
* -- column.4.type = VARCHAR
* -- column.5.name = AMOUNT
* -- column.5.type = DECIMAL
* -- column.5.precision = 9
* -- column.5.scale = 2
*
* -- thriller.print-tuple-member-separately = true
* -- thriller.header-tuple-separator = |
*/
 
SELECT 
  {[Actual]} 
ON COLUMNS,
  Non Empty(
    Generate(
      {Order(Uda([Market],"Major Market"),[Market].CurrentMember.MEMBER_NAME)}
      ,CrossJoin({[Market].CurrentMember},Union(CrossJoin(Descendants([Profit],[Measures].Levels(0))
      ,CrossJoin(Descendants([Year],[Year].Levels(0)),{[100]}))
      ,Union(CrossJoin(Descendants([Total Expenses],[Measures].Levels(0))
      ,CrossJoin(Descendants([Year],[Year].Levels(0)),{[100]}))
      ,CrossJoin(Descendants([Inventory],[Measures].Levels(0))
      ,CrossJoin(Descendants([Year],[Year].Levels(0)),{[200]})))))
    )
  )
ON ROWS
FROM Sample.Basic