QPT Enhancements

Four QPT enhancements are listed below:

1. Previously, there was only an option to import external Queries through excel but now users can import external Queries from the desired data sources available from the QPT Profile drop-down list.
2. Prior to saving and executing the required selected Queries, previously, the users filled different Threshold values (Pass, Information, and Warning) individually for every single Query but now users can click the ‘Cascade’ button option after filling the threshold values of one query and can later cascade the same to the rest of the Queries.
3. After executing the Queries, the user is navigated to the QPT ‘Summary’ tab. Previously, from the ‘Summary’ tab, the options such as Email and Excel (Download Summary Details) were in disable mode but now they are enabled.
4. Previously when the user clicked the email option from the QPT ‘Summary’ or ‘Details’ tab, only the QPT result Excel (Download Summary Details) was delivered to the email address but now the QPT result body is also delivered along with the Excel.

First Enhancement:

• Click the ‘SCENARIO STUDIO’ module.
• Hover on the left pane options to view ‘Query Performance Testing’ snippet.
• Click the ‘Query Performance Testing’ option.

Note: Alternatively, the user can click the ‘Query Performance Testing’ button available on the top to navigate to a new ‘QPT’ session page.

Path 01: SCENARIO STUDIO > Scenario Builder > Query Performance Testing

Path 02: SCENARIO STUDIO > Query Performance Testing button

• The user is navigated to a new ‘QPT’ session page.

• Let’s select ‘JnJ redshift’ from the ‘Profile’ drop-down list.

Note: By default, the ‘Existing Query Selection’ radio button is selected.

• Let’s select and click the ‘Choose File’ radio button.

Note: The ‘Choose File’ radio button is added as a new enhancement and the user can add external Queries from any desired data sources available within the QPT Profile drop-down list.

Note: As of now, the user cannot select both the radio button options (Existing Query Selection and Choose File) at once. In other words, the user cannot simultaneously use the ‘Existing Queries’ and ‘External Queries’ combination.

• Let’s select ‘RD QPT-redshift50quries’ excel sheet from the local drive.
• Click the ‘Open’ button.

• All 50 redshift queries are loaded and displayed under the ‘Choose File’ option.

Second Enhancement:

• Let’s select and checkbox the first six Queries.
• Click the ‘Proceed’ button.

• The user is navigated to the QPT tabular grid that has different columns such as Query, Pass Threshold, Information Threshold, Warning Threshold, and TimeOut.

• Let’s add 1 Minute for Pass Threshold, 2 Minutes for Information Threshold, and 3 Minutes for Warning Threshold.
• Click the Pass Threshold ‘Cascade’ button.

• The same 1 Minute added manually for ‘RedshiftQuery-1’ is cascaded to the rest of the ‘Pass Threshold’ Queries.
• Click the Information Threshold ‘Cascade’ button.

• The same 2 Minutes added manually for ‘RedshiftQuery-1’ is cascaded to the rest of the ‘Information Threshold’ Queries.
• Click the Warning Threshold ‘Cascade’ button.

• The same 3 Minutes added manually for ‘RedshiftQuery-1’ is cascaded to the rest of the ‘Warning Threshold’ Queries.

Note: Here ‘Cascade’ button is a new enhancement added.

• Now, click the ‘Save’ button.

• A ‘Save Query Performance Testing’ pop-up window is displayed.
• Let’s add ‘External Redshift Queries’ under the ‘Scenario Name’ text field.
• Click the ‘Save’ button.

• The user is navigated to the QPT tabular grid.
• The saved QPT Scenario appears as ‘Scenario Name: External Redshift Queries.’
• Click the ‘Execute Now’ button.

Note: ‘Execute Now’ button is enabled only after saving the QPT scenario.

Third Enhancement:

• The user is navigated to the ‘Query Performance Testing Summary’ session page.
• By default, the ‘Summary’ tab is selected and displayed.
• Here, the user can notice two buttons (Email and Download Summary Details) are enabled.

Note: ‘Email’ and ‘Download Summary Details’ are enabled in the ‘Summary’ tab which is a new enhancement here.

Fourth Enhancement:

• Let’s click the ‘Email’ button.

• A ‘Send an Email’ pop-up window is displayed.
• Let’s add an email address in the ‘Email’ text field.

Note: Email is blurred due to confidential data.

• Click the ‘Send’ button.

• A toaster message ‘Sending Email’ is displayed.

• The received email has the ‘QPT Result Body’, a new enhancement apart from the QPT Excel.