Issue with macro

[aparna_ranganathan]

I have a macro that updates a key figure . The macro checks certain conditions and if the result is true sets the value of the key figure to 1 and changes the key figure value to 0 if the conditions return a value of false.

I executed the macro in a job . But it did does not update the value of the key figure. When i look at the job spool the warning message says " Not all data in the live cache could be updated"

Cannot figure out why this is happening. Experts please suggest a solution

Thanks

Saradha

[Former Member]

Hi,

What kind of keyfigure is this? Auxiliary or BW or APO keyfigure? It has to be a APO keyfigure for the data to be saved. Auxiliary keyfigure is only temporary and not stored to livecache and BW are read only.

If they are set right, then do a consistency check (/SAPAPO/TS_LCM_CONS_CHECK) if there is a discrepancy in live cache about the key figure.

[aparna_ranganathan]

Hi Visu ,

It is not an auxillary key figure. We do have auxillary key figures in the same planning area , that we use just to provide more details to the SNP planners. This is an APO key figure. We back up the data to BW cubes on a daily basis.

I shall try doing the consistency check. But iam not sure if the problem is with the key figure. I encounter this problem only for around 13 products. For other products the macro is setting / resetting the value of key figure properly .

[Former Member]

Yes saradha. I faced a similar issue and found that no timeseries existed for some products and hence it resulted into no values.

So please run consistency check with repair option which will help you create time series for those CVC's and then run the macro.

[aparna_ranganathan]

Thanks Anuradha. Will try out that option.