PrecisionPoint Software is a global software company with offices in both the UK and US and a customer base spanning 20 different countries in 4 continents.
From small beginnings
Back in 2002 a group of ERP consultants & SQL experts were getting tired of beavering away trying to build BI solutions to provide much needed reporting and analytics for their clients. One day they stopped, took a step back and thought: “Why are we spending so much time building individual solutions for each customer, when each customer is trying to solve the same problem? What if we could build a product that would do this for us?”
So they decided to take a leap of faith, quit their consulting jobs and set about writing software which would create a data warehouse in minutes and bring all the financial information from a given clients’ ERP system into a single cube.
Everybody said it couldn’t be done. “You think you can build a product that will enable users to drill down from the General Ledger to find out where every transaction came from?” Yes! “You want to combine sales, purchase and inventory into a single cube so you can see the relationships between them all?” Why not?! “No, no, not possible”, they said. “Just you wait and see…” we replied as we ripped up the rule books and set out to prove them wrong.
Making the impossible, possible
With Microsoft’s SQL Server 2000 product establishing itself in the marketplace, complete with new ‘Analysis Services’ OLAP cubes and having an ERP called Navision, the technology was becoming available to support this dream.
By 2004 we had a product that we could be proud of and so we started to file patents covering our techniques of merging the sub-ledgers and GL together – these techniques allow us to re-create the audit trail and integrate the ERP sub-ledger and GL entries into a single cube for analysis.