Patent Document ID: 20110208690
Application ID: 12711562
Patent Status: 0

Claim One:
1. A computer-implemented method, comprising: configuring one or more computer processors to perform an operation for generating an online analytical processing (OLAP) query from a report specification for a dimensional data model comprising a cube having a plurality of dimensions, each dimension including a hierarchy of members, wherein the operation comprises: receiving the report specification, wherein the report specification includes a plurality of constructs, each specifying performing a distinct operation on data from the cube, wherein at least one construct of the plurality of constructs specifies performing a relational operation on the data from the cube, wherein the relational operation is selected from at least a detail filter, a summary filter, and a sort, and a summary; determining a mapping from a relational model to the dimensional model; determining an order in which to apply the specified operations in the OLAP query to preserve semantics of the report specification, in the OLAP query; and generating the OLAP query from the report specification according to the determined mapping and the determined order in which to apply the plurality of constructs.