Methods and systems for dynamic report generation

A system for dynamic report generation, the system comprising:

• one or more processors, one or more computer-readable memories, one or more computer-readable tangible storage devices, and instructions stored on at least one of the one or more storage devices for execution by at least one of the one or more processors via at least one of the one or more computer-readable memories, the instructions comprising:
• instructions to generate a report template, the report template including one or more queries, each of the one or more queries defining calls to metadata of one or more external data stores;
• instructions to generate a template record for the report template, the template record identifying ownership of the report template;
• instructions to store the generated report template in a report template repository;
• and
• instructions to generate based on the report template, a new report, the new report including one or more runtime parameters for each of the one or more queries of the report template, wherein generating the new report includes:
• instructions to convert the one or more queries of the new report to an agnostic JSON language;
• instructions to retrieve based on the one or more queries of the converted new report, data from the one or more external data stores identified in each of the one or more queries;
• instructions to apply the one or more runtime parameters for the each of the one or more queries to the retrieved data from the one or more external data stores;
• and
• instructions to convert the retrieved data from the one or external data stores with the one or more runtime paraments to the agnostic JSON language.

A computer program product for dynamic report generation, the computer program product comprising:

• a non-transitory computer-readable storage medium having program instructions embodied therewith, the program instructions executable by a computer to cause the computer to perform a method, comprising:
• generating, by a processing device, a report template, the report template including one or more queries, each of the one or more queries defining calls to metadata of one or more external data stores;
• generating, by the processing device, a template record for the report template, the template record identifying ownership of the report template;
• storing, by the processing device, the generated report template in a report template repository;
• and
• generating, by the processing device, based on the report template, a new report, the new report including one or more runtime parameters for each of the one or more queries of the report template, wherein generating the new report includes:
• converting, by the processing device, the one or more queries of the new report to an agnostic JSON language;
• retrieving, by the processing device, based on the one or more queries of the converted new report, data from the one or more external data stores identified in each of the one or more queries;
• applying, by the processing device, the one or more runtime parameters for the each of the one or more queries to the retrieved data from the one or more external data stores;
• and
• converting, by the processing device, the retrieved data from the one or external data stores with the one or more runtime paraments to the agnostic JSON language.