Objectives of the data source
Objectives of live data source
- Live_Baseline
-
The Baseline chart in the Stock Movement report uses the data source to calculate the inventory value by using the baseline average price. The data source is designed specifically for this purpose.
- Live_Commits_Exports
-
Data related to items that have been saved or saved and exported, with preset calculated fields to help determine how the items were committed.
- Live_Export_Details_V2
-
All item fields data related to items that have been exported, either by committing with an export profile from MIO Inventory Optimization or by auto-export during a data refresh.
- Live_Inactive_To_Active (Beta)
-
Data source of stock codes to identify stock codes that are inactive at one location (not issued in the last n days) and active at another location (issued within the last n days).
- Live_Inventory_Bridge
-
Data source used to facilitate detection of changes in stock value over a variable period.
- Live_Inventory_Details
- Data source contains restricted item detail. Data source suitable to:
- Report on current inventory values
- Segment current inventory by Division (Company), Site (Plant), Control Segment, Criticality and more
- Live_Inventory_Details_All_Fields
- Data source exposes all fields in the item table for reporting and data source is suitable to:
- Report on current inventory values.
- Segment current inventory by Division (Company), Site (Plant), Control Segment, Criticality and more
- Live_Inventory_History
-
Data source is used to compare total stock value between two months with a specified interval and determine the reasons for any differences.
- Live_Inventory_Waterfall
-
For each item, retrieve data for two months with a specified interval to compare stock values and determine the reasons for any differences.
- Live_Items_By_Part_Number
-
This data source has a singular specific purpose and is not suitable for custom reports. It is used to find duplicate items by assigned part number.
- Live_Review_History
- Data source lists all end-of-month snapshotted items with all commits of those items during that
month. Best used to view items that have been reviewed and exported over time to:
- Monitor the user acceptance of using Maximo Inventory Optimization by Optimal Optimal Best (OOB) status.
- View details of exports including export type and by User.
- Live_System_Usage
- Data source of user activity. Can be used to:
- Analyze the usage workflow for a user
- Review the time a user has spent in Maximo Inventory Optimization as a whole for each event type (Task)
- Monitor system usage over time
- Live_Workflow_Details
-
All data related to all workflow with one row per workflow review action.
- Live_Workflow_Items
-
Data to compare the snapshot of an item as it is committed when a workflow is approved with the most recent snapshot of the same item.
- Live_Workqueue_History
- This data source is created for the purpose of reporting on work queues.
This data source is best used to:
- Analyze the outstanding review percentage of each work queue by priority.
- Review work queues by set/group.
- Analyze work queues that have been reviewed in the current month.
Objectives of snapshot data source
- Snapshot_Audit_Log_History
-
You can use this data source to analyze the audit events for a selected User
- Snapshot_Baseline
-
The data source is created for the Baseline chart in the Stock Movement report to enable the calculation of inventory value using baseline average price.
- Snapshot_Equipment_BOM_Details
- This data source is used to:
- List the Items (Materials) that relate to an Equipment via Bill of Materials (BOM).
- List the equipment and filter by responsible Person/Custodian, Equipment Type or Equipment Status.
- Review items relating to inactive equipment.
- Snapshot_Equipment_Issue_Details
- This data source is used to report on:
- List the items (Materials) that relate to an equipment via issues.
- List the equipment and filter by responsible Person/Custodian, Equipment Type or Equipment Status.
- Review items relating to inactive equipment.
- Snapshot_Inventory_Bridge
-
This data source is created for the Inventory Bridge report. It is a data source that has been designed for improved performance.
- Snapshot_Inventory_History_v2
- This data source is best used to report on:
- Historical inventory values over time.
- Surplus values over time.
- Analyze stock increases and decreases from a given point in time.
- Monitor changes in criticality from one month to another.
- Snapshot_Issue_History
-
Data source contains restricted item detail. Data source is suitable to:
- Compare issues to returns over time.
- Analyze returns in depth and segment by Site (Plant), Control Segment and more.
- Review work orders that relate to issues and/or returns.
- Review Items (Materials) that relate to issues and/or returns.
- Snapshot_Item_Equipment_Details
- This data source is best used to:
- List the equipment that relates to an Item (Material) either via Bill of Materials (BOM) or Issues.
- List the equipment and filter where Item is issued to equipment.
- Review items where all Equipment is inactive.
- Snapshot_Receipt_History
- This data source is best used to:
- Report on receipts values over time.
- Analyze supplier lead times.
- Review purchase order information relating to quantities ordered and received.
- Snapshot_Spend_Projection_Bridge
-
This data source is used for the Spend Projection Bridge report.
- Snapshot_Turnover
- This data source is best used for reporting on turnover. It can be used to:
- View turnover as a trend over time.
- View turnover by Site (Plant).
- Exclude special items from the turnover calculation.
- Snapshot_Work_Order_History
- This data source is best used to:
- Analyze Reviews that relate to Work Orders.
- Review work orders in detail.
- Analyze work order returns by Work Order Date, Employee who performed the Return, Commodity, and Item (Material).
- Review the associated Items (Materials) with a Work Order.