Select data sources for charts, pivot tables, and reports

The Data Source Navigator in the DataMiner window allows you to select pre-defined or custom data sources (that is, designed by Aegis for your factory).

When you select a data source, you can filter the data by a single criterion or multiple criteria. Filtering helps reduce the data returned to only the specific information you want to view, analyze, and use in reports, charts, graphs, and pivot tables or export to other applications.

Data source categories and individual data sources

The following table shows you the data source categories and their associated individual data sources.

Note

To view the individual search and filtering options for each category and data source, see Search and filter options for data sources.

Category	Data sources
Custom Data Sources	Stores data sources that were specifically written or defined by Aegis for you.
Material and Traceability	Installed Component Record Inventory Packout Shipping Orders Tool Usage History Where Found
Miscellaneous	Archive and Restore History Document History Join View Parametrized SQL User Defined SQL
NPI	CAD-BOM Change Notices Factory Part Relationships Process Approvals Process Flow
Production and WIP Tracking	Active Product Tracking Active Product Tracking Detail Assembly Genealogy Batch Status Batch Summary Operator Feedback Production Scheduling Productivity Over Time WIP
Quality and Test	Alarm Occurrences Audit Log Barcode Template Process Introduction Releases User Certification User Detail Validation ExceptionsDPMO (IPC-7912) DPMO In Process Non-Conformance Action Plans Non-Conformance Affected Units Non-Conformance Approval Details Non-Conformance Change History OEE (Overall Equipment Effectiveness) Quality Quality History Receiving Quality Receiving Quality History Receiving Yield Symptoms Test and Measurement Yield
System Administration	Alarm Occurrences Audit Log Barcode Template Process Introduction Releases User Certification User Detail Validation Exceptions Important FactoryLogix system value reports are a comprehensive set of automated reports that reveal the manufacturing issues FactoryLogix prevents and highlight the real cost savings for customer management and executives. The reports allow all non-users of the FactoryLogix system to view and understand the many quantifiable benefits of using the Factorylogix system. FactoryLogix Analytics DataMiner uses three data sources in conjunction with your FactoryLogix data and the system value report templates to generate comprehensive reports for management and executives. Alarm Occurrences – Provides data based on Alarm Trigger Events, demonstrates the number of times FactoryLogix issued a call to action to prevent the escalation of issues. Process Introduction Releases – Provides data on product onboarding rates and times. Validation Exceptions – Provides data related to validation fail events and demonstrates the number of times FactoryLogix actively prevented an issue from occurring. See System value reporting for more information.
Machine	Dispenser Faults Placement Rate Summary (PPM) Printer Reflow Oven SMT Utilization Wave Solder
Statistical Process Control (SPC)	SPC Defective Units SPC Measurements SPC Total Defects
Logistics	GRN Status Kitted Materials Material Purchase Orders Material Reservations Transport Orders
Materials Management	Audit Planning GRN Status Kitted Materials Material Purchase Orders Material Reservations Tracking Numbers Transport Orders
Enterprise	Downtime Reasons Machine States Material Aging OEE On-Time Work Orders Part Consumption Product Quality SMT Fault Analysis Supplier Quality WIP Summary Work By Batch Yield By Batch Yield By Operation

Showing/hiding data sources

To hide the data source categories and data sources in DataMiner, select the Auto Hide push pin button in the upper-right corner of the Data Source Navigator.

The panel collapses and you see the text Data Sources on the left side of the window.
To redisplay the Data Source Navigator, select Data Sources on the left side of the window.

Related topics

Create a workbook

Search and filter options for data sources

Search and filter data

Save a data set as a template

Run a data set

Run a data set template

Add a chart to a data set