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
For the scenario in this documentation we created a report that joined 2 tables: 1) REC_STUDENT_TERM_DIM and 2) REC_ACAD_STRUCTURE_DIM. We filtered on the academic career to only look at UGRD students, then we created a dynamic parameter filter for the academic program, plan, and the term.
| Note |
|---|
| Info |
See Creating Basic Reports articles for more details information on creating, modifying /wiki/spaces/IKB/pages/10883138204, adding fields, filtering, and saving reports, etc. |
Navigate to your saved report and right-click.
From the right-click menu, select Edit With.., and then click InfoAssist.
Click
On the ribbon, select the Home tab, and click File from the Format group
of the Home tab on the ribbon.
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.
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).
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
holdHold file to another UC_SADM data table.
Notice that the workspace changes again.
TheThe 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
holdHold file displays in the join dialog box.
Click the Add New
dropdowndrop-down and then click Existing.
For our scenario, navigate 
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
thethe tables together.
Refer to the Basic Table Joins article for more instruction
, as desired.
Click OK.
Now create the report, pulling in fields from the HOLD 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, as appropriate. Refer to the . See Filtering a Report documentation for additional instruction.
Click OK to confirm.
Click Run to view the output of the report.
Complete the info within the Parameters dialog box.
Check Run in a new window, as desired.Click Run.
Review the output.
| Note | ||
|---|---|---|
| ||
| Info | ||
See WebFOCUS InfoAssist Manual 8.2.06 for for additional information, as desired. |
Related Articles
| Filter by label (Content by label) | |||
|---|---|---|---|
|
...
|
...
...
|
...
|
| Page Properties | ||
|---|---|---|
| ||
|