​OFN Salesforce KPI scorecard ​BI mobile solution on HANA BW ​Presenters from Orkla Shared Services: – Ola Einar Langen - BI architect – Shahzad Gul - BI architect

SBN Sandefjord: 22. Okt. 2014

Agenda 1.

Orkla • •

Orkla Foods Norge Orkla Shared Services

2. HANA • •

3.

Our way to HANA Our way to Scorecard

Scorecard Mobile BI trends • Technical architecture • • •

4.

SAP BusinessObjects Universe/Webi SAP BI APP (possibilities and limitations)

Demo Scorecard

Orkla Foods Norway Norway’s leading food company

• • • • •

3

Approximately 1 900 employees Around NOK 5 billion turnover Exceptionally broad product portfolio Number 1 position in a number of categories Factories in Fredrikstad, Stranda, Brumunddal, Skien, Oslo, Sem, Jæren, Rygge, Bergen, Voss, Elverum, Lierne, Larvik and Kristiansand

| OFN

History

Stabburet established 1943

1839 Rieber & Søn established

4

| OFN

Stabburet Leverpostei and Stabbur-Makrell launched 1949 og 1958

1946 The stock cube launched under the TORO brand

Pizza Grandiosa launched 1980

1964 Bergensk Fiskesuppe launched, stating the ‘soup era’ for TORO

Borregaard (incl. Stabburet) merges with Nora food products 1984

1985–1990 Denja, Bøe Lefsebakeri and Vossafår incorporated in Rieber & Søn.

Rieber & Søn and Stabburet merge into Orkla Foods Norway 2013

1991–1995 Orkla Borregaard merges with Nora Industrier. Acquisition of Procordia Food and Abba Seafood in Sweden

Big sales force

• Norway’s strongest sales force • Perform approx. 240 000 customer visits a year to retail and food service customers

5

| Source

Strategy

OSS strategic ambition

Reliable

Unique partner for the Orkla group

OSS customer reputation: • High uptime on mission critical systems • Projects are delivered on time, cost and quality

Preferred partner for mission critical services: • High demand for consultants • High customer retention rate • Unique knowledge about Orkla business processes

We have

Cost effective

Thrilling projects Talent Demanding customers Attract, retain and develop key people Service-focus and • Competence development User and customer experience: • Service attitude Working with high end solution • Easy to reach • Customer focus and business understanding Benchmarks approve OSS as a world class vendor.

• Short solution times • Reliable and precise feedback

And we want more colleagues 6

Developing people - creating value

The story Our journey to HANA

Our journey to mobility

Our journey to scorecard

7

HANA story Our way to HANA Our way to scorecard in HANA

Our way to HANA 1. Starting in OFN in 2011 BWA question end up with a HANA POC  need to replace Hyperion Essbase

Using help form SAP  Downside to be one of the first customer, low knowledge from SAP

2.

Goal achieved  CO-PA analyses went from minutes to max 3 seconds  Possible to enable BO tools on more areas

3. But is speed all we got ?

The system landscape (today) BeX Analyzer desktop

MS Excel Analysis desktop

OLAP analysis web

BW classic 7.0

WEBI 4.1 web mobility

SBO Explorer web mobility

BW Hana 7.3

Reporting Transformation

Transformation

Staging

Staging

CRM 7.x ERP 7.x

Others APO, flate files, …

Our way to scorecard 1. Project start in May this year 2. Goal  All users should have access to all there key figures at any level

 Visibility on all score (top – down)  User friendliness

The scorecard solution

WEBI 4.1 BO universe

BW Hana 7.3

BW classic 7.0

virtual

Reporting

ETL

Transformation

Staging

Transformation Staging

Excel flate files CRM 7.x Activities

CRM 7.x Sales

External Sales info

mobility

Challenges 1. Different key’s between the datasources 2. Different timestamps on different datasources / key figures Accumulated

Rolling 52 / 4 weeks (this/last year) Tertial Action periodes (OFN defined)

3. High use of navigation attributes (to handle changes) 4. Two different BI system

Response time < 5s

Tech facts

60 RKF 60 CKF

One multiprovider All datasources connect with common characteristics but different timeseries

Multiprovider

Datasources

Activities 1 mill records

Sales 1 mill records

External info 50 mill records

6 flate files

HANA is a Business enabler 1. HANA has given us a faster system 2. HANA has given us more opportunities 3. Today’s landscape has given us more work 4. We have the possibility to deliver and compare more sources in real-time 5. And deliver real time scorecard

Mobile BI - Trends

Mobile BI - Trends Mobile Application Priorities

17 Dresner Advisory Services, LLC. Desember 2013

Mobile BI - Trends

BI Trends –Browsing experience –Flexibilty –Up to date –Trustworthy –Collaboration –Security

18 | Kilde

OFN KPI Scorecard

What is a KPI Scorecard?

It makes it possible to measure performance against set of predefined targets or goals.

20 | Kilde

OFN Mobile KPI Scorecard • • • • •

Common scorecard for all external sales Provides detailed picture at all levels Simple, readily available and always updated Provides trustworthy information Tool that helps sales people monitor and adjust their sales activities according to their targets

21 | Kilde

User adoption of Scorecard solution • Excellent user adoption since the launch • Further increase in usage is expected as new KPIs are added to the scorecard

22

Technology & Architecture

Rationale for the choice of BI tools • Webi vs other front end tools (Dashboards, Design Studio, Crystal reports) – Webi a mature reporting tool – Fulfilled all the scorecard design, functional and technical requirements – Mobile, easy to use, ability to slice and dice

– 100% standard functionality – Makes it possible to expand existing solution – In house competence

• Universe vs BICS – BICS had issue with NO language when reports were drilled down

– Universe adds extra maintenance

24

SAP BI App for iPad (for Webi)

Strengths: • Business enabler • Easy to use • Nice collaboration functions • Makes reports attractive • Continuously improving

25

SAP BI App for iPad (for Webi) Limitations • In continues development

• What you see is what you do not get – Webi reports in SAP BI app have many limitations – Table and column size is adjusted by BI APP – Fonts size is adjusted by BI APP – Some chart types are not supported – Limited chart properties supported – Legends, values on charts etc.

– Input control function should be simpler to use in BI APP – Need to open reports in iPad to test the layout

• Need for design time tool in Webi to simulate iPad layout 26

Orkla BusinessObjects architecture

Technology continued SAP BI App

SAP BI App

(Catergories)

SAP BI App

Web intelligence

SAP BusinessObjects

Mobile server

SAP BI App

IPads

SAP BI App

OLAP Universe OLAP

connection

Multiprovider 28 | Kilde

HANA BW

Bex

Other factors • Performance is dependent on  Bex query  Ipad versjon  Network (lan, 3g, 4g, wifi, …)

29

Conclusion

HANA together with SAP BusinssObjects and Mobility has enabled sales force at OFN with: – – – –

30

easy access to sales information tool that help them adjust their sales activities overview of information at all levels collaboration tool to share same information

DEMO