Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Info

See Creating Basic Reports for more information on creating, modifying, adding fields, filtering, and saving reports.

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

  2. From the right-click menu, select Edit With.., and then click InfoAssist.

    edit with infoassistImage Removededit with infoassistImage Added
  3. On the ribbon, select the Home tab, and click File from the Format group.

    Click File (from the Design group on the ribbon)
  4. From the Temporary hold dialog box, confirm Temporary is selected above the left navigation pane. 

    Temporary above left navigation pane
  5. Enter text into the Title field.

    Title field
  6. Confirm Binary (*.ftm) is the selected file format. 

    Binary file format
  7. Once a file name and file format is identified, click Save. The Temporary File dialog box will close.

  8. You should now see a Query pane (top center) as well the Create Report function (bottom right). 

  9. Note that the hold file has been created; see the name in the Query pane. 
    Hold File name in Query Pane

  10. 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. 

    Click Create Report
  11. 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. 

    data and join buttons
  12. Notice that the Hold file displays in the join dialog box. Click the Add New drop-down and then click Existing.

    Click Add new and then Existing
  13. Navigate to rec_student_groups_dim from the dialog box that displays. 

    Navigate to data file
  14. Click Open.  

  15. 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.

    basic table join
  16. Click OK.  

  17. Now create the report, pulling in fields from the 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.

      add fields under the By header in the Query Pne
  18. Add new filters specific to the new table that was just joined. See Filtering a Report for additional instruction.  

  19. Click OK to confirm.  

  20. Click Run to view the output of the report.  

  21. Complete the info within the Parameters dialog box.  

  22. Click Run. 

  23. Review the output. 

Info

See WebFOCUS InfoAssist Manual 8.2.06 for additional information.

Filter by label (Content by label)
showLabelsfalse
max10
spacesIKB
sortmodified
showSpacefalse
reversetrue
typepage
cqllabel in ( "infoassist" , "file" , "file-storage" , "file_storage" , "info_assist" ) and space = currentSpace ( )
labelskb-how-to-article

...