Test Manager data model

Reference for the Test Manager data model terms, dimensions, and measures used to build Insights dashboards.

This reference lists the Explores, views, dimensions, and measures of the Looker-based data model behind Insights dashboards, with tables of the available dimensions and measures. Availability depends on the cloud platform you use.

Terms and concepts

The structure of the Test Manager data model is based on the following concepts.

Explore

The starting point for exploration.

The data is surfaced via Explores. An Explore is a general entity that corresponds to the fields within it.

View

A view represents a table of data, whether that table is native to your database or was created using the derived table functionality of Looker.

Within each view are field definitions, each of which typically corresponds to a column in the underlying table or a calculation in Looker.

Dimension

As part of a View within the Explore, the Dimension is a groupable field and can be used to filter query results.

It can be one of the following:

• An attribute, which has a direct association to a column in an underlying table.
• A fact or numerical value.
• A derived value computed based on the values of other fields in a single row.

Measure

As part of a View within the Explore, the Measure parameter declares a new measure (aggregation) and specifies a name for that measure.

Examples of measures types: integer , string .

Dimensions and measures

Feature availability depends on the cloud platform you use. For details, refer to the Test Manager feature availability page.

Note:

The Requirements, Test sets, and Test executions dimensions and measures are available in Test Manager only when delivered via Test Cloud.

Test case logs

The following tables describe the available dimensions and measures for test case logs.

Table 1. Test Case Logs dimensions

Dimension	Type	Description
Assignee Email	string	The email address of the user to which a test case was assigned to.
Automation Project Name	string	The name of the automation linked to the test case.
Due Date	date	The date when a manual test case was scheduled to have been executed.
Execution Start	date	The date when the test execution started.
Executed By	string	The username or robot name who executed the test.
Execution End	date	The date when the test execution ended.
Execution Type	string	The type of the execution: Automated for automated tests, Manual for manual tests, or None for test cases that are not executed and are in the Pending state.
Host Machine Name	string	The name of the machine.
Project Name	string	The name of the Test Manager project.
Project Prefix	string	The prefix of the Test Manager project.
Reporting Date	date	The date when the test was executed. This is a date without time and also without time zone.
Result	string	The test case result: Passed, Failed, or None.
Robot Name	string	The name of the robot that executed the test.
Test Execution Name	string	The name of the test execution.

Table 2. Test Case Logs measures

Measures	Type	Description
Total Count	integer	The total number of test case logs.
Passed Count	string	The number of passed test case logs.
Failed Count (Technical)	integer	Technical results indicate results as failed when an exception occurs during execution.
No Result Count (Technical)	integer	Technical results indicate no results when an exception occurs during execution.
Duration in Seconds	integer	Total runtime in seconds.

Requirements

The following tables describe the available dimensions and measures for requirements.

Table 3. Requirement dimensions

Dimension	Type	Description
Project Name	string	A combination of the project name and project prefix aimed to make it unique and increase readability.
Name	string	A combination of the requirement key and its name, aimed to make it unique and increase readability.

Table 4. Requirement measures

Measure	Type	Description
Total test case count	integer	The number of test cases assigned to a requirement.
Automated test case count	integer	The number of automated test cases assigned to a requirement.
Manual test case count	integer	The number of manual test cases assigned to a requirement.
Passed test case count	integer	The number of test cases assigned to a requirement that have passed in the latest test run.
Failed test case count	integer	The number of test cases assigned to a requirement that have failed in the latest test run.
None test case count	integer	The number of test cases assigned to a requirement with no result in the latest test run.
Total requirements count	integer	The total number of requirements.

Test sets

The following tables describe the available dimensions and measures for test sets.

Note:

For assigned test cases, the test set view contains information about static test assignments.

Table 5. Test set dimensions

Dimension	Type	Description
Project Name	string	A combination of the project name and project prefix aimed to make it unique and increase readability.
Name	string	A combination of the project name and project prefix aimed to make it unique and increase readability.
Robot name	string	The name of the robot that executed the test set.
Source	string	The source of the test set: Orchestrator or Test Manager.

Table 6. Test set measures

Measure	Type	Description
Total test set count	integer	The number of test sets.
Automated test case count	string	The number of automated test cases in the test set.
Manual test case count	integer	Number of manual test cases in the test set.

Test execution

The following tables describe the available dimensions and measures for test executions.

Table 7. Test executions dimensions

Dimension	Type	Description
Project Name	string	A combination of project prefix and name to make it unique and increase readability.
Name	string	A combination of execution ID and name to make it unique and increase readability.
Test set name	string	A combination test set key and name to make it unique and increase readability.
Execution type	string	The execution type: Manual, Automated, None, or Mixed.
Source	string	The source of the execution: TestManager, Orchestrator, or Studio.

Table 8. Test execution measures

Measure	Type
Total test execution count	integer
Manual execution type count	integer
Automated execution type count	integer
Mixed execution type count	integer
Duration in seconds of test execution	integer