Basic Temporary HOLD File
- Marie Mariano (Deactivated)
- Sarah Nguyen (Deactivated)
- Jean Ose
A HOLD file is valuable when you want to do the following:
Extract fields from a large data source for faster and more efficient retrieval in subsequent requests. This reduces processing time, enabling you to create reports and charts rapidly against a smaller, more specialized data set. This improves efficiency while giving you the flexibility that you need when working with smaller subsets of your data.
Store virtual field values or summary values calculated in one request for further processing in another request. This allows you to reuse calculated values, decreasing the effort required to recreate certain scenarios.
HOLD files can be created for immediate use and saved temporarily or they can be stored for future and repeated use. This gives you the flexibility to use and store HOLD files, as needed, based on how you want to use the files that you create.
Creating Temporary HOLD Files
See Creating Basic Reports for more information on creating, modifying, adding fields, filtering, and saving reports.
Navigate to your saved report and right-click.
From the right-click menu, select Edit With.., and then click InfoAssist.
On the ribbon, select the Home tab, and click File from the Format group.
From the Temporary hold dialog box, confirm Temporary is selected above the left navigation pane.
Enter text into the Title field.
Confirm Binary (*.ftm) is the selected file format.
Once a file name and file format is identified, click Save. The Temporary File dialog box will close.
You should now see a Query pane (top center) as well the Create Report function (bottom right).
Note that the hold file has been created; see the name in the Query pane.
Click Create Report at the bottom right to use the Hold file to create a report to join the Hold file to another UC_SADM data table.
Notice that the workspace changes again. 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.
Notice that the Hold file displays in the join dialog box. Click the Add New drop-down and then click Existing.
Navigate to rec_student_groups_dim from the dialog box that displays.
Click Open.
Notice that a second table displays in the Join dialog box. Join the tables together. Refer to the Basic Table Joins article for more instruction.
Click OK.
Now create the report, pulling in fields from the Hold file, as well as from the additional table that we just added.
In this example, the fields are added under the By header, within the Query pane.
Add new filters specific to the new table that was just joined. See Filtering a Report for additional instruction.
Click OK to confirm.
Click Run to view the output of the report.
Complete the info within the Parameters dialog box.
Click Run.
Review the output.
See WebFOCUS InfoAssist Manual 8.2.06 for additional information.