Access and select available data sources
The My Data Sources tab of the Enterprise BI website shows the data sources a user or user role can access. The data sources displayed depend on how the user or user role was set up by the administrator. Use the scroll bars in the My Data Sources window to review the summarized data before importing it into your BI tool of choice (Power BI, Adobe Analytics, SAP Crystal Reports, and others). Any tools that support OData importing work with the Enterprise Warehouse.
For example, an administrator might set up a user role named Shop Floor Supervisors and only allow those users to access WIP Summary, Part Consumption, Work by Batch, and On Time Work Orders data. Other users or user roles might require access to more or less data, depending on their data requirements and responsibilities.
Log into your Enterprise BI website.
Select the Sites tab, then select a site from the Sites list on the left side of the window.
The data sources you can access are shown under My Data Sources (the Not Accessible list shows data sources you don't have permission to access).
Select a data source under My Data Sources on the left side of the window.
When you select a data source, the last date the data was updated and the total record count are displayed under My Data Source Information.
The lower half of the window shows the last 25 records that were processed for the selected data source.Under Last 25 Records, use the scroll bars to review the FactoryLogix data that you can import into your BI tool of choice.
The following table describes the available data sources.
Data source | Description |
|---|---|
WIP Summary | Displays WIP data including identifier, quantity, and assembly information. |
Product Quality | Displays defect data including defect status, inspection codes, and identifier information. |
Machine States | Displays the state and duration information for each factory resource. |
Downtime Reasons | Displays the reasons and duration for any downtime. |
SMT Fault Analysis | Displays batch information plus workstation and fault codes. |
Part Consumption | Displays part consumption information including part number, batch, and quantities. |
Material Aging | Displays the maximum, minimum, and average aging of materials. |
Supplier Quality | Displays quality information including vendor, GRN, and quantity metrics. |
On-Time Work Orders | Displays work order, batch, and time information. |
Work By Batch | Displays the amount of time that was spent working on units within a batch. |
OEE | Displays Overall Equipment Effectiveness (OEE) data. |
Yield By Batch | Displays the first and second pass yield based on batches. |
Yield By Operation | Displays the first and second pass yield based on operations. |
Related topics |
|---|