03-08-2023 03:44 PM - last edited on 07-20-2023 10:42 AM by JackLacava
Hello,
i have a scenario with a range defined (i.e :Month 3 to Month 12) , i wanna process cube only on these months from month 3 to month 12. however when i launch the process cube through the workflow profile, it executes all the periods (even the prior ones , i.e M1 & M2) , i tried to lock through a BR these two months but it didnt work...
how can i process cube only on my scenario range plz ?
thanks,
03-09-2023 04:38 AM
Onestream stores data as YTD, so if you calculate a later month, it will have to calculate prior periods to figure out what the YTD numbers at that point look like.
The scenario range is a Workflow-related property that determines which periods will allow for data input through the workflow. As far as I understand, behind the scenes, those periods don't disappear into thin air, they will just have no data (as long as you set the Number of No Input Periods Per WF Unit property).
In practice, this shouldn't be a problem - if you set the properties right, the previous periods will always be totally empty, so processing time should be basically irrelevant (assuming good rules are in place).