Patent ID: 8082239

Claim:
A method comprising: receiving, at a client computer, a request to perform a query of a cube stored at a server computer, wherein the cube comprises one or more dimensions, each of the dimensions containing one or more hierarchies, each of the hierarchies containing one or more used member sets and having one or more levels; in response to receiving the request, determining a scope of a sub-cube of the cube based upon the query by identifying one or more of the hierarchies referenced by the query, collecting each of the used member sets within each of the hierarchies referenced by the query, locating a highest used level within each of the used member sets within each of the hierarchies referenced by the query, and setting the scope of the sub-cube of the cube as a collection of used member sets from the highest used level to a lowest level within each of the hierarchies referenced by the query; generating instructions for copying the sub-cube having the scope determined from the server computer to the client computer; transmitting to the server computer the instructions for copying the sub-cube; receiving and storing the sub-cube at the client computer; and performing the query on the sub-cube stored at the client computer.