Executing load rules using MaxL

In this recipe, we will load data into our database using a load rule and MaxL script. We will also create a generic load rule batch with parameters. You should complete recipe Setting up folder structure and other files needed for MaxL automation before you continue as we are going to need the folder structure and script created in that recipe. In addition, the recipe Using the outline editor to add dimensions in Chapter 5 completes the Sample Basic outline started in this chapter. We will need the dimensions Scenario and Year to complete this recipe.

Getting ready

To get started, click on the Start menu, click on Run, enter notepad, and press Enter.

How to do it...

1. Select the Start menu, click on Run, enter notepad, and press Enter.

2. Enter the following code into Notepad:

   SET JOB_NAME=%1
   SET LOAD=%2
   SET RULE=%3
   
   cd /d %~dp0
   
   echo Retrieve Host name, User Name, Password, Application, and Database
   CALL ..\Admin\ini.bat
   if %errorlevel% NEQ 0 GOTO ErrorHandler2
   CALL...