Universal report engine

A non-transitory computer readable storage medium storing a data structure and computer executable program code, which when executed by a processor performs operations to generate a report using the data structure, comprising:

• wherein the data structure comprising:
• a dataset comprising a plurality of records;
• a command comprising a single set of computer executable program code, wherein:
• the single set of computer executable program code includes both a data extraction expression and a first report configuration expression,
• the data extraction expression comprises program code, within the single set of computer executable program code, which when executed by the processor is configured to extract a plurality of fields of a dataset of a data source, and
• the first report configuration expression comprises program code, within the single set of computer executable program code, which when executed by the processor is configured to populate a plurality of cells of a first plurality of dimensions of a first report and to generate a first tree comprising a plurality of subset nodes comprising a plurality of records of the dataset;
• a first tree comprising a root node and a first plurality of nodes extended from the root node and corresponding to a first plurality of subsets of the plurality of records, wherein the root node corresponds to the plurality of records of the dataset;
• and
• wherein the stored computer executable program code, in the non-transitory computer readable storage medium, comprising:
• program code for generating the first plurality of subsets by executing a data extraction expression applied to a plurality of fields of the dataset;
• 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 in response to receiving the command and 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 algorithm, the computer-implemented algorithm comprising:

• receiving a first command comprising a single set of computer executable program code, wherein:
• the single set of computer executable program code includes both a data extraction expression and a first report configuration expression,
• the data extraction expression comprises program code, within the single set of computer executable program code, which when executed by a processor is configured to extract a plurality of fields of a dataset of a data source, and
• the first report configuration expression comprises program code, within the single set of computer executable program code, which when executed by the processor is configured to populate a plurality of cells of a first plurality of dimensions of a first report and to generate a first tree comprising a plurality of subset nodes comprising a plurality of records of the dataset;
• and
• executing the first command by:
• executing the data extraction expression on the dataset to generate the plurality of records;
• executing the first report configuration expression on the plurality of records to generate the first tree;
• populating, using the first report configuration expression and the first tree, the plurality of cells;
• and
• generating, in response to receiving the first command and by traversing the first tree, the first report.