Depending on the selected data source, you can search and filter by multiple fields/criteria in the FactoryLogix database.

Log into FactoryLogix Analytics.
Select Data Miner/Data Analysis to start DataMiner.
Create a workbook or open an existing workbook.
On the left side of the window under Data Sources, select a category to display the data sources for the category.
Double-click a data source to view its associated tabs and options.

Important

The available search and filter options depend on the data source you select. For example on the Products tab, you only see the GRN option for the GRN Status and Material Purchase Orders data sources. If an option isn't available for the selected data source, it will be dimmed.

Some search and filtering options may be dimmed (unavailable depending on the selected category and data source

Propagate Value button

The Propagate Value button (the Blue arrow) propagates the value of a search field from one data source to another data source—or to all data sources—within a single workbook (if they have the same data sources available to the data set).

Look Up dialog

When you select some search/filter options (Customers, for example), a Look Up dialog displays. When you start typing, the dialog displays data matching the criteria you type.

Tip

Enter an asterisk * character to return all data quickly in a Look Up dialog.

Here is an example of the search and filter tabs for the NPI/CAD-BOM data source. (The individual tabs and options change depending on the data source category and individual data source you select.)

data source search and filter options example

Search and filter options (by tab name)

The following table (organized alphabetically, by tab name) describes the DataMiner search and filtering tabs and the options available on each tab.

Note

Not all tabs and filtering options are available for all data sources; the options displayed are specific to the data source you select.

Tab	Search and filtering options

Tab	Search and filtering options
Barcode Template (System Administration category)	Template Name More information: Create a barcode template
Batch Type (Miscellaneous category)	Use Filter by Batch Type Select a Batch Type Production Receiving
BOM Options	Consolidate Reference Add AML\AVL\Alternate IPN Info Add CTO Option Codes More information: Part Library, Work with configurable assemblies (CTO)
Change Notice Type	Change Notice Type: Any Batch Assembly Process Barcode Part Number Operation Operation Alias Workstation More information: Approvals and sign-off
Data Source Join Properties	Select related columns to join data sources Select the type of data join to create Include all rows where the joined columns match both data sources Include all rows from data source A and only the rows from data source B where the join columns match Include all rows from data source B and only the rows from data source A where the join columns match
Group By	View Faults Collected By: Feeder Part Nozzle Reference Designator View PPM Summary Data Collected By: Feeder Nozzle Part Time (Enable) Year Quarter Month Week Day Hour Location Operation Product (Enable) Customer Assembly Process Revision Batch Placement Type Feeder Feeder and Feeder Slot
Job Status	Batch Status Any Closed On Hold Open Serialization Any Non-Serialized Serialized Hybrid More information: Entry and exit conditions and actions for product tracking
Location	Operation Group Operation Alias Operation Workstation Resource Type More information: Process flow operations
Logistics	Transport Order Part Number UID Kit Group Stock Location Stock More information: Printed label templates for materials and transport orders, Using FactoryLogix Materials Management
Materials	Item Types Lot Number Inventory UID Trace Barcode More information: View archived records in the Trace window
Non-Conformances	Title Number Non-Conformance Status Disposition Correction Root Cause Action Complete Closed Cancelled Action Plan Name Action Plan Type Correction Containment Corrective Preventive Root Cause Analysis More information: What is a non-conformance?
OEE Quality Metrics	Workstation
Operator Feedback Status (Production and WIP Tracking category)	Use Filter by Operator Feedback Status Select an Operator Feedback Status New Under Review Reviewed Closed Ignore
Options	Include Sub-Assemblies Show Only Trace Barcodes Use Only Completed Units Group Operations by Area Report Inbound Product Barcodes Line Show Operation Data Show Completed Only Shift Include Dwell Time to Next Station Include User Touch Time Data Include Activity Detail Data Current Defect Status (Open, Closed, Fixed, False, Deleted) Measurements Histogram Options Bin Count Using a Sample Population User-Defined Specification Limits Upper Specification Limit Lower Specification Limit Nominal Value
Options (Inventory, Material and Traceability category)	Item Class Include Parts Include Tooling Include Consumables Include Carriers Statuses Include Active Include On Hold Include Depleted Include In Stock Include All Fields Show General Fields Show Logistics Fields Show Electronics Fields Show Custom Fields MSD Material Show Only MSD Material Show Closed Material Show Open Material
Options (Archive and Restore History, Miscellaneous category)	Serial Number Archived Material Types Archived Restored Item Types Assembly Revision Production Process Receiving Process Batch/GRN Product UID Materials Machine Performance Data Other Show Latest Only Symptom Include Defect Detail Include Measurement Detail More information: https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134971962, https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134972113
Options (DPMO (IPC-7912)), Quality and test category	Use Only Completed Units More information: https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134980322
Options (Production Scheduling, Production and WIP Tracking category)	Line Show Operation Data Show Completed Only More information: https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134974030
Options (Productivity Over Time, Production and WIP Tracking category)	Shift
Options (Quality, Quality and Test category)	Symptom Current Defect Status Open Closed Fixed False Deleted More information: https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134972016
Options (SPC Measurements, SPC Category)	Measurements Histogram Options Bin Count Using a Sample Population User-Defined Specification Limits Upper Specification Limit Lower Specification Limit Nominal Value More information: https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134973728
Options (WIP, Production and WIP Tracking category)	Include Sub-Assemblies Include Dwell Time to Next Station Include User Touch Time Data Include Activity Detail Data Here are some definitions to help you understand how WIP calculations are done in DataMiner: Cycle time - The complete time a unit has been at an operation. It begins when the unit is first scanned into an operation and stops when the unit is finished. Pausing the unit does not stop the cycle time count. The calculation is: TimeComplete - TimeStarted = Cycle Time. This data is in the WIP data source. Touch time - The total time that a unit is started at an operation and not in a paused state. This data is in the WIP data source and you must select the option to Include User Touch Time Data to calculate touch time. Dwell time - The time from when a unit is finished at Operation A until it is started at Operation B. This time is calculated from the finish time of Operation A to the start time of Operation B. This is in the WIP data source and you must select the option to Include Dwell Time to Next Station to calculate dwell time. More information: Entry and exit conditions and actions for product tracking
Orders (Material Purchase Orders, Logistics category)	Order Order Status Any Closed On Hold Open More information: https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134973913
Part Relationship	Part Attributes Part Number (Polarized, Non-Polarized, Either) Customer Part Relationship Customer Part Number Vendor Part Relationship Vendor Part Number Manufacturer Part Relationship Manufacturer Part Number More information: https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134980285
Products	Customer Assembly Process Batch GRN Serial Number More information: https://factorylogix.atlassian.net/wiki/spaces/FL/pages/134980216
Receiving Options

Search and filter options for data sources

Propagate Value button

Look Up dialog

Search and filter options (by tab name)