Database Performance Whitepapers

ccppmop1591
This page presents the database performance load testing and analysis whitepaper for Oracle, Microsoft SQL, and PostgreSQL environments of
Clarity
15.9.1
.
3
Disclaimer
: This document is not meant as a sizing guide or as a recommendation guide. Instead, it portrays possible user loads given a particular
Clarity
configuration. We understand that customer requirements and environments differ. The
Clarity
functionality that is exercised during these performance load tests may or may not match the functionality that individual companies deploy. CA does not recommend that customers acquire hardware based on this document. Instead, seek the sizing expertise of our technical pre‐sales and professional services personnel. The test environments outlined in this document do not consider reporting, process engine, and background service or failover requirements.
This document is for your informational purposes only. CA assumes no responsibility for the accuracy or completeness of the information. To the extent permitted by applicable law, CA provides this document “as is” without warranty of any kind, including, without limitation, any implied warranties of merchantability, fitness for a particular purpose, or non-infringement. In no event will CA be liable for any loss or damage, direct or indirect, from the use of this document, including, without limitation, lost profits, business interruption, goodwill or lost data, even if CA is expressly advised in advance of the possibility of such damages.
MS SQL is a trademark or registered trademark of Microsoft Corporation in the United States and/or other countries.
Executive Summary
To establish and publish performance benchmarks, the
Clarity
software engineering team conducted a series of tests for
Clarity
15.9.1
in a clustered Linux environment. The following high-level enhancements were made to the test infrastructure:
  • To simulate real-world activity, user concurrency was set to 2,150 users. Existing customer application logs were analyzed to ensure test throughput (number of actions performed) is on par with a peak load for 2,150 concurrent users.
  • In addition to the user interface actions, we also ran a background process in volume during the test. The process exported an updated project using the XML Open Gateway (XOG) and ran approximately 600 times per hour.
The test objectives were to:
  • Demonstrate the ability of the product to serve a large‐sized user base (20,000 users) on Intel‐based hardware using either of the following databases:
    • Oracle 19c (19.3.0.0.0) and Apache Tomcat version 8.5.59 application servers on a Linux clustered environment.
    • SQL Server 2017 EE 64-bit SP2 CU21 (14.0.3335.7) and Apache Tomcat version 8.5.59 application servers.
    • PostgreSQL (11.7) and Apache Tomcat version 8.5.59 application servers.
  • Establish performance benchmarks under load using a core set of application functionality on Intel‐based hardware and a Linux environment.
Performance Test Methodology
The load tests use a mixture of inquiry and update actions to simulate end‐user interaction with the product. The tests used 2,150 virtual users to simulate a peak usage period for a total user population of 21,500 registered users. Wait times ranged from 3 to 45 seconds, depending on the type of action. The performance test is measured for 180 minutes, including a ramp‐up time of about 60 minutes.
The tests used a single database server with four application servers and with background instance on one of the application servers, all application servers and MS SQL DB, Oracle DB, PostgreSQL DB are running on virtual machines. The actual experience for you as a customer depends on how your hardware is set up, how many modules are deployed, how the user actions are distributed among the population, and the access rights that are granted to your users.
Testing at a 10% concurrency rate, 2,150 virtual users represent 21,500 registered users (2,150/.10=21,500). The 10% concurrency rate is typical for peak usage times.
Performance Test Results
Intel(R) Xeon(R) CPU @ 2.20GHz servers, each running one 15.9.1 application instance, can support a simulated load for 21,500 registered users (2,150 simultaneous virtual users) with Oracle or Microsoft SQL Server. Results are drawn from the 2,150-virtual-user 2.0-hour load tests.
New UI:
Summary of Test Results
Oracle
MS SQL
PostgreSQL (SaaS)
Average Transaction Response Time (in seconds)
0.37
0.67
0.75
Average Hits per second
53.17
53.22
54.06
Average Database Server CPU Utilization
26.50 %
28.00 %
25.30 %
Average Application Server 1 CPU Utilization
20.20 %
20.10 %
20.60 %
Average Application and Background Server 2 CPU Utilization
21.20 %
16.30 %
19.10 %
Average Application Server 3 CPU Utilization
20.60 %
18.90 %
21.40 %
Average Application and Background Server 4 CPU Utilization
23.50 %
17.20 %
23.60 %
Performance Test Conclusion
After comparing the average response times for the functionality between
15.9.1
and the previous release,
15.9.1
performance is equal to or better than the previous version.
Oracle
Clarity
Release
15.9.1
performs similar to the previous release on similar hardware comparing the same counters.
[(v15.9.0 avgresp – v15.9.1 avgresp)/ v15.9.0 avgresp)] = % improvement
(0.42 - 0.37) / 0.42 = 0.12 or 12%
MS SQL
Clarity
Release
15.9.1
performs similar to the previous release on similar hardware comparing the same counters.
Note: [(v15.9.0 avgresp – v15.9.1 avgresp)/v15.9.0 avgresp)] = % improvement
(0.62 - 0.67) / 0.62 = 0.08 or 8%
PostgreSQL (SaaS)
Clarity
Release
15.9.1
performs similar to previous release on similar hardware comparing the same counters.
Note: [(v15.9.0 avgresp – v15.9.1 avgresp)/v15.9.0 avgresp)] = % improvement
(0.75 - 0.75) / 0.75 = 0 or 0%
Database Performance Comparison by Release
Comparison by Functional Area
The following table shows the average response times by the major functional areas:
Functional Area
15.9.0 Oracle
15.9.1 Oracle
15.9.0 MSSQL
15.9.1 MSSQL
15.9.0 PostgreSQL (SaaS)
15.9.1 PostgreSQL (SaaS)
Total Avg Response time
0.42
0.37
0.62
0.67
0.75
0.75
New UI:
Functional Area
15.9.0 Oracle
15.9.1 Oracle
15.9.0 MSSQL
15.9.1 MSSQL
15.9.0 PostgreSQL (SaaS)
15.9.1 PostgreSQL (SaaS)
Project Management
0.77
0.79
0.85
0.90
0.94
1.00
Resource Management
0.36
0.40
0.90
1.25
0.65
0.70
Timesheets
0.25
0.30
0.50
0.60
0.77
0.90
Roadmaps
0.26
1.90
0.50
0.50
0.30
0.40
Financial Management
0.61
0.90
0.51
1.00
1.09
1.40
General Navigation
0.23
0.20
0.31
0.31
0.32
0.30
Portfolios
0.25
0.25
0.33
0.30
0.38
0.40
Comparison by Response Time
The following charts compare the response times for the two releases (shorter bars are better):
Oracle
image
MS SQL
image
PostgreSQL (SaaS)
image
Database Performance Test Environment
Load tests with 2,150 concurrent users were run. All tests were written and executed using BlazeMeter (Jmeter v4.0). Each virtual user simulates one real user actively and repeatedly clicking through a given scenario. Wait times reflect only interaction delays (for example, completing a form before clicking Submit), not idleness and task interruption. The background server ran all jobs, reports, and processes to completion prior to the start of the performance test.
For the load tests, we used two application servers and one background server, each on their own hardware server:
image
Application and Background server software:
  • OS: RHEL 7.6
  • Java: AdoptOpenJDK 11.0.9.1+1
  • App: Tomcat 8.5.59
Application server JVM memory parameters:
  • Xms1024m
  • Xmx6144m
Oracle database server software:
  • OS: RHEL 7.6
  • DB: Oracle 19.3.0.0.0 (with 'optimizer_features_enable' value '19.0.0' string type)
MS SQL Server software:
  • OS: Windows Server 2014 R2 Standard
  • DB: SQL Server 2017 EE 64-bit CU21 (14.0.3335.7)
PostgreSQL database server software:
  • OS: RHEL 7.6
  • DB: PostgreSQL 11.7
