Macro Logic

[Former Member]

Hi All,

I would like to set following logic through Macro.

Logic:

IF key figure 1 > ( 5% of Key figure 2 + Key figure 2) then system show warring Massage,Alert & send main to Users.

IF key figure 1 > ( 10% of Key figure 2 + Key figure 2) then system show Error Massage,Alert & send main to Users.

Can anyone tell how i set this logic in Macro & wat is steps for sending mail through Macro?

Thanks in Advance !

Sujay

[Former Member · Accepted solution]

i will post it again

Edited by: Uma Maheswar kumar on Jun 17, 2008 10:11 AM

[Former Member · Accepted solution]

check this..

but do not use message type error..use information with description error or warning.

Note: when you are displaying process messages, take care about number of iterations..

Message will be displayed equal to the number of iterations..

Macros in the Macro Book

New macro

step1: calculation : ( 1 Iterations : W 25.2008; W 25.2008 )

Row: New macro aux. row1 ( Frm W 25.2008 ) =

( ( ( 5 / 100 ) *

Row: Additional Field 2 ( Frm W 25.2008 )

) +

Row: Additional Field 2 ( Frm W 25.2008 )

)

Row: New macro aux. row2 ( Frm W 25.2008 ) =

( ( ( 10 / 100 ) *

Row: Additional Field 2 ( Frm W 25.2008 )

) +

Row: Additional Field 2 ( Frm W 25.2008 )

)

step : send message : ( 1 Iterations : W 25.2008; W 25.2008 )

IF

New condition

Row: Additional Field 1 ( Frm W 25.2008 ) greater than Row: New macro aux. row1 ( Frm W 25.2008 )

IF

New condition

Row: Additional Field 1 ( Frm W 25.2008 ) less than Row: New macro aux. row2 ( Frm W 25.2008 )

Information ( warning )

MAIL WITH WARNING

ELSEIF

New condition

Row: Additional Field 1 ( Frm W 25.2008 )

greater than

Row: New macro aux. row2 ( Frm W 25.2008 )

Information ( error )

MAIL WITH ERROR

ENDIF

ENDIF

Edited by: Uma Maheswar kumar on Jun 17, 2008 11:43 AM

Edited by: Uma Maheswar kumar on Jun 17, 2008 11:44 AM

Edited by: Uma Maheswar kumar on Jun 17, 2008 11:47 AM

[Former Member · Accepted solution]

Hi UMA,

Thanks for reply.

After creating macro according to you,Document is sending by mail is perfectly working according to Information.But Condition is not satisfying properly.Evertime it is showing Key figure 2 is greater than 10 % of Key figure 1(Aux. key 2).

Second is After executing Macro,system genrate one POP UP for Information but i have check this min. 11 times,after that it will get removed & genrate 11 Mails.even in Selection id only 2 Product are there.

I am not getting what mistake i have done while creating macro?

I am trying to macro execution at Aggregated level( 0 level),how i can achive this?

Can u give me solution? it`s urgent

Thanks in Advance !

Sujay

[Former Member · Accepted solution]

I have mentioned that..message appears for number of times equal to the iterations..

Your step might be having 11 iterations(11 periods)...make it one iteration..from and to periods should be same in the macro step attributes to have only one message which runs for only one period..

what is your criteria...?

you want run it for all future months or only for current month or only one month in future..?

Edited by: Uma Maheswar kumar on Jun 17, 2008 2:55 PM

[Former Member · Accepted solution]

Hi Uma,

s ur r right...information messages will pop up to number of iterations....But is there any function or method by which we can restrict it to one message, By the way i cannot reduce the iterations or period because my requirements is to have more then one iterations.

Thanks

Krishna