Patent ID: 7805433
Filing Date: 2010-09-28
Classification: G06F

Abstract:
1. A computer-implemented method for retrieving data from a multidimensional database, comprising: obtaining a cube function from a cell within a spreadsheet having cells; wherein the cube function is directed at obtaining data from a multidimensional database and wherein the cell behaves similarly to the other cells within the spreadsheet having functions that perform other functions; wherein the cube function is selected from a set of cube functions comprising: wherein the cube function within the cell includes a connection parameter that is included within the cell that specifies the multidimensional database to access; wherein the connection parameter identifies the multi-dimensional database to access and wherein each cube function that is included within the spreadsheet can access a different multidimensional database; generating an MDX query as specified by the cube function; connecting to the multidimensional database that is associated with the cube function; obtaining the data from the multidimensional database as specified by the MDX query generated from the cube function; and placing the data within the spreadsheet cell.