SAP SE
Database queries using dynamically calculated dimensions

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.