Data Products

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.

The "full_bom" data product is the first use case we have targeted due to the complexity of planning operations. The First Resonance team will continue introducing more persona/use-case-based data products to further improve performance and simplify data interactions.

Full BOM

Where to find?

ION Analytics → Datasets → Pre-Built Datasets.

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