Skip to Content
avatar image
Former Member

Macros Issue in APO-Demand Planning

Hi Gurus,

I have to create a macro which will not save the values  if condition fails at Level 2 , screen shot is also attached.  I am able to make the cell Red and information displayed but the problem is its saves the data....can anybody help on this....

   Macros in the Macro Book

       New macro

       IF

       New condition

         Cell: SM Budget (  M 01.2013 )

         >

         Cell: HO Budget (  M 01.2013 )

       New step : ( 1 Iterations : M 01.2013; M 01.2013 )

         Row: SM Budget ( Attributes ) =

           CELL_BG( 6 )

         Error [ DSSS ]

         ENDIF

Untitled.png (105.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 21, 2012 at 09:30 AM

    Hi,

    Once you write in the cell, data will be written to livecache. To prevent this, you can

    compute in an auxiliary row, copy to final ratio after you pass some IF logic.

    Thanks,

    J

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi James

      Thanx for the solution but it won't work for my requirement.  Anyway it resolve this issue thru Badi Implmentation.

      Thanx for the advice..

      AJ