Entering Data into Supplemental Data Forms
You can enter data into Supplemental Data forms using these methods:
-
Input it manually
-
Import it from a file
-
Enter it using Excel
Data is stored in its base format as per the input details. For example, if you enter $123,456.789 in a currency field formatted with two decimal digits and no thousands separator, the number is stored as 123456.789 but redisplayed as $123456.79.
Form columns and rows are displayed in data entry mode. You can select the entry in the POV bar for data entry. If multiple data entry sections are defined in the form template, a corresponding data entry tab is displayed for each section.
If you import data, you can use either the Replace or Update options.
-
Replace - Clears any data within the form and replaces it with the values from the source file. Any fields absent in the source file will be blank in the form after the import process.
-
Update - Updates only the values that are included in the source file. Other values are not affected.
To enter data in Supplemental Data forms:
Note:
The search control in dimension reference dialog is partially visible as the horizontal scroll is not working in any versions of Mozilla. Use Chrome or Safari as a workaround.