Application and Background server hardware:
  • CPU: Xeon(R) CPU E5-2630 v4 @ 2.20GHz
    CPU(s): 8
    Core(s) per socket: 2
    Socket(s): 4
  • RAM: 16 GB
Database server hardware:
  • CPU (Oracle): Intel(R) Xeon(R) Gold 5120 CPU @ 2.20GHz
    CPU(s): 32
    Core(s) per socket: 16
    Socket(s): 2
  • CPU (MSSQL): Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
    CPU(s): 32
    Core(s) per socket: 16
    Socket(s): 2
  • CPU (PostgreSQL): Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
    CPU(s): 64
    Core(s) per socket: 32
    Socket(s): 2
  • RAM: 120 GB (120 GB for Oracle; 120 GB for MS SQL Server; 120 GB for PostgreSQL Server)
MS SQL Parameters:
  • System Memory: 120 GB
  • Processors: 32
  • Min Server Memory: 5 GB
  • Max Server Memory: 100 GB
  • Max Worker threads: 10000
  • Cost Threshold for Parallelism: 50
  • Max Degree of Parallelism: 0 (unlimited)
  • Connection Timeout: 0 (no timeout)
  • Max Number of Concurrent Connections: 0 (unlimited)
Database Size Details
Oracle
Projects
Resources
Teams
Assignments
Tasks
DB Size
17,804
37,576
4,55,293
5,128,435
1,371,476
9.80 GB
MSSQL
Projects
Resources
Teams
Assignments
Tasks
DB Size
12,058
30,496
3,10,760
9,49,671
5,96,007
5.5 GB
PostgreSQL (SaaS)
Projects
Resources
Teams
Assignments
Tasks
DB Size
17,736
37,639
4,54,965
5,123,804
1,368,414
0.78GB
Database and App Server Performance Graphs
App and Background Server CPU Utilization (Oracle)
image2019-6-3_15-5-51.png
App and Background Server CPU Utilization (MSSQL)
image2019-6-3_15-2-5.png
App and Background Server CPU Utilization (PostgreSQL SaaS)
image2019-6-3_15-2-5.png
DB Server CPU Utilization (MSSQL)
The following graph displays the sum of CPU utilization over all CPUs (not the average).
image2019-3-3_17-21-30.png
DB Server CPU Utilization (PostgreSQL SaaS)
The following graph displays the sum of CPU utilization over all CPUs (not the average).
image2019-3-3_17-21-30.png
DB Server CPU Utilization (Oracle)
The following graph displays the sum of CPU utilization over all CPUs (not the average).
image2019-3-3_17-21-30.png
Heap Usage
The following graphs show the JVM heap usage during and after the load test for the application servers as well as the BG server.
Oracle
image2019-6-3_16-11-2.png
MSSQL
image2019-6-3_15-54-57.png
PostgreSQL (SaaS)
image2019-6-3_15-54-57.png
Database Performance Use Cases
The same use cases apply to both Oracle and MS SQL environments. Each functional area consists of the following use cases:
Use Case
Project Management
Resource Management
Financial Management
General Navigation
Timesheets and Approvals
Portfolio Management
Roadmaps
1
X
2
X
3
X
4
X
5
X
6
X
7
X
8
X
9
X
10
X
11
X
12
X
13
X
14
X
15
X
16
X
17
X
18
X
19
X
20
X
21
X
22
X
23
X
24
X
25
X
26
X
27
X
28
X
29
X
Use Cases: Detailed Steps
5
5
Use Case 1: Administration – All Page Script (Classic)
  1. Organization and Access Wait 2 seconds
    1. Resources
      1. Select resource Wait 2 seconds
      2. OBS and Partitions Wait 2 seconds
      3. Groups Wait 2 seconds
        1. Add Wait 2 seconds
        2. Back Wait 2 seconds
      4. Resource’s Access Rights – global Wait 2 seconds
        1. Add Wait 2 seconds
        2. Back Wait 2 seconds
      5. Access to this resource – Full view, Wait 2 seconds
        1. Continue Wait 2 seconds
        2. Add Wait 2 seconds
        3. Exit Wait 2 seconds
      6. Access to this resource –group Wait 2 seconds
        1. Add Wait 2 seconds
        2. Exit Wait 2 seconds
      7. Access to this resource – OBS unit Wait 2 seconds
        1. Add Wait 2 seconds
        2. Exit
      8. Groups Wait 2 seconds
      9. Select group Wait 2 seconds
        1. Resources Wait 2 seconds
          1. Add Wait 2 seconds
          2. Back Wait 2 seconds
        2. Group Access Rights – Instance Wait 2 seconds
          1. Add Wait 2 seconds
          2. Back Wait 2 seconds
          3. Group Access Rights – OBS Unit Wait 2 seconds
            1. Add Wait 2 seconds
            2. Exit Wait 2 seconds
          4. Group Access Rights – Global Wait 2 seconds
            1. Add Wait 2 seconds
            2. Back Wait 2 seconds
      10. OBS Wait 2 seconds
        1. New Wait 2 seconds
        2. Back Wait 2 seconds
  2. Studio
    1. Objects Wait 2 seconds
      1. Select Project: Wait 2 seconds
        1. Attributes Wait 2 seconds
          1. Select one Wait 2 seconds
          2. Back Wait 2 seconds
          3. New attribute Wait 2 seconds
          4. Back Wait 2 seconds
        2. Linking Wait 2 seconds
          1. Select one Wait 2 seconds
          2. Back Wait 2 seconds
          3. New Wait 2 seconds
          4. Back Wait 2 seconds
        3. Actions Wait 2 seconds
          1. Select one Wait 2 seconds
          2. Close Wait 2 seconds
          3. New Wait 2 seconds
          4. Close Wait 2 seconds
        4. Views Wait 2 seconds
        5. Audit Trail Wait 2 seconds
          1. Access To This Object Wait 2 seconds
          2. Full View Wait 2 seconds
          3. Resource Wait 2 seconds
          4. Group Wait 2 seconds
          5. OBS Unit Wait 2 seconds
      2. Queries Wait 2 seconds
        1. New Wait 2 seconds
        2. Back Wait 2 seconds
      3. Portlets Wait 2 seconds
        1. Select One
          1. Access To This Portlet
            1. Full View Wait 2 seconds
            2. Resource Wait 2 seconds
            3. Group Wait 2 seconds
            4. OBS Unit Wait 2 seconds
          2. Properties Wait 2 seconds
          3. Back Wait 2 seconds
        2. New Wait 2 seconds
          1. Chart Portlet Wait 4 seconds over 2 requests
          2. Grid Portlet Wait 4 seconds over 2 requests
          3. Filter Portlet Wait 4 seconds over 2 requests
          4. HTML Portlet Wait 4 seconds over 2 requests
          5. Interactive Portlet Wait 4 seconds over 2 requests
      4. Portlet Pages Wait 2 seconds
        1. Select one Wait 2 seconds
          1. Link Parameters Wait 2 seconds
            1. New Wait 2 seconds
            2. Back Wait 2 seconds
          2. Tabs Wait 2 seconds
            1. New Wait 2 seconds
            2. Back Wait 2 seconds
          3. Access To This Object Wait 2 seconds
            1. Back Wait 2 seconds
        2. New
          1. Back
      5. Add-Ins Wait 2 seconds
      6. UI Themes Wait 2 seconds
      7. Views Wait 2 seconds
        1. Select one Wait 2 seconds
          1. Exit Wait 2 seconds
  3. Data Administration
    1. Time Slices Wait 2 seconds
      1. Select one Wait 2 seconds
        1. Back Wait 2 seconds
      2. New Wait 2 seconds
        1. Back Wait 2 seconds
    2. Lookups Wait 2 seconds
      1. Select one Wait 2 seconds
        1. Parent Window Wait 2 seconds
        2. Values Wait 2 seconds
          1. Select one Wait 2 seconds
            1. Back Wait 2 seconds
        3. Auto Suggest Wait 2 seconds
          1. Back
        4. General Wait 2 seconds
          1. Back Wait 2 seconds
      2. New Wait 2 seconds
      3. Back Wait 2 seconds
    3. Reports and Jobs Wait 2 seconds
      1. Select one:
        1. Parameters Wait 2 seconds
          1. Access one Wait 2 seconds
            1. Back Wait 2 seconds
        2. Parameter order Wait 2 seconds
        3. Incompatible Jobs Wait 2 seconds
          1. Add Wait 2 seconds
            1. Back Wait 2 seconds
        4. Associated Categories Wait 2 seconds
          1. Add Wait 2 seconds
            1. Back Wait 2 seconds
        5. Access to this Job Wait 2 seconds
          1. Full View Wait 2 seconds
          2. Resource Wait 2 seconds
          3. Group Wait 2 seconds
          4. OBS Unit Wait 2 seconds
    4. Skills Hierarchy Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    5. Notifications Wait 2 seconds
      1. Select one. Wait 2 seconds
        1. Cancel Wait 2 seconds
  4. Project Management
    1. Timesheet Options Wait 2 seconds
    2. Time Reporting Periods Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    3. Charge Codes Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    4. Input Type Codes Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    5. Settings Wait 2 seconds
    6. Base Calendars Wait 2 seconds
      1. New Wait 2 seconds
        1. Close Wait 2 seconds
    7. Migrate Methods Wait 2 seconds
    8. Risk Settings Wait 2 seconds
  5. General Settings
    1. System Options Wait 2 seconds
    2. Site Links Wait 2 seconds
      1. New Wait 2 seconds
        1. Back Wait 2 seconds
    3. Client Downloads Wait 2 seconds
