For one of our clients we are looking for the following.
- We create 52 weekly scenario with each their own start and end period setting in the workflow start time and workflow end time. For example we have the scenario CFF_2022W01 which has a workflow start time as 2022W1 and a workflow end time as 2022 W39. For example the scenario CFF_2022W02 which has a workflow start time as 2022W2 and a workflow end time as 2022 W39 etc.
How can we get a list of members of the range within the start and end time in the scenario. So for example based on the CFF_2022W01 scenario it should return in the list 2022W1, 2022W2 up until 2022W39.
For CFF_2022W02 it should return in a list 2022W2, 2022W3 up until 2022W39.
There is also the example when the periods run across years. So for example the scenario CFF_2022W27 has a workflow start time of 2022W27 and end time of 2023W13. The list should then return 2022W27, 2022W28 up until 2022W52 plus also 2023W1 up until 2023W13.
This is what I used so far but is not working correctly for weeks.
Dim instance As New BRApiFinanceScenario()
Dim ScenarioStartPeriod As Integer = instance.GetWorkflowStartTime(si, ScenarioId)
Dim ScenarioEndPeriod As Integer = instance.GetWorkflowEndTime(si, ScenarioId)
Dim noOfNoInput As Integer = instance.GetWorkflowNumNoInputTimePeriods(si, ScenarioId)
Dim ScenarioPeriods As List(Of Integer) = TimeDimHelper.GetIdsInRange(ScenarioStartPeriod, ScenarioEndPeriod)
'Removes all periods up until the input range
Has anyone come across using these settings and what syntax should be used.