Combines general information about a project KPI (e.g. revenue) over time (500€ in the first year, 700€ in the second year) with timing information (2 projects start in 2018, 5 in 2019).
SCHEDULEPROJECTS(ProjectKPI, TimingNode [, TimeLevel])
|Training Model||T02 Hochlaufkurven in Training Models|
In this example a company offers two projects (Small, Large) which both run two years and will generate different amounts of revenue in the first and second year.
The Sequence column describes that the Small Project will generate 500€ of revenue in the first year and 700€ in the second year. Instead of year also month or quarter can be used by having a different time column in the TimingNode or by specifying the TimeLevel parameter.
Measure (Number of projects)
Here we specify how many projects start when. Two "Small Project" will start in 2018, while five "Small Project" and ten "Large Project" will start in 2019.
Output SCHEDULEPROJECTS('ProjectKPI', 'TimingNode')