Forum Discussion

ghizlanemnafe's avatar
ghizlanemnafe
New Contributor
2 years ago

Process cube on a range scenario

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,

  • JackLacava's avatar
    JackLacava
    Honored Contributor

    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).