System and method of transforming queries based upon E/R schema into multi-dimensional expression queries

摘要

A system for transforming queries based upon entity/relationship schema into multi-dimensional expression queries is provided. The system comprises a binding module for matching an object reference in a report specification to a corresponding entity/relationship schema object and adding associated multi-dimensional metadata information from the entity/relationship schema to a corresponding report specification object, and a query translation module for translating the report specification into a single multi-dimensional query.