In the Row Generation, 3 Dimensions example (EX_RT106) the unit, region, and account codes and names are repeated many times. By generating headers for each block of accounts and hiding the first four definition columns we get a more easily readable input template. This has been done in the Report, Block Headers example (EX_RT107) and the following figures depict how it looks when opened in Clausion FPM.

Figure 53: Generated headers for blocks of rows and hiding of four definition columns

To add readability in the workbook:

•add a row for block headers

•merge cells A4:I4 to center block headers over all columns

•hide columns A to D (do not delete them, just hide)

Figure 54: Adding readability to the workbook

Note! Do not type anything in the udid column (a column that contains the definition presentationproperty="udid" in the XML file) on the generate block header row in the Excel file. Otherwise the row will be hidden when the Hide Zero Rows function is used.

The following changes are made to the XML definitions file:

•generateheaders element is added to the first definition column

•header elements for all language versions are added

o%DIM00 NAME% gives the organization unit name

o%DIM01 NAME% gives the region name

Figure 55: Generateheaders and header elements added with variables