Patent ID: 7366730

Claim:
A method for performing an operation based on multidimensional data managed by a relational database management system, wherein the multidimensional data that is stored in the relational database includes a plurality of dimensions and at least one dimension of the plurality of dimensions includes a hierarchy having two or more levels of granularity, the method comprising the computer-implemented steps of: registering, with said relational database management system, metadata that defines a cube, wherein said metadata includes data that identifies that said cube is a solved cube; and data that indicates how to handle requests that involve said solved cube, including data that identifies one or more machine-executable procedures which can be dynamically executed at runtime to compute resulting measure data for a particular scenario that the solved cube represents; receiving, through an OLAP API, a request for an operation to be performed on multidimensional data associated with said solved cube; and in response to said request, performing the steps of determining, based at least in part on said metadata, that said solved cube can be used to fulfill said request, determining, based on said metadata, one or more operations to perform to fulfill said request, and generating results based on performing said one or more operations including executing at least one of said one or more machine-executable procedures.