You can link scripts into a chain 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.
In Studio, you can use the All from 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 created in non-English versions of Excel.
- Custom Use this setting if you want to keep some of the settings the same and change others.
Important:
Cross-linking of Query and Transaction scripts in the same chain is supported for scripts created in Studio versions 11.x and later.
Studio 20.3 supports cross-linking of Query and Transaction scripts in the same chain for standard workflow (NDR) and only if Query is the first script ("base script"); the only supported chain setting is “All from individual script.” These scripts can be scheduled on recurring basis. In Evolve and Studio Manager, within the completed document version history, you can view the Total Rows and Error Rows numbers separately for each script. Finally, you can do local and server scheduling from Studio and the Add-In.
Studio 20.3 does not support linked chains (cross-linked or not) that combine 10.x scripts with 11.x, 12.x, or 20.x scripts.
Scripts that were created in Query 10.x will use the earlier-version, 'one-at-a-time-linking' process, and the scripts will run in Background Mode.
Create a chain script
- 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.
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, then 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 that setting and click Use first script settings. Then click the Settings button for each individual script and enter the settings that you want.Note:
Notes: 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.)
The Save Data File settings in Studio Options do not apply to chained scripts. The data file is saved after each script runs.
Chain run settings are displayed in the chain script dialog.
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.