Global Software's News and Events

Case Studies

Nanometrics Incorporated Case Study

About the Company

Nanometrics Incorporated was incorporated in California in 1975. Nanometrics Incorporated is a leading provider of advanced, high performance process control metrology and inspection systems used primarily in the fabrication of semiconductors and other solid-state devices, such as data storage components and discretes including high-brightness LEDs and power management components. Nanometrics Incorporated has been publicly traded since 1984 and is listed on NASDAQ (NANO). They have been a pioneer and innovator in the field of optical metrology. Nanometrics Incorporated has an extensive installed base of more than 6,500 systems in over 150 production factories worldwide. Their major customers and original equipment manufacturer (OEM) partners include the largest semiconductor and process equipment manufacturers in the world. Nanometrics Incorporated uses Oracle E-Business Suite Version R12.

Situation & Strategy

Case Study Strategy: 

Previously, Nanometrics relied on generic manual, cumbersome reporting within Oracle. Performing ad hoc reporting or drilling down to sub-ledger detail proved exceptionally difficult. Nanometrics moved to Oracle E-Business Suite R12 in 2014 and began an extensive search for reporting solutions that would replace their FSGs, provide detailed account analysis, and provide the ability to drill-down within sub-ledgers within Microsoft® Excel. Their search team selected Spreadsheet Server over other Excel and non-Excel based reporting solutions.

Software Implementation

Case Study Software: 

Spreadsheet Server converts Microsoft® Excel into a tightly integrated analytical tool for any ERP system. Users can leverage the strength of their spreadsheets with seamless dynamic integration to their information, along with powerful drilldown capability to the lowest level of detail. It allows users to build a range of reports from simple ad hoc workbooks to complex dashboard-type views of critical business data.

Distribution Manager automates the distribution of reports from Microsoft® Excel.


Case Study Results: 
  • Fast implementation and training for intuitive, user-friendly products
  • Distribution Manager increases efficiencies and saves time through expedited processes
  • Automation saves about 30 hours per quarter in reporting

In a Nutshell

Case Study Summary: 

Spreadsheet Server allows them to develop reports on the fly, create complex reports with ease for management reporting, and customize reports as needed. They also find the content library of SmartPak queries provided in Spreadsheet Server’s QueryExchange to be invaluable in areas such as AP, AR, Fixed Assets and Cost Management.

Download PDF - 140.38 KB