Sum Column with Parameter

Previous Member

Hi All,

 

I Have data like this

 

How Board calculate when safety stock is sum Demand Next Week until 3 Weeks?

Previous Member

Hi,

In Board there are different way to to manage Time offset and shift, also using parameter, but this solutions generally need to  run a procedure.

If you simply need  to calculate a fixed coverage You can do it on flight on the report.

Just  set the covered as the value in the cube Demand with:

1. YMT  = sum of the week (in my example month)
2. Offset= 3 take the value of the next 3 month
3. Cycle= 3  make the sum (YMT) with step=3  (after 3 step the sum restart)

The result should be that you need:

 

Previous Member

HI Davide Corbetta,

 

Thats work well. Thanks