Drillbridge, the simple way to implement drill through

I implemented a drill through solution for a company earlier this year. We used a combination of Essbase Studio and ODI. I always felt right at home with Essbase Integration Services (EIS) but hadn’t played too terribly much with Studio – until now.

The solution came out working beautifully. Along the way, however, my research into the solution options led me down some interesting paths. In particular is that Essbase has supported drill-through definitions on cubes for quite some time. In practice this means you can define intersections on the cube that should be drillable, and then provide a URL to drill to. Generally this will be some Oracle software but the door is open to drill to anything – provided you can implement the backend properly.

What started out as a proof of concept has evolved into software that I am calling Drillbridge. Drillbridge is a turnkey solution for implementing drillthrough to a relational database. All you need is the following:

  1. An Essbase cube
  2. A relational database with data you want to drill through to that can be mapped somehow from the source data
  3. SmartView (sorry Excel add-in users)

I should add a little bit more about that second point: if the member in your cube is Jan or January but you have a table somewhere that has a field with a value of ’01’ or similar, then you need to construct a view/query that can map from one to the other somehow. Similarly, if you prefix your Account members with A or A_ or something, then you just need to construct the query to transform the data accordingly. In practice I am finding that this isn’t too hard.

Drillbridge works out of the box with Microsoft SQL Server, Oracle, and MySQL, with potential support for pretty much anything that JDBC can connect to (hint: that’s almost anything on the planet).

I’ll have some more info in the coming weeks but for now I threw together a pretty quick video showing the basic Drillbridge admin interface and a working demo from the venerable Sample/Basic database.

5 thoughts on “Drillbridge, the simple way to implement drill through

  1. Nice tool, are you able to load data at level 0 but performing the drill through at an agg level (for example total product) ?

    • I’ve implemented this functionality but have it turned off at the moment because it needs a little more testing. It’s similar to how Essbase Studio works — grabbing the level-0 descendants of the drilled member and then filling that into the query.

  2. Jason,

    awesome. It’s a very clean and nice solution.

    Congratulations, I guess all customers will appreciate it.

    Regards

    Francisco

    • Thanks Francisco! I am about to start doing some QA on the next version which includes MANY improvements/refinements. Very exciting things coming…

  3. Hi Jason,

    After installing drillbridge software i am trying to use the drillthrough option in planning webforms but the drillthrough option sometimes works and sometimes doesn’t , when all the members are expanded to child level i get the drill through option but if it is at parent level then drill through doesn’t work. However it works perfectly fine from smartview.

    The drillbridge set up is done such a way that the drillthrough should work from any levels forms.Thus Ideally this should work from planning webforms.

    Could you please give some inputs on it.

Leave a Reply to Francisco Amores Cancel reply

Your email address will not be published.