Mapping a resource description framework OLAP ontology to the business intelligence semantic model

Abstract

In our previous work, we have created an ontology for describing both the structure and the content of on-line analytical processing (OLAP) multidimensional cubes using the Resource Description Framework (RDF) XML sublanguage. In the present paper, we describe how we have mapped our ontology onto a multidimensional database schema which can effectively be used to define the data access layer for Microsofts Business Intelligence Semantic Model (BISM). This mapping facilitates so-called self-service business intelligence by allowing immediate end-user access to the multidimensional data, from desktop applications such as spreadsheet pivot tables, without the need for any special technical expertise to guide the transformation process. © 2011 Springer-Verlag Berlin Heidelberg.