Use Case 2: PM Financial Planning (View and Edit Cost Plan) (Classic)
  1. View Cost Plan list page with 500 rows of cost plans. Wait 60 seconds divided over 6 requests.
  2. Open the detail of an existing Cost Plan. Wait 10 seconds.
  3. Update cost plan by repopulating and adding 4 additional detail rows. Wait 60 seconds divided over 6 requests.
  4. (Auto-addition of 3 rows by re-populate and manual addition of 1 row. Repeat for both re-populate types). Wait 120 seconds divided over 12 requests.
  5. View Benefit Plan list page (15 benefit plans). Wait 50 seconds over 5 requests.
Use Case 3: PM Financial Planning (Cost Plan 2) (Classic)
  1. Create Cost Plan (Two grouping attributes) and add a cost plan detail row. Wait 235 seconds over 24 requests.
Use Case 4: PM Financial Planning (Cost Plan 3) (Classic)
  1. Create Cost Plan from Investment Team (Project duration 1 year, # of team members – 15, FTP type - Monthly). Wait 27 seconds over 20 requests
Use Case 5: PM Financial Planning (Cost Plan 4) (Classic)
  1. Create Cost Plan from Task Assignments (Project duration 1 year, # of task assignments – 15, FTP type - Monthly) and open Benefit Plans page. Wait 90 seconds over 14 requests.
Use Case 6: PM Financial Planning (Cost Plan 5) (Classic)
  1. Log in. Wait 5 seconds.
  2. Click on Projects link. Wait 5 seconds
  3. Expand the Projects filter. Wait 5 seconds
  4. Filter for Project. Wait 5 seconds
  5. Open Project. Wait 5 seconds
  6. Click on Financial Plans tab. Wait 5 seconds
  7. Click on New Cost Plan from Investment Team. Wait 5 seconds
  8. Select Grouping Attributes. Wait 5 seconds
  9. Click Save for new Cost Plan from Investment Team. Wait 5 seconds
  10. Go to Cost Plan Detail 1. Wait 5 seconds
  11. Click Return for Cost Plan Detail 1. Wait 5 seconds
  12. Click New Cost Plan from Task Assignments. Wait 5 seconds
  13. Select Grouping Attributes 2. Wait 5 seconds
  14. Click Save for New Cost Plan from Task Assignments. Wait 5 seconds
  15. Go to Cost Plan Detail 2. Wait 5 seconds
  16. Click Return for Cost Plan Detail 2. Wait 5 seconds
  17. Filter for New Cost Plan 1. Wait 5 seconds
  18. Open New Cost Plan 1. Wait 5 seconds
  19. Select Populate from Task Assignments. Wait 5 seconds
  20. Click Return for Cost Plan 3. Wait 5 seconds
  21. Filter for New Cost Plan 2. Wait 5 seconds
  22. Open New Cost Plan 2. Wait 5 seconds
  23. Click Populate From Investment Team. Wait 5 seconds
  24. Click Return for Cost Plan 4. Wait 5 seconds
  25. Click Project Properties. Wait 5 seconds
  26. Click Return for Projects. Wait 5 seconds
  27. Log out of the application.
Use Case 7: Gantt Toolbar (Classic)
  1. Open CLARITY Login page. Wait 10 seconds.
  2. Log in to the application with user have Project create access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Project link. Wait 10 seconds.
  4. Click on the Filter project (+) icon. Wait 5 seconds.
  5. Filter for a project(with a min of 2000+ tasks associated to it). Wait 5 seconds.
  6. Click on filtered Project link to open project properties page. Wait 5 seconds.
  7. Click on Task tab. Wait 5 seconds.
  8. Click on Gantt link under Tasks tab. Wait 5 seconds.
  9. Click on Create New Task Icon on Gantt page. Wait 10 seconds.
  10. Enter the task name as task – I & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds.
  11. Enter the task name as task – II & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds.
  12. Enter the task name as task – III & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds.
  13. Enter the task name as task – IV & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  14. Enter the task name as task – V & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  15. Enter the task name as task – VI & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  16. Enter the task name as task – VII & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  17. Enter the task name as task – VIII & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  18. Enter the task name as task – IX & fill other required fields to create task with and click on Submit and Create New button. Wait 10 seconds
  19. Enter the task name as task – X & fill other required fields to create task with and click on Save button. Wait 10 seconds
  20. Click on filter Icon, enter the task name as ‘task’ and click on Filter button. Verify above tasks are available under search results. Wait 6 seconds
  21. Click on Copy Task from Template Icon on Gantt page. Wait 10 seconds
  22. Click on Filter Project Icon(+). Wait 5 seconds
  23. Filter for a project(with a min of 15+ resource and 80+ tasks associated to it). Wait 5 seconds
  24. Select the filtered project and click on Next button. Wait 5 seconds
  25. Click on + button to expand tasks. Wait 6 seconds
  26. Select the tasks and click on Copy button to copy tasks from template. Wait 6 seconds
  27. Click on Add Existing SubProject Icon on Gantt page. Wait 6 seconds
  28. Click on Filter Project Icon(+). Wait 10 seconds
  29. Filter for a project with a minimum of 15 resources and 80 tasks. Wait 5 seconds
  30. Select the filtered project and click on Add button to add subproject. Wait 5 seconds
  31. Click on Create New Project icon on Gantt page. Wait 15 seconds
  32. Enter the required fields to create project and click on Save and Return button. Wait 5 seconds
  33. Filter for the create project. Wait 5 seconds
  34. Select the filtered project and click on Assign Resources icon. Wait 5 seconds
  35. Filter a dev role Resource. Wait 37 seconds
  36. Select the filtered resource and Click on Assign button. Wait 10 seconds
  37. On Gantt page, select 3 tasks and click on Indent icon. Wait 5 seconds
  38. Click on expand button(+) of task having three indent tasks. Wait 5 seconds
  39. Select 2 tasks and click on Indent icon. Wait 5 seconds
  40. Click on expand button(+) of task having two indent tasks. Wait 5 seconds
  41. Select one task and click on Indent icon. Wait 10 seconds
  42. Click on expand button(+) of task having one indent task. Wait 10 seconds
  43. Select three top level tasks and Click on Indent icon. Wait 10 seconds
  44. Click on expand button(+) of task having three indent tasks. Wait 5 seconds
  45. Select above three indent tasks and click on Outdent tasks. Wait 5 seconds
  46. Select a task and click on Move task icon on Gantt page. Wait 5 seconds
  47. Click on Insert Before or Insert After buttons to move task to a particular place. Wait 5 seconds
  48. Select three tasks and click on Link icon. Wait 10 seconds
  49. Select same three tasks which are link and click on Unlink icon. Wait 10 seconds.
  50. Click on start date or finish date of task. Wait 5 seconds.
  51. Edit start date or finish date of Task – I. Wait 10 seconds.
  52. Edit start date or finish date of Task – II. Wait 10 seconds.
  53. Edit start date or finish date of Task – III. Wait 10 seconds.
  54. Edit start date or finish date of Task – IV. Wait 10 seconds.
  55. Edit start date or finish date of Task – V. Wait 5 seconds.
  56. Click on Save icon to save above changes for dates. Wait 5 seconds.
  57. On Gantt page, click Create Baseline icon. Wait 10 seconds.
  58. Enter the required fields to create baseline and click on Save button. Wait 10 seconds.
  59. Select five tasks and click on Update Task Baseline icon. Wait 10 seconds.
  60. Click on Yes button to confirm update task baseline for tasks. Wait 10 seconds.
  61. Select ten tasks and click on Delete (x) icon. Wait 10 seconds.
  62. Select three tasks and click on Delete (x) icon. Wait 5 seconds.
  63. Click on filter icon and click on Show all button to show all 2000+ tasks. Wait 5 seconds.
  64. Click on Expand all(+) icon. Wait 5 seconds.
  65. Click on Collapse all(-) icon. Wait 5 seconds.
  66. Log out.
Use Case 8: Gantt WBS List (Classic)
  1. Open CLARITY Login page. Wait 5 seconds.
  2. Log in to the application with user have Project create access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Project link. Wait 5 seconds.
  4. Click on the Filter project(+) icon. Wait 5 seconds.
  5. Filter for a project(with a min of 2000+ tasks associated to it). Wait 5 seconds.
  6. Click on filtered Project link to open project properties page. Wait 5 seconds.
  7. Click on Task tab. Wait 5 seconds.
  8. Click on Gantt link under Tasks tab. Wait 5 seconds.
  9. Select first task & click on Start date on Gantt page. Wait 5 seconds.
  10. Edit Start date & finish date of first task. Wait 5 seconds.
  11. Click on Save button to save dates for first task. Wait 5 seconds.
  12. Edit start date & finish date of first task (Row no 1). Wait 5 seconds.
  13. Edit start date & finish date of second task (Row no 2). Wait 5 seconds.
  14. Edit start date & finish date of third task (Row no 3). Wait 5 seconds.
  15. Edit start date & finish date of forth task (Row no 4). Wait 5 seconds.
  16. Edit start date & finish date of fifth task (Row no 5). Wait 5 seconds.
  17. Edit start date & finish date of sixth task (Row no 6). Wait 5 seconds.
  18. Edit start date & finish date of seventh task (Row no 7). Wait 5 seconds.
  19. Edit start date & finish date of eight task (Row no 8). Wait 5 seconds.
  20. Edit start date & finish date of ninth task (Row no 9). Wait 5 seconds.
  21. Edit start date & finish date of tenth task (Row no 10). Wait 5 seconds.
  22. Edit start date & finish date of eleventh first task (Row no 11). Wait 5 seconds.
  23. Edit start date & finish date of twelfth task (Row no 12). Wait 5 seconds.
  24. Edit start date & finish date of thirteenth task (Row no 13). Wait 5 seconds.
  25. Edit start date & finish date of fourteenth task (Row no 14). Wait 5 seconds.
  26. Edit start date & finish date of fifteenth task (Row no 15). Wait 5 seconds.
  27. Edit start date & finish date of sixteenth task (Row no 16). Wait 5 seconds.
  28. Edit start date & finish date of seventeenth task (Row no 17). Wait 5 seconds.
  29. Edit start date & finish date of eighteenth task (Row no 18). Wait 5 seconds.
  30. Edit start date & finish date of nineteenth task (Row no 19). Wait 5 seconds.
  31. Edit start date & finish date of twentieth task (Row no 20). Wait 5 seconds.
  32. Click on Save button to save all twenty changes & check the time taken for saving. Wait 5 seconds.
  33. Select a task and Click on Insert key/button on keyboard, a new row will be inserted under tasks to edit. Wait 5 seconds.
  34. Enter task name, start date & finish date. Wait 5 seconds.
  35. Click on Save button on Gantt page. Wait 5 seconds.
  36. Select a task, drag and drop into a new position (from top to bottom of the page). Wait 5 seconds.
  37. Select a task, drag and drop into a new position(causing the list to scroll). Wait 5 seconds.
  38. Click on scroll up to go starting point of task. Wait 5 seconds.
  39. Scroll down through the page to fetch next 100 records – I. Wait 5 seconds.
  40. Scroll down through the page to fetch next 100 records – II Wait 5 seconds.
  41. Scroll down through the page to fetch next 100 records – III Wait 5 seconds.
  42. Scroll down through the page to fetch next 100 records – IV Wait 5 seconds.
  43. Scroll down through the page to fetch next 100 records – V Wait 5 seconds.
  44. Scroll down through the page to fetch next 100 records – VI Wait 5 seconds.
  45. Scroll down through the page to fetch next 100 records – VII Wait 5 seconds.
  46. Scroll down through the page to fetch next 100 records – VIII Wait 5 seconds.
  47. Scroll down through the page to fetch next 100 records – IX Wait 5 seconds.
  48. Scroll down through the page to fetch next 100 records – X Wait 5 seconds.
  49. Scroll down through the page to fetch next 100 records – XI Wait 5 seconds.
  50. Scroll down through the page to fetch next 100 records – XII Wait 5 seconds.
  51. Scroll down through the page to fetch next 100 records – XIII. Wait 5 seconds.
  52. Scroll down through the page to fetch next 100 records – XIV. Wait 5 seconds.
  53. Scroll down through the page to fetch next 100 records – XV. Wait 5 seconds.
  54. Scroll down through the page to fetch next 100 records – XVI. Wait 5 seconds.
  55. Scroll down through the page to fetch next 100 records – XVII. Wait 5 seconds.
  56. Scroll down through the page to fetch next 100 records – XVIII. Wait 5 seconds.
  57. Scroll down through the page to fetch next 100 records – XIX. Wait 5 seconds.
  58. Click on Filter icon, enter the task name(which is having 4 levels of nested tasks) and click on Filter button. Wait 5 seconds.
  59. Click on the Expand(+) button of 4 level of nested task which is filtered. Wait 5 seconds.
  60. Click on the Expand(+) button for next 3 level of nested task. Wait 5 seconds.
  61. Click on the Expand(+) button for next 2 level of nested task. Wait 5 seconds.
  62. Click on the Expand(+) button for next 1 level of nested task. Wait 5 seconds.
  63. Click on Filter(+) icon, enter the task name(which is not having any resources assigned to it) and click on Filter button. Wait 5 seconds.
  64. Select the task and click on the resources field. Wait 5 seconds.
  65. Inline edit, enter resource name with dev role resource and select the resource to add to task. Wait 5 seconds.
  66. Inline edit, enter resource name with qa role resource and select the resource to add to task. Wait 5 seconds.
  67. Inline edit, enter resource name with lead role resource and select the resource to add to task. Wait 5 seconds.
  68. Click on the Save button to assign resources to task. Wait 5 seconds.
  69. Click on Filter icon, select the check box for ‘List View’ and click on Filter button. Wait 5 seconds.
  70. Click on Filter icon, enter the resource name under Assigned to Resources field and click on Filter button. Wait 5 seconds.
  71. Click on Filter (+) icon, enter the subproject name under Task name field and click on Filter button. Wait 5 seconds.
  72. Open Subproject which is filtered above, this opens a separate Gantt editing session. Wait 5 seconds.
  73. Click on the task start date field. Wait 5 seconds.
  74. Edit Start date of the task. Wait 5 seconds.
  75. Edit Finish date of the task. Wait 5 seconds.
  76. Click on Save button to save start & finish dates of task. Wait 5 seconds.
  77. Close the subproject Gantt window. Wait 5 seconds.
  78. Click on Refresh icon of master project. Wait 5 seconds.
  79. Click on Expand (+) button of Subproject to check the dates of task. Wait 5 seconds.
  80. Close Gantt window and Log out.
Use Case 9: Interactive Gantt Chart (Classic)
  1. Open CLARITY Login page. Wait 5 seconds.
  2. Log in to the application with user having Project management access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Project link. Wait 5 seconds.
  4. Filter for a project(with a min of 10+ tasks associated to it) Wait 5 seconds.
  5. Click on Project link to open project properties page Wait 5 seconds.
  6. Click on Task tab. Wait 17 seconds.
  7. Click on Gantt link under Tasks tab. Wait 5 seconds.
  8. On Gantt page, under Timescale section locate finish date of Gantt task bar. Wait 26 seconds.
  9. Use Gantt task bar (drag to change), change finish date. Wait 5 seconds.
  10. Click on save button. Wait 27 seconds.
  11. Use Gantt task bar (drag to change) change start date. Wait 23 seconds.
  12. Click on save button. Wait 36 seconds.
  13. Use Gantt task bar (drag to change) move entire task to later dates. Wait 23 seconds.
  14. Click on save button. Wait 5 seconds.
  15. Change timescale value(Random selection for each iteration to Days, Weeks, Month, Quarters &Years) on the Gantt chart using the toolbar widget. Wait 32 seconds.
  16. Move Gantt time periods forward one column by clicking on Next Period(>) Icon. Wait 28 seconds.
  17. Move Gantt timescale forward one set of time periods by clicking on Next 12 Periods(>>) Icon. Wait 5 seconds.
  18. Click on Save button to save the changes. Wait 42 seconds.
  19. Link two tasks using drag and drop for Finish date of first task to Start date of second task, this would create a dependency. Wait 29 seconds.
  20. Link two tasks using drag and drop for Start date of first task to Start date of second task, this would create a dependency. Wait 21 seconds.
  21. Unlink above two tasks dependencies by selecting the tasks and click on unlink button. Wait 27 seconds.
  22. Log out.
Use Case 10: Auto-Schedule (Classic)
  1. Open CLARITY Login page. Wait 5 seconds.
  2. Log in to the application with user having Project management access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Project link. Wait 5 seconds.
  4. Filter for a project(with a min of 15 resources & 50+ tasks associated to it). Wait 5 seconds.
  5. Click on Project link to open project properties page. Wait 5 seconds.
  6. Click on Unlock project button, if project is locked. Wait 5 seconds.
  7. Click on Task tab. Wait 5 seconds.
  8. Click on Gantt link under Tasks tab. Wait 5 seconds.
  9. Click on Autoschedule with Options -> Create Tentative Schedule. Wait 15 seconds.
  10. Edit Start date and Finish date. Wait 5 seconds.
  11. Click on Submit button. Wait 15 seconds.
  12. Click on Autoschedule with Options -> Publish tentative schedule. Wait 5 seconds.
  13. Click on Yes button to publish tentative schedule. Wait 5 seconds.
  14. Click on Autoschedule with Options icon Wait 5 seconds.
  15. Click on ‘Autoschedule’ button. Wait 5 seconds.
  16. Click on Autoschedule with Options -> Delete Tentative Schedule Wait 5 seconds.
  17. Click on Yes button to Delete tentative schedule Wait 10 seconds.
  18. Log out.
Use Case 11: General UI Behavior (Classic)
  1. Page refresh on Project List page that configured to list 50 projects per page. Wait 70 seconds over 6 requests.
  2. Drill-down on a project, and click on the Team tab and Detail subtab. Wait 28 seconds over 3 requests.
  3. Add a new TSV column in Detail page. Wait 83 seconds over 7 requests.
  4. Replace Assignment Roles. Wait 20 seconds over 2 requests.
  5. Select a Capacity Planning scenario from the “Team” tab Wait 40 seconds over 2 requests.
  6. Edit team member start date, team member finish date and allocation for at least 5 team members in this scenario and then click Save. Wait 42 seconds over 6 requests.
  7. Switch back to Plan of Record. Wait 10 seconds.
Use Case 12: Departments (Classic)
  1. Navigator. Wait 15 seconds over 2 requests.
  2. Departments (show 50 departments with 9 columns). Wait 5 seconds.
  3. Select department. Wait 5 seconds.
  4. Select resources. Wait 5 seconds.
  5. Select investments. Wait 5 seconds.
Use Case 13: Navigator – All Page Script (Classic)
  1. Overview Wait 20 seconds over 3 requests
  2. General Wait 5 seconds
  3. Organizer Wait 5 seconds
    1. Tasks Wait 5 seconds
    2. Calendar Wait 5 seconds
    3. Process Wait 5 seconds
    4. Notifications Wait 5 seconds
  4. Dashboards Wait 5 seconds
    1. New Wait 5 seconds
    2. Cancel Wait 5 seconds
  5. Portlets Wait 5 seconds
  6. Chart Wait 5 seconds
    1. Select one
      1. Select Graph and Next Wait 5 seconds
      2. Back Wait 5 seconds
  7. Grid Wait 5 seconds
    1. Select one Wait 5 seconds
    2. Cancel Wait 5 seconds
  8. Filter Wait 5 seconds
    1. Cancel Wait 5 seconds
  9. Interactive Wait 5 seconds
    1. Cancel Wait 5 seconds
  10. Timesheets Wait 5 seconds
  11. Reports and jobs Wait 5 seconds
    1. Jobs Wait 5 seconds
    2. Reports Wait 5 seconds
  12. Account settings Wait 5 seconds
    1. Proxy Wait 5 seconds
    2. Notifications Wait 5 seconds
    3. Software downloads Wait 5 seconds
    4. Personal information Wait 5 seconds
  13. Organization
  14. Departments Wait 5 seconds
    1. New Wait 5 seconds
    2. Cancel Wait 5 seconds
  15. Knowledge Store Wait 5 seconds
  16. IT Service Management Wait 5 seconds
  17. Services – Wait 5 seconds
    1. New Wait 5 seconds
    2. Cancel Wait 5 seconds
  18. Requirements Planning
  19. Release Planning Wait 5 seconds
    1. New Wait 5 seconds
    2. Cancel Wait 5 seconds
  20. Releases Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  21. Requirements Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  22. Portfolios Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  23. Projects Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  24. New from template Wait 5 seconds
    1. Cancel
  25. Select project Wait 5 seconds
    1. Dashboard Wait 5 seconds
    2. Team Wait 5 seconds
      1. Detail Wait 5 seconds
      2. Role Capacity Wait 5 seconds
      3. Participants Wait 5 seconds
      4. Participant Groups Wait 5 seconds
      5. Requisitions Wait 5 seconds
      6. Staff Wait 5 seconds
    3. Task Wait 5 seconds
      1. Task List Wait 5 seconds
      2. Assignments Wait 5 seconds
    4. Chargebacks Wait 5 seconds
      1. Options Wait 5 seconds
      2. Transactions Wait 5 seconds
      3. Debit Rules Wait 5 seconds
        1. New Wait 5 seconds
          1. Cancel Wait 5 seconds
    5. Processes Wait 5 seconds
    6. Properties Wait 5 seconds
      1. Cancel Wait 5 seconds
  26. Programs Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  27. Products Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  28. Other Work Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
  29. Demand Management Wait 5 seconds
    1. Ideas Wait 5 seconds
    2. New Wait 5 seconds
      1. Cancel Wait 5 seconds
    3. Incidents Wait 5 seconds
  30. Resource Management Wait 5 seconds
  31. Resources Wait 5 seconds
    1. New Wait 5 seconds
      1. Cancel Wait 5 seconds
    2. Select one. Wait 5 seconds
    3. Skills Wait 5 seconds
      1. Add Wait 5 seconds
      2. Back Wait 5 seconds
    4. Allocations Wait 5 seconds
      1. Add Wait 5 seconds
      2. Back Wait 5 seconds
    5. Document Manager Wait 5 seconds
  32. Resource planning Wait 5 seconds
    1. Allocations Wait 5 seconds
    2. Capacity Wait 5 seconds
    3. Investments Wait 5 seconds
    4. Workloads Wait 5 seconds
  33. Resource Finder Wait 5 seconds
    1. Filter Wait 5 seconds
  34. Enter Resource ID Wait 5 seconds
    1. Search
      Wait 5 seconds
      1. Select one. Wait 5 seconds
  35. Skills Wait 5 seconds
    1. Add Wait 5 seconds
    2. Back Wait 5 seconds
  36. Allocations Wait 5 seconds
    1. Add Wait 5 seconds
      1. Back Wait 5 seconds
  37. Document Manager Allocations Wait 5 seconds
  38. Calendar Wait 5 seconds
  39. Properties Wait 5 seconds
    1. Cancel Wait 5 seconds
  40. Resource Requisitions Wait 5 seconds
  41. Transaction Entry Wait 5 seconds
    1. New Wait 5 seconds
    2. Transaction Entry Wait 5 seconds
  42. Post to WIP. Wait 5 seconds
  43. Create WIP Adjustment. Wait 5 seconds
  44. Approve WIP Adjustment. Wait 5 seconds
  45. Transactions. Wait 5 seconds
  46. Invoices. Wait 5 seconds
Use Case 14: PM Rate Matrix (Classic)
  1. Open Rate/Cost Matrix. Wait 10 seconds.
  2. Create a new Matrix row properties page (5 assigned columns). Wait 45 Seconds over 5 requests.
Use Case 15: Approve Timesheet (Classic)
  1. Open a Timesheet. Wait 40 seconds over 5 requests.
  2. Approve Timesheet. Wait 5 seconds.
Use Case 16: New Portfolio (Classic)
  1. Log in. Wait 10 seconds over 2 requests.
  2. Click on Portfolios Link. Wait 5 seconds.
  3. Click on New portfolio button. Wait 20 seconds.
  4. Enter details and click Save. Wait 5 seconds.
  5. Click on Manual link. Wait 20 seconds.
  6. Click on Contents Editor tab. Wait 10 seconds.
  7. Select Projects, Assets and Applications and click on Include button. Wait 5 seconds.
  8. Click on Build Power Filter link for Projects. Wait 5 seconds.
  9. Select Description as power filter. Wait 10 seconds.
  10. Add Description as to power filter. Wait 5 seconds.
  11. Click on Evaluate button to validate the filter. Wait 5 seconds.
  12. Click Save and Return for Projects power filter. Wait 5 seconds.
  13. Click on Build Power Filter link for Assets. Wait 5 seconds.
  14. Select Description as power filter. Wait 10 seconds.
  15. Add Description as to power filter. Wait 5 seconds.
  16. Click on Evaluate button to validate the filter. Wait 5 seconds.
  17. Click Save and Return for Assets power filter. Wait 5 seconds.
  18. Click on Build Power Filter link for Applications. Wait 5 seconds.
  19. Select Description as power filter. Wait 10 seconds.
  20. Add Description as to power filter. Wait 5 seconds.
  21. Click on Evaluate button to validate the filter. Wait 5 seconds.
  22. Click Save and Return for Applications power filter. Wait 5 seconds.
  23. Click on Properties tab. Wait 5 seconds.
  24. Click on Synchronization Schedule link. Wait 10 seconds.
  25. Click on Sync Now button. Wait 10 seconds over two requests.
  26. Log out of the application.
Use Case 17: New Portfolio (Classic)
  1. Log in. Wait 10 seconds over two requests.
  2. Click on Portfolios link. Wait 5 seconds.
  3. Expand the filter. Wait 3 seconds.
  4. Filter for portfolio. Wait 3 seconds.
  5. Open portfolio. Wait 3 seconds.
  6. Click on Plans tab. Wait 5 seconds.
  7. Click on New button for new plan. Wait 10 seconds.
  8. Enter details and save plan 1. Wait 10 seconds.
  9. Select the created plan and click on Copy button. Wait 10 seconds.
  10. Enter details and save plan 2. Wait 5 seconds.
  11. Click on Investments tab. Wait 5 seconds.
  12. Click on Plans tab. Wait 5 seconds.
  13. Select plan 1 to edit. Wait 10 seconds.
  14. Edit and save plan 1. Wait 5 seconds.
  15. Click on Targets tab. Wait 10 seconds.
  16. Select plan 2 to edit. Wait 20 seconds.
  17. Edit and save plan 2. Wait 5 seconds.
  18. Return to plans list. Wait 5 seconds.
  19. Select plans 1 and 2 to delete. Wait 5 seconds.
  20. Delete selected plans. Wait 5 seconds.
  21. Log out of the application.
Use Case 18: PM Resource Management: Working with resources (Classic)
  1. Open CLARITY Login page. Wait 10 seconds.
  2. Log in to the application with user having Resource management access rights. Wait 5 seconds.
  3. Click on Home -> Resource Management -> Resource link, to view the Resource List page. Wait 5 seconds
  4. Filter a resource which is allocated to at least 25 Projects. Wait 5 seconds.
  5. Click on the Resource Link, this will navigate to Resource properties page. Wait 10 seconds.
  6. Click on the Resource Allocations tab and view data on the Summary page. Wait 5 seconds.
  7. Click on Next Page Icon to go to Page 2 (assumes rows per page is set to 20). Wait 5 seconds.
  8. Click on Previous Page Icon to come back to Page 1. Wait 10 seconds.
  9. Click on Allocations - Detail page (this one has a TSV on it). Wait 10 seconds.
  10. Click on Next Periods (>) button under Allocation by Period section; advance time periods forward one set of periods. Wait 5 seconds.
  11. Click on Home -> Resource Management -> Resource Planning link. Wait 10 seconds.
  12. Click on Resource Planning -> Allocations tab. Wait 5 seconds.
  13. Click on Resource Planning -> Investments tab. Wait 5 seconds.
  14. Click on Resource Planning -> Capacity tab. Wait 5 seconds.
  15. Log out.
Use Case 19: PM Resource Management: Hard book and staff a resource to an investment
  1. Pin 20 resources from the Resources-to-Investments view.
  2. Go to the “Pinned” tab to view the pinned resources.
    1. “Expand All” to see all of the investments that are allocated to each team member under the “Pinned” tab
  3. Search for investment name “Vacation”
    1. Expand one of the resources that has the “Vacation” investment
Use Case 20: PM Resource Management: Request a role from the ItoR view – View data in the RtoI view
  1. Login in as a resource manager and to the RtoI view
  2. In the telescope, select all of the time periods
  3. Find a resource that is soft booked on the investment and make the resource hard booked for that investment
  4. From within the RtoI view for the investment in step 3, click on a DBA role request to replace with a resource
    1. Replace role with a resource in the flyout menu
    2. Click on the “Conversations” tab and enter, “Please let me know if there is anything else you need for staffing your investment.”
  5. Go to the role request view, click on an Architect role request to replace as a resource
    1. Replace role with a resource in the flyout menu
    2. Click on the “Conversations” tab and enter, “Please let me know if there is anything else you need for staffing your investment.”
Use Case 21: PM Role Management: search resources, change booking status, replace allocation
  1. go to the ItoR view under Resource Management
  2. In the telescope, select all of the time periods
  3. Expand an investment to see all of the resources under an investment
  4. For an investment, add an Architect role
  5. For the record added in step #3, click into row to expand the flyout to update the following:
    1. For each role added, set the “Resource Manager” field to appropriate “rm###_mgr###” user
    2. Set Forecast Rate to $185
    3. Click on the “Conversations” tab and enter, “Can I get an architect at this rate?”.
  6. For the Architect roles, set FTE to “1” for the first fiscal period
  7. Copy and paste the value of the first fiscal period to the all of the other remaining fiscal periods
  8. In the role request view, select an investment and add a DBA role
    1. For each role added, set the “Resource Manager” field to appropriate “rm###_mgr###” user
    2. Set Forecast Rate to $175
    3. When on the DBA role, click on the “Conversations” tab and enter, “I need a person for this role, ASAP”.
Use Case 22: Roadmaps
Create and Update Roadmap Items
  1. While in the timeline,
    1. Set SWIMLANE=Status and Color=Type
    2. Under Settings, set Metrics MVL to Capacity, Capital Cost and Operating Cost
  2. Create five roadmap items in the timeline, board and grid layouts
    1. Verify that 15 roadmap items are visible in all of the layouts 
  3. In the grid layout, set five of the roadmap items to Compliance=Does Not Apply
Create and View Custom Global and Local Picklists
  1. Create a local picklist called, Approved with values Yes, No
    1. Set color mapping
      1. Yes=Green
      2. No=Red
  1. In the grid layout, set 10 of the roadmap items to Approved=Yes
  2. View in each layout the results when selecting the Compliance and Approved picklists
    1. Select Compliance in the Column/Swimlane picklist on the Board and Timeline respectively.   For Color picklist, select Compliance picklist
    2. Select Approved in the Column/Swimlane picklist on the Board and Timeline respectively.  For the Color picklist, select Approved picklist
Use Case 23: Tasks Board
  1. Click on “Tasks” tab and go to the Task List
  2. Create 5 Phases
  3. Create 2 milestones under different parent tasks
  4. Create 10 tasks under various phases
    1. Add 5 assignments to each task
  5. Create 15 ToDos for each Phase, Milestone and tasks
  6. For 5 tasks, delete the role and add a resource
  7. Mark 10 tasks completed
  8. Filter on TYPE=Task and STATUS=Open
  9. Click on the Task Board icon
    1. Create 10 tasks under the “Incoming” column and an “Owner” for each task and 5 assignments to each task
    2. Hover over the “Planned” column and click the to insert a new column.
    3. Drag-n-drop each task created under the “Incoming” column into the column create in the previous bullet.
    4. Create a task conversation for each of the 10 tasks created above
  10. Clear filter parameters
  11. Search for a task in the Search Task text box.
  12. All of the steps above should be performed by every team member on a large project to test heavy load.
Use Case 24: Create Projects (Classic)
  1. Open CLARITY Login page. Wait 10 seconds.
  2. Log in to the application as a user who has been granted the
    Project - Create
    access right. Wait 5 seconds.
  3. Click Home, Portfolio Management, Projects. Wait 10 seconds.
  4. Click New button on Project list page. Wait 20 seconds.
  5. Enter the all required fields to create project and click on Save button. Wait 10 seconds.
  6. Click Team tab. Wait 10 seconds.
  7. Click Add button to add resources to project. Wait 15 seconds.
  8. Filter for a Dev role resource to add to this project. Wait 15 seconds.
  9. Click Add and Select More button to add Dev resources to project. Wait 10 seconds.
  10. Filter for a QA role resource to add to this project. Wait 15 seconds.
  11. Click Add and Select More button to add QA resources to project. Wait 10 seconds.
  12. Filter for a Lead/Manager role resource to add to this project. Wait 15 seconds.
  13. Click on Add and Select More button to add Lead/Manager resources to project. Wait 10 seconds.
  14. Click on Task tab. Wait 5 seconds.
  15. Click on Gantt link from drop-down of Task tab to open the Gantt Editing Session. Wait 5 seconds.
  16. Click on Add Existing Subproject icon on Gantt page. Wait 5 seconds.
  17. Filter a Project (which is having 3 tasks) to add as a Subproject for created project. Wait 10 seconds.
  18. Select the filtered project and click on Add button to add as a subproject. Wait 10 seconds.
  19. Open the Subproject which is added, this opens a new Gantt editing window. Wait 10 seconds.
  20. Click on Add Existing Subproject icon on Subproject Gantt page. Wait 10 seconds.
  21. Filter a Project (which is having 3 tasks) to add as a Subproject. Wait 10 seconds.
  22. Select the filtered project and click on Add button to add as a subproject. Wait 10 seconds.
  23. Open the Subproject which is added to existing subproject, this opens a new Gantt editing window. Wait 10 seconds.
  24. Change one of the tasks by editing the start and finish dates. Click on Save button. Wait 55 seconds over 4 requests.
  25. Close the Gantt window. Wait 10 seconds.
  26. Refresh the parent Gantt window. Wait 10 seconds.
  27. Close this Gantt window. Wait 10 seconds.
  28. Refresh the master project Gantt window. Wait 10 seconds.
  29. Click Expand All. Verify that the changed task dates appear. Wait 9 seconds.
  30. Close the Gantt editing window. Wait 10 seconds.
  31. Log out.
Use Case 25: Create Projects
  1. Click on “Projects” from the left nav
  2. Search for “Add New Project” tile and click on that tile to create a project from template
  3. Select the project template that you created you created from the pre-requisites
  4. Add Project Name and update the “Start Date” to the project under the “Details” tab
Use Case 26: Timesheets (Classic)
  1. Open CLARITY Login page. Wait 10 seconds.
  2. Log in to the application with user having Timesheet submit access rights. Wait 3 seconds.
  3. Click on Home -> Personal -> Timesheet link. Wait 10 seconds.
  4. Filter Timesheet for same user & with a specific time period like start date - 1/1/20xx and end date - 1/7/20xx. (Pre-condition – User should have 2 or more tasks associated to a project and also Timesheet should be in Returned state, to modify, add/delete tasks, Submit/Return Timesheet). Wait 3 seconds.
  5. Click on Timesheet icon this will open timesheet page with time entry details for editing. Wait 3 seconds.
  6. Click on ‘Populate’ button, this would try to re-populate timesheet page asking for a confirmation. Wait 3 seconds.
  7. Confirm repopulate, click Yes button. Wait 5 seconds.
  8. Select and delete time entries of a task from timesheet page; this would navigate to next page for a confirmation to delete. Wait 3 seconds.
  9. Confirm Delete by clicking the Yes button. Wait 3 seconds.
  10. Click on Add Task button to show tasks available for this resource for time entry. Wait 5 seconds.
  11. Select the task which was deleted in a previous step (Step 8) and click Add. Wait 15 seconds.
  12. Fill the time entry details with 8 hours each from Monday to Friday and click on Submit for Approval button to submit timesheet. Wait 3 seconds.
  13. Open the Submitted timesheet by clicking on Timesheet icon. Wait 3 seconds.
  14. Click on Return timesheet button. Wait 3 seconds.
  15. Log out.
Use Case 26: Timesheets
Submit Timesheet – Use-Case 1
  1. Login as one of the timesheet submitters and have them access their current time periods timesheet
  2. Click on “Populate Timesheet” button and select only “Include tasks assigned to me”.
  3. Enter 8h for Monday for “Vacation Time”
    1. Enter a timesheet line item note for this item saying, “Taking time off for my birthday”
  4. For the 1st task enter 2h for Tues-Fri
    1. Set Input Type Code-Billable; Charge Code=Planning
  5. For the 2nd task enter 3h for Tues-Fri
  6. For the 3rd task enter 3h for Tues-Fri
    1. Set Input Type Code-Billable; Charge Code=Planning
  7. Delete the last timesheet line item
  8. Enter a timesheet note saying, “Please Approve ASAP”.
  9. Submit Timesheet
Submit Timesheet – Use-Case 2
  1. Login as the same timesheet submitter from scenario 1 and access the next time period after what was selected from scenario 1
  2. Click on “Populate Timesheet” button and select “Copy entries from previous timesheet” and “Include hours”
  3. Delete the “Vacation Time” time entry
  4. For the 1st task enter 2h for Tues-Fri
    1. Set Input Type Code-Billable; Charge Code=Planning
  5. For the 2nd task enter 3h for Tues-Fri
  6. For the 3rd task enter 3h for Tues-Fri
    1. Set Input Type Code-Billable; Charge Code=Planning
  7. Add the timesheet line item that was deleted in scenario 1 and add it to the timesheet; Enter 4h for Monday
  8. Enter a timesheet note saying, “Please Approve ASAP”.
  9. Submit Timesheet
  10. Click on “Return Timesheet”
  11. Change to 8h for the value in step 7 for Monday
  12. Submit Timesheet
Approve Timesheet - Use-Case 3
  1. Login as Ray Jordan
  2. Click on “Review and Approve” tab
  3. Click on the “Open” and “Submitted” tile filter
  4. Drill down on the first record on the list and view the timesheet details
    1. Click the “Approve” button
  5. Drill down on the 5th record on the list and view the timesheet details
    1. Enter a timesheet note saying, “Please enter no more than 40 hours”
    2. Click the “Return” button
  6. Click on “Send Reminder” from the “Open” tile filter
  7. Click on “Submitted” tile filter
    1. Click on “Approve All” from the tile filter
  8. Scroll through 5 pages of the approver list
  9. Navigate to the next time period in the timesheet period carousel
  10. Navigate again to the next time period in the timesheet period carousel
  11. Search for a resource in the search text box.
Use Case 27: PM Projects (Classic)
  1. Go to Homepage. Wait 10 seconds.
  2. Log in to the application. Wait 5 seconds.
  3. View Project List. Wait 5 seconds.
  4. Open an existing Project. Wait 5 seconds.
  5. Access Project Dashboard tab with OOTB portlets. Wait 5 seconds.
  6. Access Project Properties and Project Team tabs Wait 15 seconds over 2 requests
  7. Use "Set Allocation" object action to update 15 selected team members to have 50% allocation. Wait 20 seconds over 2 requests.
  8. Use object action for "Commit Planned Allocation" to hard book selected team members. Wait 10 seconds over 2 requests.
  9. Log out.
Use Case 27: Create Project from Template (Classic)
  1. Open CLARITY Login page. Wait 10 seconds.
  2. Log in to the application with user having Project create access rights. Wait 5 seconds.
  3. Click on Home -> Portfolio Management -> Projects link. Wait 10 seconds.
  4. Click on New from Template button. Wait 5 seconds.
  5. Click on Filter Project Icon(+) button. Wait 10 seconds.
  6. Filter for Project template. (We use three different templates for each iteration. The first project has 15 resources and about 80 tasks; the second project has 50 resources and 264 tasks; and the third project has 15 resources and 120 tasks.) Wait 10 seconds.
  7. Select template and click on Next button. Wait 10 seconds.
  8. Enter all required fields to create a project and Click on Save button. Wait 5 seconds.
  9. Log out.
Use Case 27: PM Projects - Project Tiles
  1. In the main menu, click Projects.
  2. Scroll down 85% of the page will trigger the infinite scroll to view other projects. Trigger the infinite scroll 10 times to validate the performance of infinite scroll.
  3. In the Advanced Filter, select Active Status filter parameter and select Active.
  4. In the Search text box, search for some projects using:
    1. Alpha text
    2. Numeric text
  5. Drill down into a large project representing heavy load using the module links:
    1. Drill-down on the Project Details and then go back to the Project Tiles page
    2. Drill-down on the Status Report and then go back to the Project Tiles page
    3. Drill-down on the Project Tasks and then go back to the Project Tiles page
Use Case 28: PM Financial Transactions (Classic)
  1. View Transaction Vouchers List Page (20 records on first page). Wait 25 seconds over 5 requests.
  2. View Transactions (Detail) List Page - Should Include 20 Transactions. Wait 5 seconds.
  3. Create a new transaction, retain values then click Submit and Create new. Wait 40 seconds over 7 requests.
Use Case 29: Conversations
  1. Open a large project to test heavy load on the server.
  2. Start 10 conversations.
  3. Add 20 new team members to the project.
  4. Edit a conversation.
  5. Delete a conversation.
  6. Change the Finish Date to finish two weeks later.
Use Case 33: FLS Consumption
Data setup:
  1. Create two groups of users 50% each (GroupWithAttrRights and GroupWithoutAttrRights)
  2. Create a project - AttrProject or take any already created project
  3. Create a idea - AttrIdea or take any already created Idea
  4. Give Project Instance rights and Idea Instance rights on the project and idea created above to GroupWithAttrRights and GroupWithoutAttrRights.
  5. Navigate to Blueprints and create a copy of Standard project and Standard idea.
  6. Open Details page and add 'Approved By' field to both the template.
  7. Login as admin and secure 10 project attributes and 10 idea attributes.
  8. Navigate to Projects workspace and open AttrProject.
  9. Create view1 with one of the secured attributes as column.
  10. Create view2 with one of the secured attribute as filter.
  11. Navigate to Board view and click on view options.
  12. Create view3 with one of the sceured attribute as 'Columns' in Board options and 'Card Fields' in Card options.
  13. Navigate to Ideas workspace and open AttrIdea.
  14. Repeat steps 3 to 6 for idea
Steps:
  1. Login as GroupWithAttrRights user.
  2. Navigate to Projects workspace and open AttrProject.
  3. Verify user is able to view all 3 views and all secured attributes.
  4. Navigate to Ideas workspace and open AttrIdea.
  5. Verify user is able to view all 3 views and all secured attributes.
  6. Login as GroupWithoutAttrRights user.
  7. Navigate to Projects workspace and open AttrProject.
  8. Verify user is able to view all 3 views and but not secured attributes.
  9. Navigate to Ideas workspace and open AttrIdea.
  10. Verify user is able to view all 3 views but not secured attributes.
Use Case 34: Idea Financials - TSV aggregate
Data setup:
  1. Created Location Obs, Department Obs, Entity, Idea and cost plan for idea.
  2. Users are created with following rights:
  3. Global rights :IdeasNavigate, ApiAccess,IdeaManagement
  4. Instance right IdeaCostPlanView and IdeaView on PerfIdeaTsv (Idea)
Steps:
  1. Log in to clarity
  2. Navigate to Idea workspace
  3. Open PerfIdeaTsv idea and navigate to Idea Financial Tab
  4. Open costplan-Plan of record. Cost plan has 3030 detail rows and Cost Type, Department, Resource as grouping attributes.
  5. Open View option
  6. Select cost, revenue and units
  7. Group by department (after grouping, there are 110 groups created)
  8. Expand one of the department.
  9. Remove Grouping
  10. Logout
Use Case 35: Project Staff - TSV aggregate
Data setup:
  1. Created a project and added 280 staff members with 50% and 100% allocation.
  2. Users are created with following rights:
  3. Global rights: Projects - Navigate, ApiAccess, Project Management - Navigate
  4. Instance right : Project - View Management on staffProject (Project)
Steps:
  1. Log in to Clarity
  2. Change General Settings for half of the users : Change UNIT OF MEASURE to hours.
  3. Navigate to Project workspace.
  4. Open staffProject project and navigate to Project Staff Tab.
  5. Staff Grid has 280 rows.
  6. Open View option.
  7. Select Allocation and Hard Allocation.
  8. Group by role (after grouping, there are 110 groups created).
  9. Remove Grouping.
  10. Logout
Use Cases: Detailed Load Test Results
The following file provides the 2,000-user load test results for each transaction:Clarity 15.9.1 Load Tests