In Studio, you can use the All from the first script option to quickly specify the settings for all the linked scripts in a chain. Or you can use different settings for each script. Here are the three options:
- All from first script
- All from individual script (use this setting if you have sheets with different names or if you are including worksheets that were created in non-English versions of Excel).
- Custom (if you want to keep some of the settings the same but change others)
Studio 12.0 does not support Transaction and Query scripts in the same chain.
Studio 12.0 does not support chains that combine 10.x scripts and 11.x scripts; it also does not support chains which combine 10.x scripts and 12.0 scripts.
Scripts that were created in Query 10.x will use the earlier-version one-at-a-time script linking process, and the scripts will run in background mode.
- Open the script that will run first in the chain.
- Click Chain Scripts.
- Click Add, browse to the script you want, and then click Open.
Repeat for each script that you want to add to the chain.
Tip: Use the up and down arrows to change the order of the scripts.
- Do one of the following:
- Click All from first script. Every script in the chain will use the settings that are in the first script.
- Click All from individual script. Each script will use its existing Start Row, End Row, Sheet, and Data file settings.
- Click Custom, click the main Settings button. Each setting in the box is set at Use individual script settings. If you want to keep a setting the same for all scripts, click the button next to the setting and click Use first script settings. Then click the Settings button for each individual script and enter the settings that you want.
Note: If you want the runner to log on to SAP before each linked script runs, choose Use individual script settings in the main Settings box, and then uncheck the ALC box for each script. (ALC stands for auto logon credential.)
Why link scripts?
When a process includes multiple transactions, you can create an end-to-end solution by using linked scripts.
You can also chain scripts when a query is too large or complex. Break the original query into smaller queries and link them together. When you run the linked query, the data will be returned as though you were running the original query.
Running in Background Mode
If one or more of the linked scripts is associated with an Excel data file, the script will run in Background Mode. This means that the script will run in a separate instance of Excel.