Universal report engine

A non-transitory computer readable storage medium storing a data structure and stored program code which, when executed by a processor, performs a computer-implemented method:

• wherein the data structure comprises:
• a dataset comprising a plurality of records;
• a command comprising both a data extraction expression and a first report configuration expression:
• (i) wherein the data extraction expression comprises program code for extracting a plurality of fields of a dataset of a data source, and wherein the data extraction expression specifies the data source, the data set, and a field of the plurality of fields, and
• (ii) wherein the first report configuration expression comprises program code configured to populate cells of a first plurality of dimensions of a first report, wherein the first report configuration expression specifies a configuration of the first report, wherein the first report configuration expression further specifies program code for generating a first tree comprising a plurality of subset nodes comprising a plurality of records of the data set, and wherein the first report configuration expression further comprises program code for generating a subset node of the plurality of subset nodes;
• the first tree, wherein the first tree comprises a root node and the plurality of subset nodes extended from the root node, and wherein the root node corresponds to the plurality of records;
• and
• wherein the stored program code, in the non-transitory computer readable storage medium, comprises:
• program code for generating the plurality of subset nodes by executing the data extraction expression applied to the plurality of fields of the plurality of records,
• program code for extracting the plurality of subset nodes from fields of the plurality of records;
• program code for generating a first plurality of populated dimensions by populating, using the first report configuration expression and the first tree, a first plurality of cells of a first plurality of dimensions defined by the first report configuration expression;
• and
• program code for generating a first report comprising the first plurality of populated dimensions generated in response to receiving the command, wherein generating the first report is performed at least by traversing the first tree.

A non-transitory computer readable storage medium storing program code which, when executed by a processor, performs a computer implemented method, wherein the program code comprises:

• program code for receiving a first command comprising both a data extraction expression and a first report configuration expression:
• (i) wherein the data extraction expression comprises program code for extracting a plurality of fields of a dataset of a data source, and wherein the data extraction expression specifies the data source, the data set, and a field of the plurality of fields, and
• (ii) wherein the first report configuration expression comprises program code configured to populate cells of a first plurality of dimensions of a first report, wherein the first report configuration expression specifies a configuration of the first report, wherein the first report configuration expression further specifies program code for generating a first tree comprising a plurality of subset nodes comprising a plurality of records of the data set, and wherein the first report configuration expression further comprises program code for generating a subset node of the plurality of subset nodes;
• program code for executing the first command by:
• executing the data extraction expression on the dataset to generate the plurality of records of the dataset;
• executing the first report configuration expression on the plurality of records to generate the first tree, wherein the first tree comprises a root node corresponding to the dataset and the plurality of subset nodes comprising the plurality of records;
• program code for populating, using the first report configuration expression and the first tree, a plurality of cells of the first plurality of dimensions to obtain a first plurality of populated dimensions;
• and
• program code for generating, in response to receiving the first command and by traversing the first tree, the first report comprising the first plurality of populated dimensions.