Are you able to quickly and efficiently provide managers the information they need to understand their spend?

about us page title image

What Is Included?

  • Materials Cost Insight
    Materials Cost Insight
    Give your organization a true picture of your Materials cost
  • Visibility into Purchasing
    Visibility into Purchasing
    Looking at Buyer/Supplier performance get visibility into your purchasing process
  • On Contract / Off Contract reporting
    On Contract / Off Contract reporting
    Improve your On Contract purchasing ratios with better analysis
  • Integrated Financials and Materials
    Integrated Financials and Materials
    Easily report on financial and materials data

With the Infor Supply Chain Reporting Data Mart & Analytics its never been easier!

Dashboard Gear Supply Chain Reporting Data Mart & Analytics is a complete reporting solution which integrates directly with the Infor Business Intelligence (IBI) and Infor Enterprise Procurement systems. If reporting from Infor's Supply Chain Suite is a challenge, you need to see a demonstration of Dashboard Gear’s reporting and analytical data warehouse. Reporting that took days now takes minutes.

Reporting & Analysis Dimensions

Included Measures

  • Organization Structure

    Your complete Vendor hierarchy including Vendor Groups, Vendor Classes, Vendors, and Vendor Locations.

  • Vendors

    You select the Companies, Process Levels, and Accounting Units to include.

  • Items

    The complete Item hierarchy including Item Groups, Major Classes, Minor Classes, Items, and Item Locations.

  • Periods

    All fiscal years and periods you have available and choose to include down to the day.

  • Buyers

    This includes Buyer Groups and Buyers.

  • Item PO Costs and Quantities – All

  • Transaction and Base Amounts and Quantities

  • Invoice and Actual Costs and Quantities

  • Taxable and Discount Amounts and Quantities

  • Distribution and Paid Amounts and Quantities

  • Percent First Receipt

  • Percent Matched on Cost

Get insight into the true spend of your organization

With Dashboard Gear Supply Chair Data Mart & Analytics you can have spend reporting by vendor, department or buyer in a matter of clicks!

Connect to our data layer with any reporting tool you desire. SQL Server Reporting Services, Crystal Reports, Tableau, Cognos, Infor AppStudio, Microsoft Excel. with Dashboard Gear Data Mart & Analytics you have flexibility and scalability of your reporting environment.

A cleaner and quicker view into your Infor Supply Chain data!


The Dashboard Gear data mart works with standard tool sets such as IBI, Crystal Reports, MS Excel, etc.

Our data mart is a unique set of data structures designed to make report creation easy. You may never have to do another table join! Slice and dice item PO cost, item invoice cost, item quantities, percent first receipt, percent matched on cost, etc. by vendor, buyer, department, item, etc. with MS Excel in seconds! If the complexity of the Procurement table structure, slow performance of Add-in queries, and report contention with the production system are issues, then Dashboard Gear Data Mart & Analytics  is the answer.

System Requirements

dashboard gears Icons-08

The system works with Infor Supply Chain 8.x, 9.x and 10.x systems.  The Data Mart & Analytics solution requires a Microsoft SQL Server 2008, 2008r2, 2012, 2014 or 2016 system with ODBC/OLEDB connectivity to the source Infor tables.  The system will require the ability to create a database on the SQL Server environment and take full ownership of that database including the ability to create, drop, and alter tables on that database.

Optionally, if Microsoft Analysis Services Cubes are desired, the requirements of the reporting solution must be met.  In addition, Microsoft Analysis Services and SQL Server Integration Services must be installed and a Local OLAP Administrator user must be available to create Analysis Databases and Cubes.