Patent ID: 7809678

Claim:
A query processor system comprising at least one processor that executes the following components: a component that receives input for defining a fact dimension, wherein the fact dimension is defined by performing the following: identifying a fact table; creating a database dimension; and adding the database dimension to a measure group as a fact dimension, wherein a fact dimension is a dimension of a multidimensional database whose size and granularity is the same or close to those of the fact table, and wherein a standard dimension is a dimension that is not a fact dimension; a receiver component that receives a query that includes one or more standard dimensions and the fact dimension associated with the fact table; and a processor component that receives the query from the receiver component and evaluates the query against a multidimensional data structure, wherein the processor component includes the following components: a scope component that limits the scope of the query in accordance with the one or more standard dimensions such that the query returns an intermediate result set based on the one or more standard dimensions; a selection component that selects only fact dimension members from the fact dimension that correspond to the intermediate result set such that not all fact dimension members in the fact dimension are selected; and an aggregation component that aggregates the intermediate result set with the selected fact dimension members to generate a result set.