Skip to main content

Asset Registry--Networks Management (AX02US03)

Network Registry Management System - Comprehensive Test Cases

Test Case TC_001: Network Dashboard KPI Calculations and Real-Time Updates

Test Case Metadata

Test Case ID: AX02US03_TC_001
Title: Verify Network Dashboard KPI Calculations, Formulas, and Real-Time Data Updates
Created By:Prachi
Created Date: 2025-01-20
Version: 1.0

Classification

Module/Feature: Networks Management (AX02US03)

 Test Type: Functional, Data Validation
Test Level: System
Priority: P0-Critical
Execution Phase: Smoke
Automation Status: Planned-for-Automation

Enhanced Tags for 17 Reports Support

Tags: Happy-Path, KPI-Calculations, Real-Time-Data, Dashboard-Metrics, Formula-Validation, SCADA-Integration, Database-Queries, P0-Critical, Phase-Smoke, Type-Data-Validation, Platform-Web, Report-Engineering, Report-Product, MOD-Networks, Customer-Operations, Risk-Critical, Business-Critical, Revenue-Impact-Critical, Integration-Database, Integration-SCADA, Cross-Module-Asset-Registry

Business Context

Customer_Segment: Water Utility Operations
Revenue_Impact: Critical
Business_Priority: Must-Have
Customer_Journey: Operations-Monitoring
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

Risk_Level: Critical
Complexity_Level: High
Expected_Execution_Time: 8 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Database-Queries, SCADA-API, Real-time-Data-Engine
Code_Module_Mapped: AX
Requirement_Coverage: Complete
Cross_Platform_Support: Web, Mobile

Stakeholder Reporting

Primary_Stakeholder: Operations, Engineering
Report_Categories: KPI-Dashboard, Real-Time-Monitoring
Trend_Tracking: Yes
Executive_Visibility: Critical
Customer_Impact_Level: Critical

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome 115+, Firefox 115+
Device/OS: Windows 10/11, iOS 15+, Android 11+
Screen_Resolution: Desktop-1920x1080, Mobile-375x667
Dependencies: Database server, SCADA integration, Real-time data service
Performance_Baseline: KPI calculations < 2 seconds, Real-time updates < 5 seconds
Data_Requirements: 24 networks with complete operational data, SCADA feeds active

Prerequisites

Setup_Requirements: Network Operations Manager logged in, SCADA data flowing
User_Roles_Permissions: Network Operations Manager or Asset Manager role
Test_Data:

  • 24 total active networks
  • 3 networks with current_throughput > design_capacity
  • 12 leak complaint service orders in last 30 days
  • Network commission dates spanning 5-30 years for 18-year average
  • Real-time SCADA data feeds for capacity monitoring

Prior_Test_Cases: Login functionality (TC_LOGIN_001)

Test Procedure - 

Step #

Action

Expected Result

Test Data

Formula/Navigation Validation

1

Navigate via Dashboard > Asset Registry > Networks

Networks page loads with breadcrumb: "Dashboard > Asset Registry > Networks"

N/A

URL validation: /dashboard/asset-registry/networks

2

Verify page title and subtitle

Title: "Networks", Subtitle: "Manage and monitor your water distribution network infrastructure."



3

Verify Total Networks KPI calculation

Value displays "24"

24 networks

SQL: SELECT COUNT(*) FROM networks WHERE status = 'Active' 

4

Validate Total Networks formula

Count matches database query exactly

Database validation

Formula verification: COUNT(Network_ID) WHERE Status = 'Active'

5

Test Total Networks tooltip

Tooltip: "Total Active Networks - The total number of distinct water distribution networks currently registered and active in the system."

Tooltip text

Content accuracy: Hover validation, text verification

6

Verify Over Capacity KPI calculation

Value displays "3"

3 over capacity

SQL: SELECT COUNT(*) FROM networks WHERE current_throughput > design_capacity

7

Validate Over Capacity formula

Count includes only networks where current > design

Capacity validation

Formula: COUNT(Network_ID) WHERE Current_Throughput > Design_Capacity

8

Verify Over Capacity tooltip

Tooltip: "Networks Over Capacity - The number of networks where the current water throughput is higher than its designed capacity."

Tooltip accuracy

Content validation: Complete tooltip text

9

Validate Leak Complaints time range

Count includes only complaints from last 30 calendar days

Date range validation

Formula: COUNT(ServiceOrder_ID) WHERE Type = 'Leak Complaint' AND Creation_Date >= (Current_Date - 30)

10

Verify Leak Complaints tooltip

Tooltip describes 30-day scope and leak definition

Tooltip content

Content accuracy: Time range and type specification

11

Verify Average Age KPI calculation

