GENERATING REPORTS BASED ON MATERIALIZED VIEW

摘要

The present subject matter provides a system and a method for generating report on a materialized view. The method includes generation of a first query based on selection of at least one attribute from a plurality of attributes of a resource associated with a metadata driven framework. The plurality of attributes is associated with a particular instance of the resource. The method further includes storing the first query in a table schema. The table schema is associated with a first trigger. The method also includes invoking the first trigger upon storage of the first query in the table schema. The first trigger is configured to execute the first query to generate a materialized view based on an output of the first query. The method may include executing a second query on the materialized view for generating the report. The second query may be created based on materialized view data.