"Thanks to BusinessObjects Edge, designed for companies of our size, we were able to choose a solution we thought was only for large accounts"
Pascal Ruchat, Managing Director
IT manager and management controller, Blanchard
The Blanchard Group specializes in the distribution and servicing of equipment and spare parts for agriculture and road building. This SME, originating in Brittany (France), distributes top-brand tractors, combine harvesters and tractor loaders (including New Holland). Thanks to New Holland, the Blanchard group is pursuing a policy of sustained nation-wide development. For example, three new agencies were opened in six weeks. The company has decided to upgrade its IT in order to support this growth: a complete system overhaul around Citrix, new commercial servers and networks equipped with laptops. "We were short of high-performance reporting tools," declared Pascal Ruchat, IT manager and management controller.
The group raises around 3,000 invoices a month,
covering some thirty different areas of equipment
and parts coming from about fifty suppliers and
manufacturers. Heracles, an application developed in
Magic Software (SGBDR Oracle) can manage all the
group’s activities except payment: accounting, stock
and planning, invoicing, sales of equipment and
parts, after-sales service, warehouse repairs, etc.
Monthly executive information systems are
performed by OBDC extractions which supply over
50 Excel spreadsheets. Part of the reports is generated with Crystal Reports V8.
Pascal Ruchat explains: "When I arrived in 2002, my first job was to automate as much as possible the monthly management reports with tables of totals," a well-tried, satisfactory system for general management. On the second of each month, it produces all its management reports. Although this solution works, it has its technical and organizational limits. Excel cannot handle more than 65,000 lines, which is not enough when we have to compare and cross data over 200,000 references, 21 agencies, several different companies... The quality, security and confidentiality of the data are affected by it. On the organizational side, users depend on IT to supply and manipulate data, as only the IT team can make extractions from the Oracle tables. So Pascal Ruchat looked to the market for a solution that could handle the volume and complexity of their data, and keep it confidential.
Pascal Ruchat confides: "I wanted a fast, user-directed tool that could reduce the demands on our IT team. We looked at other products, but they required us to review our whole architecture. That’s why we were attracted to Business Objects with its simple global concept and secure access." But Business Objects’ "big accounts" image was an obstacle for this SME. They thought their investment level did not permit them access to this sort of profile. "That was in April 2007, when Business Objects had just launched BusinessObjects Edge designed for the SME / SMI market," explains Rodolphe Raimbault of ASI Informatique, Business Objects’ partner.
ASI Informatique assembled a prototype with Blanchard’s
data, with the results showing that the complex dynamic
crossings that were impossible with Excel were performed
easily with BusinessObjects. This is how Blanchard became
the first company in France to implement BusinessObjects
Edge, based on the principle of simultaneous, not named
users. "A license of five simultaneous users is enough for an SME’s functional needs, since in the end it can permit
access to reporting for 25 to 50 different users," Raimbault continues. At the same time Ruchat went for conventional licenses with named users for technical requirements and the IT team. All users access Web
Intelligence via the Infoview port and reports are generated transparently by Crystal Reports.
ASI Informatique completed the installation and technical confirmation of return solutions. Finally, it provided training for the IT team and the top managers of the SME responsible for generating the reports.
Gains are to be expected on the investment level. Improved
analysis of information will allow better control of the
company’s development, because of the fast, easy integration
of new entities. Better knowledge of the market and clients is
also an important objective. For example, Blanchard opens its
offices on Sundays during harvesting periods to perform
repairs for its clients as quickly as possible. BusinessObjects
Edge can analyze the different data at these offices, the
activity level, the most-requested spare parts, the necessary
resources, etc. As well as providing better knowledge of these
critical fields, the spreadsheets can perform regular analyses on all levels of the company, so
the different services will see improved productivity and autonomy. In the end, warehouse
managers, team leaders, retailers and traveling reps will be able to access decision-making
data to control their activity better. "One of BusinessObjects’ great advantages is that it has a
task-oriented language: all the fields are expressed in clear and comprehensible terms for any
user," Pascal Ruchat acknowledges. On his side, IT is freed from the burden of producing all
the monthly reports which one person would raise over a whole day. Finally the automatically
updated spread sheets will offer more recent and reliable information. "We hope to redo all our
management tables for the beginning of 2008".