Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

By the end of this chapter you will be able to:

  • Create macros
  • Use macros

...

Creating macros

  • Create a macro:
    • Press Find - Macros in the left-hand menu bar to bring up the list of macrosPress Image Removed in the list of macros to create a new macrorepository browser
    • Right click and select Image Added Add Macro
    • Configure the macro:
      • Name: NumOfWeeks
      • Minimum Parameters: 2
      • Maximum Parameters: 2
      • Expression: create an expression to work out the number of weeks - as a whole number – between two dates
        • Use the functions dateDiff() and round() to help with this
    Press Image Removed
    • Press Image Added to save your new macro

...

...

Using Macros

  • Create a new model: Try Macros
  • Drag the Stream stream MC Macro Terminated Customers on to your model

This contains some key dates for terminated customers: the signup date; the date that the customer terminated their service; the date that the final debt on the customer's account was cleared

  • Add attributes for:
    • the number of weeks between signup and termination
    • the number of weeks between termination and the final debt being cleared
  • In each case, use your macro to calculate the number of weeks between the two dates
  • Run the stream MC Macro Terminated Customers to test your new attributes