4.3 Two Approaches to Consolidating Results

There are two approaches you can take to consolidating results:

• Physically consolidate the data into the existing Result Detail table. If you want to physically update theRes_Dtl_<Sys_ID_Num> table, remember to delete all of the data that exists in the table (if any) from Step Pre-Populate the Supporting Result Files.
• Drop the existing Result Detail table and replace this with a database view.

An alternative to physically inserting the consolidated data into the Res_Dtl_ <Sys_ ID_Num> table is to drop the physical Res_Dtl_<Sys_ID_Num> table and create a Database View with the identical name. Advantages to this approach are: a view saves disk space, and always reflects the latest underlying results. If you want to store the consolidated results, but not the underlying detail, however, you must store the consolidated results in a physical table.

Sample SQL: View Approach

CREATE VIEW RES_DTL_101 AS SELECT * FROM RES_DTL_1 UNION SELECT * FROM RES_DTL_2

This approach merely appends the results from both underlying results set. This is acceptable because all reports sum records with the same key values together. Replace original Result_Sys_Id with the Id of new ALM process created for consolidated results.

If the Database Administrators create a view, you must grant access to that view to the appropriate users.

The Reporting Engine sums all records with the same key values together.