Stored Procedure (optional)

The stored procedure will run before every job.

To get access to this option:

1. In the Cubes list, select a cube.
2. In the navigation bar, click the Navigation drop-down list and select Data Sources.
   Note

   Data sources are not accessible to cubes with the In Production checkbox ticked.

3. In the Data Sources list, select the data source you want to edit.
4. In the navigation bar, click Data Source and select Edit Data Source.

5. Right-click the middle of the screen and select Stored Procedure.
   
   Note

   You can also use the navigation bar and click General to get access to this option.

6. Enter the command for the stored procedure. Typically, the procedure could write into a table or flag certain records that are used by the Data Source Editor.

   @LIB_ will adapt to the proper environment at the time of launching the stored procedure, and replace the @LIB_ by the proper database and schema.

   

7. Click Confirm.