|
|
 |
Customers + Partners 
|
|
|
|
 |
|
|
|
Case Study: Bosselman Energy Company
 |
Basics
With fifteen companies representing 8 separate industries, flexible Web reporting was not only key, but crucial to keeping Bosselman Energy employees performing their jobs at top levels.
But, they faced a number of challenges including the sheer size of the data they needed to access. "There are more than 15 million records in this datamart and we add more than 600,000 new records each month," explains Harry Galbraith, IS Director of Bosselman Companies.
Challenge
"Our situation wasn't very good," says Galbraith, "Because our data files are large, it required extra logic to cut them up, and then we had to build separate programs to read different dimension-based facts. It was very cumbersome."
Solution
Galbraith and his team used m-Power to create an intranet of applications to allow users to access and analyze crucial data in a powerful large-scale datamart.
Using m-Power, these complex applications were all built in-house without the need for a traditional developer staff.
Value
According to Galbraith, m-Power is so fast that it takes longer to gather reporting requirements than to create the report itself.
|
|
Click here for the full case study (PDF version/208K) 
|
mrc Case Study: Bosselman Energy
Basics
With fifteen companies representing 8 separate industries, flexible Web reporting was not only key, but crucial to keeping Bosselman Energy employees informed, and able to perform their jobs at top levels.
Bosselman Energy faced a number of challenges such as giving users access to a datamart that contains item-level sales information captured in large-scale POS (point of service) systems.
"There are more than 15 million records in this datamart and we add more than 600,000 new records each month," explains Harry Galbraith, IS Director of Bosselman Companies.
Challenge
Bosselman's IT department had 12 on staff, but no full-time developers and only one business analyst in-house. The remaining staff have their hands full with end-user support and hardware/software maintenance for over 50 locations as far west as New Mexico and as far east as Kentucky.
"Our situation wasn't very good," says Galbraith, "We were using tools that were not enterprise-wide or enterprise-level tools, and ran on the client-side. Because our data files are large, it required extra logic to cut them up, and then we had to build separate programs to read different dimension-based facts. It was very cumbersome."
Additionally, the POS system covering these fifteen companies and eight industries ran separately from JD Edwards. The data was only combined when it hit general ledger.
Solution
Galbraith and his team used m-Power to create an intranet of applications to allow users to access and analyze crucial data in a powerful large-scale datamart.
By using m-Power, these complex applications were all built in-house without the need for a traditional developer staff.
Value
In fact, Galbraith says that m-Power is so fast that it usually takes longer to gather reporting requirements than to create the report itself.
"After the requirements are gathered an application is usually generated in a few hours or even minutes. This allows users to make changes as needed, and has the added bonus of creating flexibility in the design process, providing our users with a more efficient decision tool."
The additional benefit too, is now the applications are easy to maintain, which means Galbraith and his team can focus more on developing new ways to improve their business processes rather than maintaining software.
"While it is difficult to assign specific measurements to improving information delivery, before m-Power, the users simply did not have access to the information in a flexible or timely manner.
Our objectives included getting Web-based reports out to as many users as possible in a cost-effective manner. We have succeeded in meeting that objective. We can expect to see more and more returns from our people getting more information faster and subsequently making better decisions," said Galbraith.
For more information on Bosseman Energy, visit their Web site at www.bosselman.com.
|
|
|
|
|
|
|
|