Patent ID: 7328206
Filing Date: 2008-02-05
Classification: G06F,Y10S

Abstract:
1. A computerized system for processing a database query directed to a multidimensional database comprising: a processor and a computer-readable medium; an operating environment executing on the processor from the computer-readable medium; an On Line Analytical Processing (OLAP) server executing within the operating environment and maintaining the multidimensional database, wherein the OLAP server processes the database query by determining a subset of the database for each member of an input data set specified by the query; including in the processing of the query any calculated members of the database that are within at least one of subsets of the database, without the query specifying any calculated members of the database; the OLAP server generates an output data set to include any of the calculated members of the database; the OLAP server processes a query directive of a query extension that directs calculated members to be excluded from an output of the query, resulting in processing the query using non-calculated members specified by the input data set; and in a situation when the OLAP server processes said query directive of exclusion, the OLAP server initializes an output data set to an empty set, copies the non-calculated members of the input data set to the output data set, and processes the query using the output data set.