Reports for queries that have been run and already available are listed with status Complete. This status links to the completed report which is stored as a Google Sheet in a Google Drive shared folder - press the label or the icon to open the Google Sheet report.
If you are not already signed in to your Google account in an existing browser session, you’ll be prompted for your Google credentials. Enter these to proceed and view the report sheet.
An example report is shown in the screenshot for
TermContainsXReport 71388002 |Procedure| 20181220_103142_prod_sulrich.
The sheet name contains the report title followed by the run date-time (in YYYYMMDD_HHMMSS format), a platform identifier (prod), and finally the account name of the originator (ie the account login under which the report query was run).
Since the report itself is a Google Sheet, all the options and services associated with a shared Google Sheet are available for further processing and analysis as needed, such as copying to a personal sheet for further analysis/manipulation, download as a file in various formats for offline review and processing (including exporting to other tools and services).
In the current version this is achieved via service requests to the technical team.
You can use the Raise an Issue form (or raise an INFRA devops support ticket directly in JIRA), as done for Authoring Platform (AP) issues and improvement requests, and noting the Reporting Platform (RP) in the form details.
Your request will be processed and prioritized along with other AP and RP feature/improvement requests for inclusion in a future release.
In the current version this is achieved via service requests to the technical team.
You can use the Raise an Issue form (or raise an INFRA devops support ticket directly in JIRA) to request a new report (either in an existing category, or requesting a new one), as done for AP issues and improvement requests.
This will be processed and prioritised along with other AP and RP feature/improvement requests for inclusion in a future release.
Find the report to remove, as described in .
Move your cursor over the report row entry (the row background will change shade when your cursor is in its context). A red “minus” icon will also appear to the right of the label link icon.
The SNOMED CT Reporting Platform (RP) is a gateway to reports which can run a range of queries against content created or updated in the active authoring cycle for SNOMED CT.
Queries are structured into categories for ease of definition, navigation and retrieval, such as Ad-Hoc Queries, Release Validation and Quality Improvement.
The results of these queries can support pre-release validation of issues not supported by the Authoring Platform (for instance MRCM rules such as attribute cardinality). They can also be used to analyze the structural quality of SNOMED CT, to identify potential issues (for instance attribute usage for a given sub-hierarchy) which can then be addressed via content change projects in the Authoring Platform.
For the content team it enables iterative work to define complex QA rules that are eventually used for the Release Validation Framework (RVF) assertions (such as case significance). As a content release planning and tracking tool it can show the number and types of changes made during a SNOMED CT release cycle, and from one release to the next.
Press the red minus sign to remove the report from the list. This presents the Delete Report pop-up dialogue.
Press the Delete Report button in the lower right-corner of the dialogue box to remove the report entry from the report listing. Press the x in the upper right corner of the dialogue box to close the box without changing the report listing.
Press Run New Query in the right-hand top corner of the report description panel. This opens the Report Details form in a pop-up dialogue box.
Each report type has a relevant set of query parameters which may be specified.
Example Report Details form: Term Contains X
This query takes the following values:
Subhierarchy - a constraining sub-hierarchy of SNOMED CT to limit the query scope.
Starts With - if this is checked the Words value must occur at the start of a term.
Attribute Type - a constraining attribute type to limit the query scope.
Note the Words field which is labelled as a mandatory field. If this is not populated, the report run will fail when the details are submitted, with Failed showing in the Status column of the reports list entry.
Later versions of the Reporting Platform will introduce deeper form validation to prevent submission with invalid report details (form validation varies according to the complexity and dependencies of the different report details).
Enter your desired query details.
Subhierarchy and Attribute Type are examples of type-ahead select fields - start typing a word in the field box and the form will present a drop-down list of matching options (it may take a few seconds to query the server and present the selection list).
Press a list option to set the field value.
Complete your desired query details and then press the Run Query button in the lower right-corner of the Report Details dialogue box. This will submit the report for running on the server.
If you wish to cancel, press the x in the upper right corner of the dialogue box to close it without running the query.
On submitting the Report Details, the report Status changes to Scheduled. At this point the report request is queued on the server.
When the queue processing reaches your scheduled report, the report Status changes to Running. At this point the report query is run against the mainline content on the Authoring Platform. The report run time depends on the complexity of the query and its related hierarchy size, available server resources and queue length.
After successful completion of the report, its Status is updated to Complete, and the Google Sheet report is then available in Google Drive, linked from the report entry Status label/icon.
Determine which report category is applicable to your query.
If there are many categories, and yours is not visible in the main content area, press a category heading in the left-hand sidebar Categories menu to only show that category’s reports.
Pressing the heading again restores the full Categories view.
Each press toggles between the only the selected category and showing all categories.
Press the header label for your category to show the reports listed under that heading. The screenshot shows the available Semantic Tag Hierarchy reports after pressing its heading.
Pressing the header label again will collapse the reports listing.
Each press of the report heading toggles the expansion/collapsing of the reports listing.
With your category expanded, find the report in the list of those available.
If a particular report that you need cannot be seen, you can run a new query for that report.
EITHER
On any page in the Authoring Platform , press the icon to the left of the word Dashboard in the header. This presents a pop-up navigation menu.
Press Reporting Platform in the pop-up menu options (last item).
OR
Enter the URL https://authoring.ihtsdotools.org/reporting directly into your web browser address bar (save the URL to your web browser bookmarks for easy retrieval if desired).
The Reporting Platform entry view is presented, showing a Categories selection panel to the left, and an associated Query List panel to its right.
