Document toolboxDocument toolbox

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.

  1. Log into your Enterprise BI website.

  2. 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).


    My Data Sources view (single user)


     

  3. 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.

  4. 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

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

 

 

Copyright © 2024 Aegis Industrial Software Corporation. All Rights Reserved.