Queries to obtain data from an OLAP cube for a structured report are consolidated. Queries to retrieve data from an OLAP cube for a structured report are consolidated into a single query. Using the consolidated query reduces the number of database hits; avoids reconstruction of the report from the results of the individual queries; and eases the exporting of the report to other applications. Instead of querying the OLAP cube multiple times, a single query is used to obtain the desired information from the cube. Each access definition within the structured report is examined to determine all of the data to be retrieved from the OLAP cube.