Global Software's News and Events

Case Studies

Introduction

TechValidate Introduction: 

This case study of Liggett Group LLC is based on a January 2018 survey of Global Software, Inc. customers by TechValidate, a 3rd-party research service.

TechValidate Quote: 

"We achieved efficiency and accuracy by creating Spreadsheet Server reports in order to rectify the following “old” processes (a few examples):
- 'Pieced together' reports using data from ERP reports and queries
- Retyping data from an ERP report into a spreadsheet.
- Generated report from data using a VLOOKUP populated from an ERP query not routinely updated with current information.
- Numerous organizations added their data (from the ERP) manually onto a spreadsheet and passed it along to the next organization to add their data to the spreadsheet etc."

Challenges

TechValidate Challenges: 

Addressed the following reporting challenges after implementing Spreadsheet Server:

  • Accessing applicable data
  • Rekeying data from the ERP system into spreadsheets
  • Manual, multi-step reporting processes
  • A lack of access to real-time information
  • Creating reports in a timely manner

Evaluated a BI solution before selecting Spreadsheet Server.

Use Case

TechValidate Use Case: 
  • Has not used Spreadsheet Server as a replacement for Oracle Discoverer.
  • Uses the following supplemental reporting tools with Spreadsheet Server:
    • Business Intelligence (BI) tools
    • An ERP Packaged reporting tool
  • Uses Spreadsheet Server QueryDesigner’s functionality for the following types of reports beyond Financials/GL:
    • Manufacturing
    • Inventory
    • Payables/Receivables
    • Fixed Assets; and just now starting to create Cost Management queries

Results

TechValidate Results: 
  • Trimmed more than 30% from their previous reporting process after using Spreadsheet Server.
TechValidate Citation: 

Published: Jan. 31, 2018 TVID: 1AF-FF1-A1C

Company Profile

Company Snapshot: 

Company:
Liggett Group LLC

Company Size:
Medium Enterprise

Industry:
Consumer Products

ERP:
Oracle

Download PDF - 57.43 KB