ION Factory OS
  • Welcome to ION
  • Features
    • Procedures
      • Steps
        • Content
        • Datagrid
        • Fields
        • Attributes
      • Dependencies
      • Part-Procedure Relationship
      • Attributes
      • Standard Steps
      • Installation Requirements (Beta)
      • Nested Steps and Nested Standard Steps
      • Procedure Best Practices
    • Runs
      • Run Execution Overview
      • Runs And Step States
      • Batching Runs
        • Batching 2.0 Changes
      • Workcenter execution
      • Split Inventory on a Run
      • Redlines
      • Export run data
      • Scheduling runs
      • Time Tracking
      • Attributes
      • Outside Processing
      • Runs Best Practices
    • Parts Library
      • As-built Bill of Materials (aBOM)
        • Editing aBOM build requirements
        • aBOM Beta Changes
          • aBOM actions for developers
      • Inventory
        • Inventory status
        • Inventory splitting
        • Inventory merging
        • Inventory scrapping
        • Kitting
        • Inventory Movement Automations
      • Manufacturing bill of materials (mBOM)
        • mBOM versions
        • Made on Assembly (MOA)
        • Part Substitutes
        • Reference designators
      • Part Attributes
      • Part revision interchangeability
      • Supplier Part Numbers & Purchase Unit Conversions
    • Kitting and Inventory Fulfilment
      • Kit Statuses and Workflows
      • Inventory requests
      • Kitting and runs
      • Fulfilling Multiple Kits
      • Kanban Kitting
    • Purchasing
      • Purchase Orders
        • Types of Purchases
        • Purchase Order Approvals
        • Purchase Order FAQs
        • Supplier Part Numbers & Unit Conversions
        • PO Requirements, Terms, and Quality Clauses
        • PO lines editability changes
      • Receiving/Inspection
      • Outside Processing
      • Consigned Parts
    • Barcode Labels
      • Templating
        • ION barcode minimum sizes
        • Sample templates
      • Printing
        • Configuring Zebra Browser Print
        • Server Based Barcode Printing (PrintNode)
      • Scanning
        • Scan barcodes from other systems
    • Quality
      • Issues
      • Further Actions - CAPA
      • Issues States, Dispositions, and Resolutions
      • Quality Best Practices
    • Tools
    • Locations
    • Attributes
    • Labels
      • Deleting labels
    • Notifications
    • Search
    • Settings
      • Role based access control
        • Full Glossary of ION Permissions
    • ION Actions
      • ION Actions examples for Quality
      • ION Actions examples for Runs and Procedures
      • ION ACTIONS examples for Supply Chain
  • Analytics
    • Inventory valuation
    • Part impact analysis
    • Users, Roles, Teams
    • Analytics FAQ
    • Data Connector
    • Data Products
  • Plans and Autoplan
    • Autoplan
    • Autoplan glossary
    • Preparing to use Autoplan
    • Clear to build reporting
    • Running Autoplan on a schedule
    • Firm and blocked plan items
    • Location constraints
    • Autoplan suggested suppliers and procedures
    • Reorder point
    • Plan input serial numbers
    • Applying a calendar
    • Plan Reservations
    • Independent schedules
    • Drive demand from kits
    • Drive demand below buy parts configuration
    • Group plan items with the same date
    • Manualy Changing Autoplan Status
  • API
    • How to create an App with ION
    • Access Tokens
    • About GraphQL
    • Interactive API explorer
    • API Keys
    • Examples
      • Notifications
      • Runs
      • Automatically updating fields in runs
      • Parts and Part Revisioning
      • mBOMs
      • Part Inventory and Kitting
      • aBOM (As-built Bill of Materials)
      • Edit time-tracking session data
    • Changelog
    • Webhooks
    • Pagination
  • Automations
    • Auto-checkout of Run Steps
    • Auto-Consumption of Lineside Inventory
    • Automatically Send Purchases to Suppliers
    • Set Close by Run Step on Issue Creation
    • Intent Management / Grade / Tier / Pedigree
      • Data Imprinting
      • ION Actions for Intent
    • Auto-Update mBOM Revision on Part Revision Update
    • Auto-approve part-procedure relationships
    • Purchase Order PDF and Versions
    • Auto Populate PO Line Attributes
    • Imprint Attributes from One Object to Another on a Desired Event
  • Integrations
    • Deploying Integrations and Automations
    • Arena
    • Cofactr
    • Datum
    • Duro
    • NetSuite
      • Purchasing in NetSuite, Receiving in ION
      • Work Order/Assembly Builds
    • Procurable
    • PDF Generator
    • Ramp
    • Silkline Integration
    • Slack
    • Smartsheet
    • SOLIDWORKS
    • Teamcenter
    • Integrating with ERP Best Practices
  • Training
    • Standard Operating Procedures
      • Cycle Counting
      • Tool Utilization
    • Guided Flows
    • ION Sandbox
    • Chat Support for ION
  • Troubleshooting
    • Resetting your password
    • Resetting your Multi-Factor Authentication
    • You have no roles... error
  • Changelog
  • Adminstration
    • Security
      • Backups and Security FAQ
      • Single Sign-On (SSO)
        • Okta SAML connection setup
      • Export Control
      • Report Generator Disclaimer
    • Browser and Device Compatibility
    • Authentication
      • My company is new to ION, logging in for the first time.
      • I'm told I'm not authorized to access the application
      • My account has been deactivated
    • Login Page
  • Tickets Portal
