Abstract: Some embodiments provide a program that generates a first query for a first visualization based on a first query model associated with the first visualization. The first query model includes a first reference to a shared object. The program further sends the first query to a computing system. The program also receives from the computing system a first set of data. The program further generates the first visualization based on the first set of data. The program also generates a second query for a second visualization based on a second query model associated with the second visualization. The second query model includes a second reference to the shared object. The program further sends the second query to the computing system. The program also receives from the computing system a second set of data. The program further generates the second visualization based on the second set of data.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives from a client device a request for data stored in a database categorized based on a hierarchical dimension. The hierarchical dimension is configured to store values from a plurality of values organized in a hierarchy comprising a plurality of levels. The program further generates an intermediary data structure by combining a first set of the data stored in the database and a second set of data based on a level in the hierarchy. The program also generates results for the request by aggregating the data in the intermediary data structure based on the level in the hierarchy. The program further provides the results for the request to the client device.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives from a client device a request for data stored in a database categorized based on a calculated dimension. The program further generates the calculated dimension based on a subset of the data stored in the database. The program also generates an intermediary data structure by combining the calculated dimension with the data stored in the database. The program further generates results for the request by aggregating the data in the intermediary data structure based on the calculated dimension. The program also provides the results for the request to the client device.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives from a client device a request for data stored in a database categorized based on a hierarchical dimension. The hierarchical dimension is configured to store values from a plurality of values organized in a hierarchy comprising a plurality of levels. The program further generates an intermediary data structure by combining a first set of the data stored in the database and a second set of data based on a level in the hierarchy. The program also generates results for the request by aggregating the data in the intermediary data structure based on the level in the hierarchy. The program further provides the results for the request to the client device.

Abstract: Some embodiments provide a non-transitory machine-readable medium that stores a program. The program receives from a client device a request for data stored in a database categorized based on a calculated dimension. The program further generates the calculated dimension based on a subset of the data stored in the database. The program also generates an intermediary data structure by combining the calculated dimension with the data stored in the database. The program further generates results for the request by aggregating the data in the intermediary data structure based on the calculated dimension. The program also provides the results for the request to the client device.