Now that you created your first workbook it is time to understand dimension and measure mapping in the workbook.

1. Adding a field

Back in the Workbook Wizard you can add a field in the header of the Excel Template by clicking the Add field button. Then enter the text "From Excel sheet" in the empty blue field and map the new field to the dimension DIM004 of the Fact Table. Do not forget to press the Save button in order to store the changes into your application:

Now switch again to the Preview tab and double click again the first bottom-level element in the dimension tree. This will execute a READ process, but the already existing stored records CANNOT be read back to the Workbook since there is a new dimension key ("From Excel Sheet" in C7) which does not exist in the stored records. Therefore you have to re-enter the values and press the Write button:

Back in the Fact Table tab you can see that all records have got the entered value in the column Dim04 Key:

2. Adding a row

After you know how to add a field you can try to add a new row to your Excel Template. Switch back to the Workbook Wizard and press the Add row button. In the blue field of the added row enter the text "Employees involved" - this is a new metric that should be collected as well:

Test it again by switching into Preview mode. Double click the bottom level element with the stored information (this time the existing records can be read into the workbook), enter some data in the new fields for the new metric "Employees involved" (row 14) and press the Write button:

In the Fact Table you can see that 2 new records for the 2 entered values were added:

3. Adding a column

Finally we add a new column to the Excel Template. Press the Add column button, select a date, map the new column to the field Text02 and type the text "Comment 2" directly into the spreadsheet:

Now test it again in Preview mode and press the Write button to writeback with the additional data:

In the Fact Table, the new comment was saved to field Text02: