Customer Story: A Smart Cube Simplifies Commissions

“The management, salespeople and administrative staff at Protect-A-Bed are all very happy with the benefits Info Explorer has given us. It was a real life-saver!”
Anneke Chamy, Chief Financial Officer

The team at Protect-A-Bed use a cube reporting solution to provide tailored information to their sales staff and figure commissions in no time using Orchid’s Info Explorer and Process Scheduler tools.

The Company

Protect-A-Bed® offers a complete line of protective bedding products. Having operated for more than 30 years and now selling in 45 countries, they are a worldwide leader in sleep technology.

The Challenge

Anneke Chamy, CFO of Protect-A-Bed, needed to find a tool that would enable their salespeople, on a more real-time and pro-active basis, to analyze their customers’ history, predict future needs, and prepare for meetings.

They also needed to find a more efficient way of calculating commissions payable, as this was taking many hours of manual effort for each payment run.

The Solution

Protect-A-Bed began to use Orchid Systems’ Info Explorer cube reporting tool for both needs. Using Info Explorer in conjunction with Orchid’s Process Scheduler enabled us to automatically deliver refreshed cube reports to each salesperson on a regular basis, tailored to contain the exact data and information most important to them.

With Info Explorer, we had the ability to configure exactly which Sage 300 ERP screen the user could open from right within the cube. When querying the screens, the end user is not taxing the SQL Server, because all of the data is contained locally within the cube. The customer found that to be very effective, as it doesn’t affect the day to day performance of the Sage 300 ERP system.

Using Info Explorer was also used to solve the commissions -calculation challenges, as it could access data directly from their Sage 300 database, and use this to calculate and report on commissions payable. By codifying the business logic and leveraging the technology of Info Explorer, commission runs that used to take 8-10 hours now take about 45 minutes.

Calculate Commissions

The Result

Anneke Chamy says the staff at Protect-A-Bed are very happy with the benefits Info Explorer has given them. “It was a real life-saver.” Salespeople now rely heavily on the new tailored reporting. “We have created a little bit of a monster. If they don’t get their cube every week I get an email and a phone call to prompt me, because they want them!”

Learn more about Info Explorer cubes and other reporting solutions on our Reporting Page.