Monday, January 15, 2018

Casabase: A Closer Look



We just put up some short videos demonstrating Casabase functionality. If you've been wondering what Casabase looks like in action, please go take a look here.

We've been converting some Essbase cubes to Casabase recently. These are cubes that are not a good fit for Essbase: either they have way too many calculations or the granularity of the metadata is too fine. For example, one of the cubes has a member for each employee in a huge company - and since you can't delete a member (without losing data) when an employee leaves, there are tens of thousands of members in this one dimension alone.

These types of databases, however, are an excellent fit for Casabase. All retrievals are faster than in Essbase, but some are in the jaw-dropping range of 20x improvement. Loading metadata and data is also much easier, as there is no down-time for either operation in Casabase. Not to mention that aggregations are dynamic, so there's no more waiting around for calculations to complete before you can view the data. And there's never a question as to why the sum of the child members doesn't match the value in the parent. Priceless!