How to use the reporting tool to run prepared reports on your model data

Explanation

Knowledge Model Management (KMM) offers a very rich and functional view of all of your model data. Sometimes you may desire to see only data that meet certain criteria (such as concepts that belong to certain classes) or to see certain data forms (such as URIs or labels).

The reporting tool allows you to run customizable reports of your model data using the SPARQL query language. Some of the reports come as a part of KMM, and you may create and save other custom reports using the advanced search interface or the SPARQL editor.

This article explains how to access and use the reporting tool.

Assumptions

• You have an existing model.
• You have any of these roles for the model: MANAGER, EDITOR, CONTRIBUTOR (This article does not apply to the role REVIEWER, since it is allowed view-only access.)

Method

1. Open a model (in this example, Space Missions), and click Edit Master or open a task.
2. At the top, click the model menu (labelled Master or by the name of your task), and then click Reporting.
   
3. The reporting interface has two sections: Standard Reports (supplied by Progress) and Saved Reports (custom reports that you have saved from advanced search or the SPARQL Editor). For this example, stay in the Standard Reports tab and click Alphabetical Listing.
   
4. Many of the standard reports will display options for you to choose before running the report. For this example, leave the defaults, and click Run Report.
   
5. Each report has four available output formats. You may choose the one that makes most sense for your needs. For this example, click HTML.
   

Outcome

Results of SPARQL queries are traditionally formatted in tables for easy reading. However, the reporting tool offers multiple formats that you can use for human viewing or downstream system processing. Below is a description of each output method.

SPARQL-XML

You will be prompted to download and save the report. The results are in a standard XML format for SPARQL results.

JSON

You will be prompted to download and save the report. The results are in JSON format.

CSV

You will be prompted to download and save the report. The results are in a comma-delimited format that you can view in a text editor or as a table in a spreadsheet software (such as Microsoft Excel).

HTMLC:\Users\jpospich\OneDrive - Progress Software

The results will appear in your browser in a table format.