Period Syntax
| Syntax | Example | Comment |
|---|---|---|
| empty parameter/not defined | All periods as defined in the global period selector are displayed. | |
| [] | [] | Selects default property value (not period related). This must be used when using the count property and retrieving resource sets. See Count Examples. |
| * | * | Displays 1 'virtual' period which represents the sum of all periods in the horizon. |
| [<period name>] | [Week 1] | Displays period specified. For example, Week 1. |
| [<period name>],[<period name>] | [Week 1],[Week 2] | Displays period specified. For example, Week 1, Week 2. |
| [<period name>]+<number periods> | [Week 2]+1 | Displays the period specified and subsequent number of periods. For example, periods: 'Week 2', 'Week 3'. |
| [#<period index>]+<number periods> | [#10]+2 | Displays the 10th period in the horizon plus 2 following periods. #10, #11, #12. |
| *[#<period index>]+<number periods> | *[#2]+2 | Displays 1 'virtual' period which represents the SUM over the period range (period index + subsequent two periods. For example, Sum of Period 2, Period 3, Period 4). |
| *[<period name>]+<number periods> | *[Week 4]+3 | Displays 1 'virtual' period which represents the SUM over the period range (period name + subsequent three periods. For example, Sum of Week 4, Week 5, Week 6, Week 7). |
| *[<period name>]+<number periods> | *[Week 4]+3,[Week 4]+3 | Displays 1 'virtual' period which represents the SUM over the period range and the individual periods (period name + subsequent three periods. For example, Sum of Week 4, Week 5, Week 6, Week 7 and the Values of Week 4, Week 5, Week 6, Week 7). |
| *,[<period name>]+<number periods> | *,1+%app_var_sp_sco_cycle_horizon% | Displays 1 'virtual' period which represents the sum of all periods in the horizon followed by all periods in the horizon as defined in the sp_sco_cycle_horizon app variable. |
| *[#%periodcontextstart%]+%periodcontextcount% | *[#%periodcontextstart%]+%periodcontextcount% | Displays 1 "virtual" period, which represents the sum of the periods specified in the global period selector for the user. |
| [#%periodcontextstart%]+2 | [#%periodcontextstart%]+2 | Displays the first period in the global period selector, plus the following 2 periods. |
Note: When setting the syntax, there must be no spaces between the specific queries. For example, *[Week 4]+3.