jason w. jones

software from the trenches

Drillbridge

Drillbridge makes drill-through easy: click a number in Smart View, a Planning form or a Financial Reporting report, and see the rows in the source database that add up to it. It plugs into the drill-through Essbase and Oracle EPM already support, so the cubes and the systems feeding them stay exactly as they are, and it can be set up in hours rather than weeks.

Drillbridge is a commercial product, sold and supported by Applied OLAP. To find out whether it fits your environment, see the Drillbridge page at Applied OLAP and get in touch with them there.

How It Works

Essbase can mark parts of a cube as drillable and send whoever drills there to a URL. Drillbridge is what sits at the other end of that URL. Each report is a SQL query with tokens in it, and when someone drills on a cell, Drillbridge fills the tokens in from the cell’s members, runs the query, and shows the result. The tokens can translate members into whatever the source data uses, so Jan can become 01, and a prefix on an account can be stripped. Drill on an upper-level member, such as a quarter or a whole region, and Drillbridge works out all the members below it to put in the query. It drills to just about anything with a JDBC driver.

Where It Came From

In early 2014 I built a drill-through solution for a client the conventional way, with Essbase Studio and ODI. It worked, but the research along the way turned up something more interesting: Essbase had quietly gained URL-based drill-through definitions back in 11.1.1.3, which meant a cube could drill to anything that would answer the URL. A proof of concept for that became Drillbridge, which I announced in July 2014 as a free download.

It caught on faster than I expected. The first enterprise deployment came within a few weeks, a new release followed every few weeks for the rest of the year, and Essbase Integration Services reaching end of life left plenty of people looking for an easier way to drill to relational data. In both of my Kscope sessions on it, I built a working drill-through on stage, starting from nothing but an Essbase server and a table, in under fifteen minutes. One of the clients it saved a lot of time back then became a customer years later.

In July 2015 Drillbridge Enterprise arrived: a licensed edition with support and more features, while the free version carried on as Drillbridge Community Edition. In March 2016, Applied OLAP acquired Drillbridge, and I joined Applied OLAP full time. Later that year, Enterprise was renamed Drillbridge Plus, and it kept growing: drilling from Planning Cloud, a query translator, attributes, and plenty more. The free Community Edition has since been retired, and Drillbridge is now a commercial product only.

The White Paper

In February 2015 I wrote a white paper on it: Drillbridge: Easy Hyperion Drill-through with No Redevelopment (PDF, 7 pages). It went out as a Saxifrage Systems paper, compliments of Key Performance Ideas, which is the sort of arrangement that tells you what a one-person software company looked like in 2015.

Rereading it a decade later, it holds up better than I expected. The problem it describes — the detail behind a consolidated number is right there in a relational database, and the people looking at the number cannot get to it — has not changed at all. Neither has the shape of the answer: tokens that translate dimension members into whatever the source data calls them, drilling from upper-level members, output to Excel. The product grew a great deal after this, but the paper is still a fair description of what it does and why.

There are webinar slides from October 2014 as well, from back when it was still a free download.

From the Archive

I wrote about Drillbridge a lot. A few posts worth reading:

The Drillbridge category has every post.