Value displays "18 years"

18 years average

SQL: SELECT AVG(DATEDIFF(year, commission_date, GETDATE())) FROM networks WHERE deleted_at IS NULL

12

Validate Average Age formula

Average calculated from all active network commission dates

Age calculation

Formula: AVG(Current_Date - Commission_Date) for all networks

13

Test individual network age accuracy

Sample network ages match commission date calculations

Individual validation

Date arithmetic: Each network age = Current_Date - Commission_Date

14

Verify Average Age tooltip

Tooltip explains age calculation and portfolio implications

Tooltip validation

Content accuracy: Age calculation method description

Verification Points - KPI VALIDATION

Primary_Verification:

  • AC01: All KPI calculations mathematically accurate using specified formulas
  • AC02: KPI performance meets benchmarks (<2 seconds calculation time)
  • AC03: Mobile KPI display and functionality complete
  • AC04: Real-time data integration functional with SCADA systems

Secondary_Verifications:

  • Formula Accuracy: SQL queries produce exact KPI values
  • Data Consistency: KPIs consistent across user sessions
  • Performance: Calculations complete within time benchmarks
  • Error Handling: Graceful degradation when data unavailable

Negative_Verification:

  • Invalid data filtered out of calculations
  • Network outages handled gracefully
  • Calculation errors display appropriate messages
  • Performance degrades gracefully under load



Test Case TC_002: Network Data Export Functionality and File Validation

Test Case Metadata

Test Case ID: AX02US03_TC_002
Title: Verify Network Data Export - File Generation, Format Validation, and Content Accuracy
Created By:Prachi
Created Date: 2025-01-20
Version: 1.0

Classification

Module/Feature: Networks Management (AX02US03)

 Test Type: Functional, File Validation
Test Level: System
Priority: P1-Critical
Execution Phase: Regression
Automation Status: Manual

Enhanced Tags for 17 Reports Support

Tags: Happy-Path, Data-Export, File-Generation, CSV-Excel, Content-Validation, Filter-State, Download-Function, P1-Critical, Phase-Regression, Type-File-Validation, Platform-Web, Report-Engineering, MOD-Networks, Customer-Operations, Risk-Medium, Business-High, Revenue-Impact-Medium, Integration-Database

Business Context

Customer_Segment: Water Utility Operations, Management
Revenue_Impact: Medium
Business_Priority: Should-Have
Customer_Journey: Data-Analysis, Reporting
Compliance_Required: Yes
SLA_Related: No

Quality Metrics

Risk_Level: Medium
Complexity_Level: Medium
Expected_Execution_Time: 12 minutes
Reproducibility_Score: High
Data_Sensitivity: Medium
Failure_Impact: Medium

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Database-Query, File-Generation-Service, Browser-Download
Code_Module_Mapped: AX
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Operations, Management
Report_Categories: Data-Export, File-Management
Trend_Tracking: No
Executive_Visibility: Low
Customer_Impact_Level: Medium

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome 115+, Firefox 115+, Edge 118+
Device/OS: Windows 10/11, macOS 12+
Screen_Resolution: Desktop-1920x1080
Dependencies: Database server, File generation service
Performance_Baseline: Export generation < 10 seconds, File download < 5 seconds
Data_Requirements: 24 networks with complete data, various filter states

Prerequisites

Setup_Requirements: Network Operations Manager logged in, network data available
User_Roles_Permissions: Network Operations Manager, Asset Manager, or Plant Supervisor role
Test_Data:

  • 24 networks with complete metadata
  • Various network types: Distribution, Transmission, Service
  • Different statuses: Active, Maintenance, Planned
  • Geographic zones and service areas populated
  • File system permissions for downloads

Prior_Test_Cases: Network dashboard access (TC_KPI_001)

Test Procedure - 

Step #

Action

Expected Result

Test Data

Formula/Navigation Validation

1

Navigate to Networks Dashboard

Dashboard loads with Export button visible

N/A

UI validation: Export button placement and styling

2

Verify Export button placement

Button located in appropriate toolbar area

Export button

UI placement: Accessible location, proper styling

3

Click Export Data button

Download dialog appears or file downloads automatically

User action

Browser interaction: Download mechanism triggers

4

Verify export file format

File generated in CSV format with .csv extension

File extension

Format validation: Correct file type generation

5

Open exported CSV file

File opens successfully in spreadsheet application

File opening

File integrity: Successful file access

6

Verify CSV header structure

Headers match table columns exactly

Header validation

Structure validation: Column headers present and correct

7

Check required columns present

Network ID, Network Name, Type, Status, Capacity, Connections, Zones, Created By, Created On

Column pre

Back to top