User manual BUSINESS OBJECTS FIRSTPREP QUICK TOUR REV 1

[. . . ] In the Run window, type x:\setup (where x is the letter of your CD-ROM drive). The installation program will start. 2 FirstPrep Quick Tour Navigating through FirstPrep With our new product and interface, you can easily count, sort, convert, and select data. This section gives you a brief overview of a few of the windows that you're sure to see. You can see the data included in these windows in the ASCII sample files included on the installation CD. [. . . ] Sorting will group the information in that field, and decrease the processing time. By default, sorting is in ascending order alphabetically or numerically. The fields are sorted by the field that is listed at the top. The Sort window with two fields selected for sorting. Navigating through FirstPrep 7 Convert You can convert your input file type to a different file type. For example, you may have an EBCDIC file, and you want to convert it to an ASCII file. Your original EBCDIC file still exists, and an ASCII file and format file are created for the output. You can also merge multiple input files of varying types into one output file. The Convert window shows two files in the Selected box that are ready to be converted to one ASCII file called 2together. dat. 8 FirstPrep Quick Tour Data Selection With Data Selection, you can select a smaller portion of your data based on the criteria you choose, and output that smaller portion of the data. You can also count the records that contain the data that your business needs. Use the Data Selection windows to join fields, create and combine filters, and link the filters to output files. If you're not familiar with making filters, we have a Set Data Selection window that helps you. If you're a pro at creating filters, you can just type a filter in the Define Data Selection window. In the Define Data Selection window, you create filters to place specific records into an output file. Use filters to create an output file that contains only the information that you want. The example in the Define Data Selection window above pulls records from the 01035 zip code in Massachusetts. Filters can target very specific information based on the contents of your input file. For example, if you have an input file with salary, birth date, and address information, you can create a filter that looks for all individuals that are 55 or older earning $100, 000 or more while living in Miami, Florida. Or you can create a more general filter that pulls records for individuals living in Seattle, Oregon and Montana. When you've set up all the filters that you need, link them to an output file to hold the records that pass the filter (meet the criteria you specified when you created the filter). You can also use the count option to find out the number of records in each filter. If you want an output file that contains all of the records that do not pass the filter, click Remainder. If you want to see the types of records that are placed into each output file, click View. Navigating through FirstPrep 9 Link Data Selections tab on the Data Selection window. This shows the filter and the linked output file that the filtered information will be in. There are many, many more options available in FirstPrep. This merely shows you a small amount of the functions you can use. 10 FirstPrep Quick Tour Using sample files You can use FirstPrep sample files (see the table below) to become familiar with FirstPrep. You can run our data through FirstPrep and set up your own format and definition files, or use ours. These sample files are in the FirstPrep folder in the directory where you installed FirstPrep (by default, C:\pw\ firstprep\tutorials). Folder File name Description data ascii. dat dbase. dbf delim. dat ebcdic. dat ASCII data file. [. . . ] It contains topics about how to set the options in the window and has links to other topics that give more information about the controls and settings on the windows. You can also access the same information by selecting Help > Contents from the menu bar. If you have questions about a control on the window, simply click the question mark in the upper right corner, and then click the control. A popup topic gives more information about the control. Customer portal You can post a question in the Knowledge Base from the Firstlogic portal at http://customer. firstlogic. com/customer. [. . . ]