1. First of all, make sure you have the categories you want to use to divide your fields. Click on the Edit Categories link in the Available Fields section.
2. Add the Athlete, Camp, Payment, and Time categories and click the Save & Close button.
Column
width
70%
Section
Column
width
30%
3. Click the expand arrow next to the folder names to see the columns you have selected from each table.
4. From the AthleteFact table either select and drag the fields individually or use shift to click on each of the AgeAtCamp, AgeGroupAtCamp, and Demographic fields and drag these into the Athlete folder.
Column
width
70%
Section
Column
width
30%
On completion you will note that the column names are now in bold indicating that they have been added to the view.
Column
width
70%
Section
Column
width
30%
5. Now follow the same steps as above and put all the fields in their correct categories. Cost, InvoicedAmount, and InvoicedDate fields > Payment category. InvoiceDate field > Time category. Camp fields > Camp category. Person fields > Athlete category.
Column
width
70%
Section
Column
width
30%
6. To update the field name to provide a more user friendly name - – double click the ISOCODE field. Change the business name of the field to Athlete Country.
Column
width
70%
Section
Column
width
30%
7. This field will use an Org Ref Code to convert ISO Country Codes to their respective names. To set this up, click on the Format tab.
8. Set the Format option to Org Ref Code. In this case you will use an existing type that we have set up for a sample.