CPC G06F 16/282 (2019.01) [G06F 16/27 (2019.01); G06F 16/284 (2019.01)] | 14 Claims |
1. A computer-implemented method comprising:
receiving, by a computer system having at least one hardware processor, a first request to create a first nested group hierarchy from a first computing device of a first user, the first request comprising a first definition for the first nested group hierarchy, the first definition specifying a hierarchical relationship structure for a plurality of non-leaf group nodes and at least one leaf node, the plurality of non-leaf group nodes and the at least one leaf node corresponding to data stored in a data source in a non-hierarchical structure, the first definition comprising at least one dynamic member selection corresponding to the at least one leaf node, the at least one dynamic member selection specifying at least one search criteria for identifying at least one specific member of one of the plurality of non-leaf group nodes, the at least one search criteria comprising a plurality of conditions that are required to be satisfied for inclusion in the one of the plurality of non-leaf group nodes, the at least one search criteria having been defined by the first user via at least one user interface element displayed on the first computing device;
creating, by the computer system, a first hierarchy object based on the first request, the first hierarchy object specifying the hierarchical relationship structure for the plurality of non-leaf group nodes and the at least one leaf node based on the first definition; and
performing a function of a software application using the first hierarchy object to retrieve the data from the data source, the performing the function of the software application comprising:
receiving, by the computer system, a second request to query the data source from a second computing device of a second user, the second request comprising an indication of the first hierarchy object;
generating, by the computer system, a query result based on the second request using the first hierarchy object to retrieve the data from the data source, the generating of the query result comprising accessing the first hierarchy object in a semantic layer of an application platform, generating a query script according to a database language of the data source using the accessed first hierarchy object, and retrieving the data of the query result from the data source using the query script; and
causing, by the computer system, the query result to be displayed on the second computing device using the first hierarchy object, the retrieved data being displayed in a hierarchical format indicating the hierarchical relationship structure based on the first hierarchy object.
|