Creating HOLD Files

A HOLD file is the stored output of an ran extract, that you can use as the source for WebFOCUS reports and visualizations. A HOLD file can be used immediately within the same procedure that creates it, or selected as the data source for new reports and visualizations.

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.

Create HOLD Files in ibi WebFOCUS Designer

You can use WebFOCUS Designer to create and save HOLD files to be used immediately within your current visualization or saved as new data sources for future reports and visualizations.

    Procedure
  1. From the Hub page, click the plus menu.
  2. Click Create Visualizations.

    The Select Data Source dialog opens.

  3. Select a data source.
  4. Click Prepare/Extract Data.
    Note: You can click Create Visualization to display your data in WebFOCUS Designer's Visualization tab. Then click the Data tab to prepare or extract data.

    Your data flow displays on the Data tab canvas, as shown in the following image.

  5. Add an additional data source to the flow.

    For example, to create a Join, drag another data source from the Applications tree on top of your original data source on the canvas. The resulting Join is shown in the following image.

    For more information on Joins, see Joining Data.

  6. Right-click on the Select Columns node.
  7. Select Edit.

    The Select Editor dialog opens, as shown in the following image.

  8. Edit your data as needed.
  9. Click OK.
  10. Right-click on the Select Columns node.
  11. Select Stage Permanent Extract (Target).

    The Stage Permanent Extract dialog opens, as shown in the following image.

    You can select the properties of your HOLD file, including the application directory for storage, the name of the extract, and the file type of the extract.

    HOLD files can be saved permanently for future and repeated use, or saved temporarily for current 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. If you select Create Session Extract, the HOLD file is saved temporarily to the foccache directory, and is useable for the current session only. For any saved visualization specifying a HOLD file extract, the HOLD file is recreated any time that visualization is ran.

  12. Click OK.

    Your changes have been made, and your staged extract displays in the flow, as shown in the following image.

    You must run the flow to finish creating the extract.

  13. Click the Run arrow icon.

    Your HOLD file is created and saved to your chosen location. It can be used immediately on the Visualization tab, or selected from your list of data sources for future reports and visualizations.

    Note: You can switch back and forth between the Data and Visualization tabs. Modifying your data flow may change or delete any associated visualizations. For more info on creating visualizations, see Creating Content in ibi WebFOCUS Designer.