EDEKA (Germany)

Loyalty Program: LUNAR GmbH.

Loyalty cards provide an important incentive for customer retention. But they also provide the retailer with vital information of its customer's preferences. This in turn allows for exact demand planning and therefore less waste. However, customer behavior can also be altered by e.g. incenting high-quality products. But each customer group has to be developed differently. Here advanced analytics come into play: It clusters people by measuring their purchases' distance from key products representing the very groups retailers intend to develop.

BIPortal helped EDEKA to overcome a number of obstacles to achieve their strategy. Issues like handling its massive data base containing every single POS transaction, i.e. not only sales but also recalls, discounts, rebates, vouchers, coupons, and promotions. On the business side the different options for advanced analytics were explored an finally SAS was chosen. The final challenge was synchronizing EDEKA's SAP transactions with SAS' analytics platform.

Coop (Suisse)

On-Shelf Availability (OSA): Coop

Coop is Switzerland's second largest retailer but closely follows the market leader Migros. Competition is fierce and therefore margins are thin. Demand planning is already a challange in itself but is compounded when it comes to fresh products often to be sold on the same day of stocking or even within minutes for baked products: Stocking too little lowers customer satisfaction but too many increases waste.

BIPortal helped Coop not only to solve the technical issues but also developed the analytics itself to forecast sales opportunities, cost of waste and service-level goals. Finally all analyses were made available to all Coop stores via its BI portal.

Boots (UK)

Category Management: Boots UK

Boots is the number one high-street retailer in the UK offering various healthcare products. In contrast to other retailers they also champion a number of products produced at their own plants. Production planning and category management were not aligned as production couldn't be altered at the same pace as orders were placed. Boots therefore chose to replace its legacy systems with SAP and especially SAP BW for all its reporting purposes.

Major challenges BIPortal had to overcome was the Like-for-Like reporting as products and material numbers changed frequently over time. At the lowest level of the category hierarchy a time-dependent category element containing similar products was introduced. A similar approach was chosen for regions. Finally consolidated data had to be provided for SAP CO-PA (Profitability Analysis). Boots' BI portal ensured access to vital reports for all store managers.

InBev (Belgium)

Budgeting: InBev S.A.

When InBev S.A. took over Anheuser-Busch a strict new budgeting approach was introduced: All items had to be budgeted at the beginning of the year starting from scratch: The so-called 'Zero-based Budgeting' (ZBB) approach. The main challenge with ZBB is to have all items available as planning objects along with their current and future prices.

SAP BW-BPS (Business Planning and Simulation) was chosen as existing planning applications had already been built on BPS.

The main issue to overcome was the static nature of BPS. BIPortal therefore recommended to switch to SAP BW 7 IP (Integrated Planning) as it offers a much more flexible approach to planning as it builds on BW's proven query designer.

Suning (China)

SAP BW Audit: Suning Appliances Co. Limited

Suning is China's largest retailer with Suning Appliances Co. Limited focused on consumer electronics. IBM had done an excellent job configuring SAP QM and SD, but its team needed support architecting Suning's reporting based on SAP BW 7.

BIPortal audited the existing implementation and developed a design guide highlighting issues found and providing an overview of best practices.


BIPortal has exceptional SAP expertise within Retail, Automotive and Services.