It is possible to control which objects to prioritize during a managed execution. This is useful if there is only a small timeslot for extracting data from a source, or if the business would like to have a certain cube ready for the users as early as possible during execution.
Watch the Video!
Setting up a New Prioritization
To set up a new prioritization for use in an execution package, follow the steps below.
1. On the Execution tab, right click on Prioritizations and click on Add Prioritization. The Add Prioritizing Set window opens.
2. In Name, type a name for the prioritization.
3. Drag and drop an object from the Available Objects tree to Selected Objects to add this object to prioritized objects.
4. Click on an object in the Selected Objects list to have the execution steps for that object displayed under Object Settings. Select or clear the individual steps under Selected steps to configure what steps will be prioritized in the execution. For instance, you might only want to prioritize the transfer of data from a specific table because your priority is to have the transfer completed as soon as possible.
5. Check the box for Blocking if you wish for the execution to halt all other execution tasks until the selected steps for the selected object has been completed
6. Click on OK to close the window and create the new prioritization, which will be added to the tree.
Applying a Prioritization to an Execution Package
To make use of a prioritization it needs to be added to an execution package. To do so, follow the steps below.
1. On the Execution tab, expand Execution Packages and right click on an execution package. The Edit Execution Package window opens.
2. In the Prioritization dropdown select the prioritization to apply to the execution package.
3. Click OK.