Skip to Content
avatar image
Former Member

Multi or Single Activity or Collective Macros: Which BG Job will be faster ?

I didn't quite notice this before.. or rather didn't care to

3 Macros in a BG job. (activity)

Macro 1 - Updates KF1 using some formula based on KF2 and KF3

Macro 2 - Changes KF3 after Macro1 updates KF1

Macro 3- Adds KF3 and KF4 to update KF5

KF = Key Figure

Which one will faster in the background ?

a) Include all 3 macros above in same BG activity in the sequence (counter) above and run a single job ?

b) Create Individual jobs and activities for each Macro and run in the sequence?

c) Include all 3 macros above in a collective macro and run this as a single job in the BG?

Selections ID for all jobs above are same

Appreciate general guidelines here.

Thanks

Lok.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 18, 2016 at 07:59 AM

    Hi Lok

    I don´t think you will save much time between option 1 and option 2 , but definitely if you create collective macro and run this as single job in BG would be help you. Request you to please cross check from your side and let me know if it helps you.

    Thanks

    Amol

    Add comment
    10|10000 characters needed characters exceeded