Powered by GitBook
On this page
  • Kitting Data Products
  • part_kit_item_fulfillment
  • part_substitutes
  • part_quantities_by_inv_status
  • BOM Data Products
  • full_bom

Was this helpful?

  1. Analytics

Data Products

PreviousData ConnectorNextPlans and Autoplan

Last updated 7 days ago

Was this helpful?

Manufacturing is complex and so is it's data. In an effort to simplify this data for day to day analysis, the First Resonance team delivers Data Products. These products contain calculations and aggregations that are maintained by the ION Analytics team and served up to ION Analyitcs from optimized data models.

You can rely on these data products to be maintained by First Resonance and optimized for better performance with large datasets. While data will still refresh every 15 minutes—so changes in ION may take that long to appear in analytics—the underlying calculations and joins will be significantly more efficient.

Where can I find these Data Products?

ION Analytics → Datasets → Pre-Built Datasets.

Kitting Data Products

These data products support analytics around parts, substitutions, inventory, and fulfillment in the kitting process within manufacturing environments. Each is optimized for self-service usage and integration into broader dashboards or decision models.

part_kit_item_fulfillment

Unique Key: (part_kit_id, part_kit_item_id, _organization_name) Description: This data product captures detailed fulfillment status for each item in a kit. It joins the part_kit structure with the individual part_kit_items, tracking whether each component within a kit has been sourced, picked, staged, or installed. It is essential for monitoring kit readiness, identifying bottlenecks in staging or fulfillment, and enabling line-side assurance that complete kits are available before work begins.

Use in dashboards and alerts where kit completeness is critical to avoid delays on the production floor.

part_substitutes

Unique Key: (part_id, substitute_part_id, mbom_item_id, _organization_name) Description: Provides a reference of approved substitute parts for any given part_id within the context of a specific mbom_item_id. This dataset intelligently merges two sources of substitution logic: (1) engineering-driven mBOM alternatives and (2) operations-driven Part Interchangeability mappings.

This enables planners and operators to make informed substitution decisions when primary parts are unavailable or low in inventory, directly supporting continuity in the kitting process. It's also instrumental in resilience analytics and inventory flexibility strategies.

part_quantities_by_inv_status

Unique Key: (part_id, _organization_name) Description: Aggregates current inventory for each part, grouped by inventory Status (e.g., "Available", "Quarantined", "Installed", etc.). This data product gives a snapshot of material readiness by showing how much of each part is practically usable versus allocated, blocked, or consumed.

It supports dynamic kitting readiness assessments, inventory health dashboards, and material shortage projections. Can be joined with demand-based metrics or fulfillment views to create proactive alerting on low-availability parts.

full_bom

Why the Update?

  • Drastically improved load times for dashboards like Clear to Build– reduced from ~2 minutes to ~20 seconds.

    • For large datasets, over 1TB of data can be scanned to gather all the information needed to aggregate plan results.

  • Better user experience – simplified access to key supply chain and planning data. ION Analytics → Datasets → Pre-Built Datasets.

What You Need to Do Differently

  • If you use the "Notable Assembly" feature on Clear To Build, ensure it is configured correctly:

    • Set up a "Notable Assembly" attribute at the library level as a text or single-select input.

    • Populate the data accordingly to utilize the relevant dashboard elements.

    • Full setup instructions.

  • Explore the "full_bom" dataset for custom analytics needs in ION Analytics → Datasets → Pre-Built Datasets.

What does it contain?

  • The full bom dataset contains the following columns revolving around BOMs and inventory availability:

    LAST PROCESSED DATE LEVEL - (This refers to the level of the BOM with high numbers more deeply nested) PLAN ITEM ID QUANTITY PART NUMBER REVISION DESCRIPTION SOURCING STRATEGY START TIME END TIME FORECASTED START TIME FORECASTED END TIME TYPE NAME PART INVENTORY ID MRP JOB ID PARENT PLAN ITEM ID PARENT PATH PARENT PATH IDS PARENT PART NUMBER PARENT DESCRIPTION PARENT START TIME PARENT FORECASTED START TIME PLAN ID PLAN DESCRIPTION PERCENT ALLOCATED PARENT PERCENT ALLOCATED QUANTITY ALLOCATED PLAN ITEM QUANTITY PLAN INPUT STRING ULTIMATE PLAN ID NOTABLE ASSEMBLY TAG PO ESTIMATED ARRIVAL MANUAL NEED DATE PARENT PART INVENTORY ID RUN ID OUTSOURCE PO ID OUTSOURCE PO LINE OUTSOURCE PO OUTSOURCE PO SUPPLIER OUTSOURCE PO LINE STATUS OUTSOURCE PO LINE ESTIMATED ARRIVAL DATE OUTSOURCE PO CREATED BY PURCHASE ORDER LINE PO SUPPLIER PO CREATED BY IS FIRM COMMENTS PART ATTRIBUTES ASSIGNED TO STATUS LATEST BUILD PROCEDURE ID LATEST BUILD PROCEDURE VERSION LATEST BUILD PROCEDURE STATUS BOM TYPE

BOM Data Products

📦
📒