Creating HOLD Files

In this section:

How to:

This section contains examples of how you would use a HOLD file.

Note:

Procedure: How to Create Multiple Components in a Document From a HOLD File

This procedure describes how to extract fields into a HOLD file and then create multiple components in a document from the HOLD file.

  1. Open InfoAssist in Document mode.
  2. Select a data source.
  3. Add fields that need to be extracted for use in subsequent requests.
  4. On the Home tab, in the Format group, click File.
  5. In the Temporary dialog box, name the file, choose the format of the HOLD file from the format drop-down list, and click Save.

    Note: The default is to create a temporary HOLD file, which is deleted after the report or chart is run. Alternatively, you can create a permanent HOLD file by selecting an application path folder location. This file will remain in this location after the procedure is run for future use.

  6. On the Insert tab, in the Reports group, click Chart.
  7. Add fields to the chart.
  8. Insert another chart.
  9. Add fields to that chart.
  10. On the Format tab, in the Chart Types group, click Pie.
  11. On the Insert tab, in the Reports group, click Report.
  12. Add fields to the report.
  13. Add as many reports and charts as you want to complete your document.

Procedure: How to Create a Tabular Report From a HOLD File

To create a tabular report from a HOLD file, begin by creating a report.

  1. In the Open dialog box, select the wf_retail_lite Master File.
  2. Add the following measure fields to the report:
    • Cost of Goods
    • Discount
    • Gross Profit
    • Quantity,Sold
    • Revenue
  3. Add the following dimension fields to the report:
    • Product Category
    • Product,SubCategory
    • Sale,Year
  4. On the Home tab, in the Format group, click File.

    The Temporary dialog box opens.

  5. In the Temporary dialog box, name the HOLD file, keep the default file type, Binary (*.ftm), and click Save.
  6. At the bottom of the canvas, click Create Report.

    The custom database structure displays in the Resources panel. The canvas is returned to a default blank state, enabling the development of a new report using the HOLD file.

  7. From the HOLD file, drag Quantity,Sold to the canvas.
  8. On the canvas, select the Quantity,Sold column heading.
  9. On the Field tab, in the Display group, click Aggregation, and then click First Value.

    Note: The heading changes to FST Quantity Sold.

  10. Select the FST Quantity Sold heading.
  11. On the Field tab, in the Display group, click Hide Field to hide Quantity,Sold, as it will be used in a subsequent calculation.
  12. On the Data tab, in the Calculation group, click Summary (Compute).
  13. In the Summary Field (COMPUTE) dialog box, do the following:
    • In the Format field, type D8.2%.
    • Double-click the Quantity,Sold field to add it to the formula box.
    • Add / 100 after the Quantity Sold field to calculate the percentage.

    The following image is an example of the Summary Field (COMPUTE) dialog.

  14. Click OK to close the dialog box.
  15. Drag Product,Category to the By Query field container.
  16. In the Query pane, select the Product,Category field.
  17. On the Field tab, in the Break group, select Subtotal to create Subtotals on Product,Category.
  18. Drag Product, Subcategory to the By Query field container.
  19. Drag Sale,Year to Across.
  20. On the Home tab, in the Report group, click Row Totals.

    The final report displays.

Procedure: How to Rearrange HOLD File Components

The following procedure describes how to rearrange file components in a HOLD file.

Note: This procedure creates a binary HOLD file and a subquery to illustrate how to rearrange HOLD files. It also shows the result of this rearrangement.

  1. Create a new document, using the wf_retail_lite Master File for the data source.
  2. On the Insert tab, in the Reports group, click Report. Populate the report with the following fields from the Data pane:
    • Gross Profit
    • Quantity,Sold
    • Revenue
    • Product,Category
    • Product,Subcategory

    The report is shown in the following image.

  3. On the Home tab, in the Format group, click File to create a HOLD file.

    In the Temporary dialog box, enter a name for the file. For example, File1_binary.

  4. Click Save.
  5. Create a report using the HOLD file, specifying Product,Category, Product,Subcategory, and Quantity,Sold, as shown in the following image.
  6. Next, using the following steps, add a subquery SQL script for use as a filter on the first report.
    1. On the Data tab, in the Data Source group, click Switch.

      Select the original Master File (wf_retail_lite).

    2. Locate and double-click the Product,Category dimension field.

      This creates a second report, which you can drag and resize as needed on the Document canvas.

    3. Create a filter on Product,Category, where the product category is equal to Televisions.
  7. With the new component selected, click the Home tab and in the Format group, click File.

    In the File name field, enter File2_subquery and select the SQL Script (*.sql) format from the file types menu.

  8. Click Save.
  9. Rearrange the order of the HOLD files so that the File2_subquery is positioned above the File1_binary HOLD file using the following steps:
    1. Right-click Files in the Query pane and click Arrange Files, as shown in the following image.

      The Arrange Files dialog box opens.

    2. Using the Arrange Files dialog box that displays, select File2_subquery and click Move Up to move the file above File1_binary, as shown in the following image.
    3. Click OK.
  10. Edit the first report and create a filter using the subquery.
  11. Click OK to exit the Create a filtering condition dialog box.

    Your report is refreshed to reflect the filtering you have applied.

TIBCO FOCUS Format Index Fields

FOCUS is the only format that supports an index field. The maximum number of fields to index is four. If the file format is FOCUS, then Index appears on the Query pane.