Defining sub-cube scope based upon a query

摘要

Technologies are described herein for defining the scope of a sub-cube based upon a database query. A request is received to perform a query of a multi-dimensional database, such as a cube, stored at a server computer. In response to the request, the scope for a sub-portion, called a sub-cube, of the multi-dimensional database is determined based upon the query. The scope of the sub-cube may be determined by identifying the minimum sub-portion of the cube necessary to perform the query. Once the scope has been determined, the sub-cube is generated at the server computer and transmitted to a client computer. The client computer stores the sub-cube locally and performs the requested database query on the sub-cube stored at the client computer. A user interface may be provided through which a user can modify the scope of the sub-cube determined based upon the query.

主权项

1. A method for performing a query on a sub-portion of a multi-dimensional database, the method comprising:
receiving a request at a client computer to perform the query on the multi-dimensional database stored at a server computer; identifying the sub-portion of the multi-dimensional database based upon the query by collecting used member sets within each hierarchy reference by the query, locating a highest used level within each of the used member sets within each hierarchy reference by the query, and setting a scope of the sub-portion of the multi-dimensional database as a collection of used member sets from the highest used level to a lowest level within each hierarchy referenced by the query; generating instructions for obtaining the sub-portion of the multi-dimensional database from the server computer; transmitting the instructions to the server computer; receiving, at the client computer, the sub-portion of the multi-dimensional database; storing the sub-portion of the multi-dimensional database at the client computer; and performing the query on the sub-portion.