31. The article of manufacture of claim 27 , the operations further comprising: generating a new statement for retrieving multidimensional information, wherein the new statement is a structured query language statement and wherein the structured query language statement is generated based on the one or more aggregations in each of the measures.
31. The article of manufacture of claim 27 , the operations further comprising: generating a new statement for retrieving multidimensional information, wherein the new statement is a structured query language statement and wherein the structured query language statement is generated based on the one or more aggregations in each of the measures. 35. The article of manufacture of claim 31 , wherein the operations for generation of the new statement further comprise: generating a SELECT statement for a grand total query.