IBM Cognos Business Intelligence Artifacts

An IBM® Framework Manager model, and a compressed file that contains reports and dashboards is provided.

Framework Manager model

The Framework Manager model is described in the following table:

Table 1. Framework Manager model
SI. Number FM Model Purpose
1. IBMPMQ

IBM Predictive Maintenance and Quality uses IBM Cognos® Framework Manager to model the metadata for reports. IBM Cognos Framework Manager is a metadata modeling tool that drives query generation for IBM Cognos software.

A model is a collection of metadata that includes physical information and business information for one or more data sources. IBM Cognos software enables performance management on normalized and denormalized relational data sources and a variety of OLAP data sources.

Site Overview dashboard

The Site Overview dashboard is described in the following table:

Table 2. Site Overview dashboard
Sl. Number Report/Dashboard Purpose

1.

Overview

Provides a high-level summary of the health of all of your assets at all sites, it shows the key performance indicators (KPIs) with the greatest impact.

You can change the detail that is displayed by selecting items from the list boxes. For example, you can change the date and the equipment type.

2.

Top 10 Contributors

Identifies the equipment, locations, and operators responsible for the most failures.

3.

KPI Trending

You can select multiple key performance indicators (KPIs) to be plotted side-by-side in a line chart.

You can identify correlations between the KPIs and see whether there is any lagging behavior.

For example, if there is a spike in one KPI, how long does it take to impact the other KPIs?

4.

Actual vs Plan

You can monitor how closely the metrics track against the plan.

Variances are highlighted.

5.

Equipment Listing

The health score for a site is derived from the lower-level scores from each piece of equipment in the site.

This report shows you all the pieces of equipment on the site and the health scores and relevant KPIs for that equipment.

6.

Equipment Outliers

Lists the equipment (or assets) that are performing outside of allowable limits. The measures that are shown differ depending on the equipment, but examples are operating temperature, lateral strain, hydraulic pressure, average value, last value, and control limits.

7.

Recommended actions

A summary of all recommended actions for each piece of equipment, for the health score measurement.

Equipment Reports dashboard

The Equipment Reports dashboard is described in the following table:

Table 3. Equipment Reports dashboard
Sl. Number Report/Dashboard Purpose

1.

Equipment Profile

A detailed report that shows everything that is known about a piece of equipment: how it is performing today and how it performed in the past.

2.

Equipment Control Chart

Shows the upper and lower control limits and the average limits for selected measures.

3.

Equipment Run Chart

Shows the measures for a particular piece of equipment.

4.

Equipment Outliers

Shows detailed measures for a piece of equipment that shows anomalies.

5.

Event Type History

Lists the events for a device.

Product Quality dashboard

The Product Quality dashboard is described in the following table:

Table 4. Product Quality dashboard
Sl. Number Report/Dashboard Purpose

1.

Defect Analysis

Shows product defects and inspection rates.

2.

Inspection Rate Analysis

Examines the relationship between inspections and defects over time to find the optimal rate of inspection.

3.

Material Usage By Process

Provides an overview of material usage in the production processes.

SPC reports

SPC reports are described in the following table:

Table 5. SPC reports
Sl. Number Report/Dashboard Purpose

1.

SPC - Histogram

This report allows a visual interpretation of data by indicating the number of data points (events) that lie within a range of values, called a class or a bin. The frequency of the data that falls in each bin is depicted by the use of a bar.

2.

SPC - X Bar and S / R Charts

 To track instantaneous variations and to evaluate the stability of the variability with in the process for smaller sample sizes ( R Chart ) and for bigger sample sizes ( S Chart)

Other reports

Other reports are described in the following table:

Table 6. Other reports
Sl. Number Reports/Dashboard Purpose

1.

Advance KPI Trend Report

This chart compares multiple key performance indicators (KPIs) across multiple resources. You can use this chart to analyze variations in a resource against a set of profiles.

2.

Material Usage by Production Batch

This report provides an overview of material usage by production batch.

By correlating production batches with defects to material usage by production batch, you can begin to trace the impact of defective materials.

3.

Audit Report

Shows the counts of rows in the major master data tables.

Drill Through reports from the Audit report

The following table lists Drill Through reports from the Audit report.

Table 7. Drill Through reports from the Audit report
Sl. Number Reports/Dashboard Purpose

1.

Resource List

Lists the resources by resource type.

2.

Profile Variables

Lists all measures and key performance indicators that are being tracked in daily profiles and historical snapshots.

3.

Process List

Lists all production processes.

4.

Material List

Lists materials that are used in the production process.

5.

Production Batch List

Lists production batches.

6.

Material Usage By Production Batch

This report provides an overview of material usage by production batch.

By correlating production batches with defects to material usage by production batch, the impact of defective materials can begin to be traced.

7.

Measurement Type List

Lists measurement types. For each measurement type, the report shows unit of measure and aggregation type.

Maintenance dashboard and Top N Failure reports

The Maintenance dashboard and Top N Failure reports are described in the following table:

Table 8. Maintenance dashboard and Top N Failure reports
Sl. Number Reports/Dashboard Purpose

1.

Maintenance Overview Dashboard

This dashboard provides an overview of health score for the last current day in the record.

Along with maintenance health score, report also shows a comparative view with sensor health score and integrated health score.

2.

Maintenance Advance Sorting Report

This chart displays the same measures as the main report (Maintenance Overview Dashboard) in a tabular format.

Users can sort on a column by clicking the column header.

3.

Maintenance Health Score and Failure Detail Report

This report will help user to see the historical and forecasted health scores of a machine along with Historical Breakdown, Forecasted Breakdown, Planned Maintenance Schedules.

4.

Top N Failure Report

The plot shows the UNSIGNED predictor importance, indicating the absolute importance of any predictor in predicting a failure or non-failure condition.

QEWS quality dashboards and reports

QEWS quality dashboards and reports are described in the following table:

Table 9. Inspection and Warranty reports
Sl. Number Reports/Dashboard Purpose

1.

Quality dashboard - Inspection

This dashboard provides an overview of the state of products at a selected run date.

2.

Quality dashboard - Inspection Detail History

This dashboard provides details about the state of products and the various threshold values for a selected product category at a selected run date.

3.

QEWS - Inspection Chart

This chart reports the failure rates and CUSUM values for a specific product type and product code over a time period.

4.

Quality dashboard - Warranty

This dashboard provides an overview of the state of products at a selected run date.

5.

Quality dashboard - Warranty Detail History

This dashboard provides details about the state of products and the various threshold values for a selected product category at a selected run date.

6.

QEWSL - Warranty Chart

This chart reports the replacement rates for a specific product type and product code over a time period.

7.

Quality dashboard - Parametric

This dashboard provides an overview of the state of products at a selected run date for a variable.

8.

Quality dashboard - Parametric Detail History

This dashboard provides details about the state of products and the various threshold values for a selected product category, at a selected run date for a variable.

9.

QEWSV - Parametric chart

This report is used for monitoring variable-type data and CUSUM values that are obtained from the QEWSV batch along with threshold levels.

The report is designed to support five different validation types: Material Validation, Process-Resource Validation, Production Batch Validation, Resource Health Check, and Location Suitability.