The SAM Engine iteratively populates each active Subject Area Mart in the data warehouse by executing each SAM’s definition file. The SAM definition file contains all the necessary queries to build a SAM.
The SAM Engine starts by executing the cohort rules to generate an up-to-date cohort. Once the cohort is updated, the SAM Engine selects data items from Source and Integrated Marts for each member of the cohort. Once all required data have been acquired, metrics are calculated for cohort members. Lastly, summary metrics are calculated and added to the metric summary tables of the SAM.
Typically, the SAM Engine runs each night after the Source Marts and Integrated Marts have been updated by the Source Mart Engine. Once the SAMs have been updated, Visualizations and reports can be updated and published reflecting the new state of each Subject Area Mart.