Someone pointed me to a white paper as part of a discussion which occurred during the XBRL International Conference in Washington, D.C. last month. The white paper send me down a path which has become quite fruitful. I am still trying to synthesize what all this seems to mean, but here are the highlights.
The paper called "Getting Started with ADAPT" discusses a standardized OLAP database design. The reason the ADAPT model was created was that there is no OLAP standard design model. Different Business Intelligence (BI) applications who use OLAP implemented it somewhat differently. As someone put it, each of these applications "has an attitude" or a "personality", meaning that if you do something in one BI tool one way, it might look different in another BI tool. The ADAPT common model is used to minimize the effort and maximize the quality of BI applications consultants implement for business users.
The ADAPT model defines nine objects. These nine objects are: hypercube, dimension, hierarchy, level, member, attribute, scope, model, and context.
What is really interesting is that there is a high correlation between the ADAPT model and XBRLS (XBRL Simple Application Profile). The creators of XBRLS were totally unaware of the ADAPT model. Yet, there is a high correlation between XBRLS and ADAPT. I found that to be quite interesting.
But thinking about this more, I realized that of course they would be similar. They are trying to do the same thing. ADAPT and XBRLS are both used to model business information using a multidimensional model. (If you don't understand what OLAP or the multidimensional model is, this white paper does a good job of explaining these in terms a business user can understand.)
So what does this mean? Well, these are some of the things I seem to be seeing here and some questions which I have:
Remember that business information is inherently multidimensional in nature; different entities, departments, periods, reporting scenarios, etc.