Please see this article on how to download this template: Bottom Up Template

Rules. (Required fields are highlighted with a Red background colour)



Field NameDescriptionRulesException HandlingValues to be placedDefault Values
Field Type
Portfolio Level 1This field contains the Site Name
This field is mandatory and must match with the Site name in the system
N/A
N/A
N/A
Variable Character
Portfolio Level [2 to last level]These columns contain the next portfolio's levels after the Site level
This field is mandatory and must match with the Department level names in the system N/AN/A
N/A
Variable Character
KPI Type
This is an indicator which determines the type of KPI the KPI within the repository belongs to.

If the selection is not chosen, the default value will be associated to the KPI. 
N/A
N/A
Variable Character

Stage

This field contains the current stage of an Idea/Initiative
The Stage names in this field must be validIf there is a spelling mistake, or the stage selected on the import is not the same as the stage saved on the system, the import will not be successful and an error will be displayed
Valid stage names
N/A
Variable Character

[Month][Year]
These fields contain the target values for the next 12 months of the financial year based on the start date and end date
Must be numeric values
N/A
N/A
N/A
Numeric


Note: the targets file is generated based on the period when creating the pipeline targets. For example, if the start date is 01/01/2024 and the end date is 31/12/2024, the export will automatically generate the months based on the start and end date.