Page Comparison

A HOLD file is valuable when you want to do the following:

...

For the scenario in this documentation we created a report that joined 2 tables: REC_STUDENT_TERM_DIM and REC_ACAD_STRUCTURE_DIM. We filtered on the academic career to only look at UGRD students, and then we created a dynamic parameter filter for the academic program, plan, and term.

1. Navigate to your saved report and right-click.  

2. From the right-click menu, select Edit With.., and then click InfoAssist.
   Image Modified
3. Click On the ribbon, select the Home tab, and click File from the Format group of the Home tab on the ribbon.
   Image Removed  Image Added  
4. From the Temporary hold dialog box, confirm Temporary is selected above the left navigation pane. 
   Image RemovedImage Added
5. Enter text into the Title field.
   Image RemovedImage Added
6. Confirm Binary (*.ftm) is the selected file format. 
   Image Removed Image Added
   
7. Once a file name and file format is identified, click Save.   The Temporary File dialog box will close.

8. Notice the layout of the work area changes. You should now see a Query pane (top center) as well the Create Report function (bottom right). 
   Image Modified

9. Note that the hold file has been created - ; see the name in the Query pane. 
   Image RemovedImage Added

10. Click Create Report (at the bottom right ), to use the Hold file to create a report to join the hold Hold file to another UC_SADM data table. 
    Image Modified 
11. Notice that the workspace changes again.  The The system assumes you want to create a report using data from that Hold File.   To join the Hold file to another table, click the Data tab and then click Join. 
    Image RemovedImage Added
12. Notice that the hold Hold file displays in the join dialog box.  
    Image Removed Click the Add New dropdown drop-down and then click Existing.
    Image RemovedFor our scenario, navigate Image Added
13. Navigate to rec_student_groups_dim from the dialog box that displays. 
    Image RemovedImage Added
14. Click Open.  
15. Notice that a second table displays in the Join dialog box.    Join the the tables together.   Refer to the Basic Table Joins article for more instruction, as desired. 
    Image RemovedImage Added
16. Click OK.  

17. Now create the report, pulling in fields from the HOLD Hold file, as well as from the additional table that we just added. 

    1. In this example, the fields are added under the By header, within the Query pane.
       
    Image Removed
    1. Image Added

18. Add new filters , specific to the new table that was just joined, as appropriate.  Refer to the . See Filtering a Report documentation for additional instruction.  
    Image RemovedImage Added

19. Click OK to confirm.  
20. Click Run to view the output of the report.  
21. Complete the info within the Parameters dialog box.  Check Run in a new window, as desired. 
22. Click Run. 
23. Review the output. 
    Image Modified

Related Articles

...