A method for generating a report for a resource, the report being generated from databases comprising data sets related to a plurality of resources, the method comprising: receiving, by a query generation module included in an memory, an input provided by a user, wherein the input comprises selection of at least one attribute of the resource and wherein the at least one attribute of the resource is stored in a source data set; dynamically generating, by the query generation module, a first query upon the selection of at least one attribute by a user from a plurality of attributes, wherein the first query comprises instructions for being performed on the source data set located in a database, wherein the plurality of attributes correspond to a particular instance of the resource; determining, by the processor, whether the first query is stored in a table schema, wherein the table schema is indicative of report tables, and wherein the table schema is associated with a first trigger; invoking, by the processor, the first trigger when the first query is stored in the table schema, wherein the first trigger is configured to execute the first query to generate a materialized view upon execution of the first query, wherein the materialized view is a database object comprising results of the first query; generating, by the query generation module, a second query on the materialized view, based on user selection of the first query rendered in the materialized view; dynamically generating, by a report generation system, the report by executing the second query on the materialized view, wherein the second query is generated based on materialized view data and wherein the report comprises relevant data and updated data from the source data set, and wherein the source data set is associated with a second trigger, when the materialized view is generated, to dynamically update the materialized view data when a change is recorded in the source data set; and generating a snapshot table based on the execution of the first query when the first query is not stored in the table schema in order to generate the report, wherein the snapshot table is configured to store the output of the first query. receiving, by a query generation module included in an memory, an input provided by a user, wherein the input comprises selection of at least one attribute of the resource and wherein the at least one attribute of the resource is stored in a source data set; dynamically generating, by the query generation module, a first query upon the selection of at least one attribute by a user from a plurality of attributes, wherein the first query comprises instructions for being performed on the source data set located in a database, wherein the plurality of attributes correspond to a particular instance of the resource; determining, by the processor, whether the first query is stored in a table schema, wherein the table schema is indicative of report tables, and wherein the table schema is associated with a first trigger; invoking, by the processor, the first trigger when the first query is stored in the table schema, wherein the first trigger is configured to execute the first query to generate a materialized view upon execution of the first query, wherein the materialized view is a database object comprising results of the first query; generating, by the query generation module, a second query on the materialized view, based on user selection of the first query rendered in the materialized view; dynamically generating, by a report generation system, the report by executing the second query on the materialized view, wherein the second query is generated based on materialized view data and wherein the report comprises relevant data and updated data from the source data set, and wherein the source data set is associated with a second trigger, when the materialized view is generated, to dynamically update the materialized view data when a change is recorded in the source data set; and generating a snapshot table based on the execution of the first query when the first query is not stored in the table schema in order to generate the report, wherein the snapshot table is configured to store the output of the first query.