Skip to Content
avatar image
Former Member

Target stocklevel values for reporting

Hi Guys,

I am new to SNP. I have a requirement for having the values of "target stock level" calculated by the standard 'safety stock/target day's/reorderpoint/target stock level' macro to be captured in the SNP reports.To make this happen, I created a timeseries keyfigure and used the keyfigure in the macro to get it saved in the pa.Now the problem is when i run this macro in the background no values are getting saved in this timeseries keyfigure.

I would like to know whether we can run this macro in the background and save the values in the timeseries keyfigue for the purpose of reporting?

If this is not possible, what are my options?

Please help me resolve this issue.

Thank you in advance for your help and support.

Regards,

Sam

I

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 28, 2011 at 03:20 PM

    Sam

    Your approach is right. Since target stock level is an auxiliary key figure , the values will not get saved to live cache. So creating a time series key figure and copying values from the auxiliary key figure to time series key figure is the best way to approach the issue.

    But please clarify something. You are calculating the value of target stock level using s.s / reorder point macro and the macro saves the result to the target stock auxiliary k.f . Where do you have the copy step (copying values from auxiliary to time series key figure) - is it in a separate macro ? If that is the case then in your backgroud job u have to run the s.s / reorder point macro first and then teh copy macro. Only then the values will be saved to t.s key figure

    thanks

    Aparna

    Add comment
    10|10000 characters needed characters exceeded