Sap Se

Clarence Chuahuico

Justin Wong

Veljko Jovanovic

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.

Join operations for hierarchical dimensions

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.

Growing community of inventors

Coquitlam, Canada

Clarence Chuahuico