Viewing Data Lake Excel integration report

View a sample Data Lake - Excel integration report for tracking Style, Material, or Trim BOM usage, along with an audit log-style report for Style Costing Element values.
  1. Select Tools > Technical Downloads.
  2. From the Data Lake section, click Views for Data Lake.

    A zip file is automatically downloaded containing these items:

    • A text file containing information on how to query data of selected style, material, and trim BOM where used field values from the published Infor PLM for Fashion data in Data Lake.
    • A text file containing information on how to query data of selected style costing elements field values from the published Infor PLM for Fashion data in Data Lake.
      • The query intends to capture only the last 10 updates made to the costing element value. Make sure to create this query as a View in Data Lake before executing it directly in the Infor OS Add-In for Excel.
      • Ensure to update the DB SCHEMA value according to the user preference.
    • A text file containing information on how to query data of selected style fields from the published Infor PLM for Fashion data in Data Lake.

      • Make sure to update the DB SCHEMA value based on your preferred value.

      • Use this query to create a View in Data Lake or execute this in the Infor OS Add-In for Excel.

    • An Excel file containing an example of pivot tables and chart to simulate an adoption rate report. Customers and Partners can download the Infor OS Add-In for Excel from Infor Marketplace. Once installed, instructions are available within the Add-In section.
    • An Excel file containing an example of pivot tables and chart to simulate a style, material, or trim BOM where used report and an audit log-like report, for style costing element value. Customers and Partners can download the Infor OS Add-In for Excel from Infor Marketplace. Once installed, instructions are available within the Add-In section.