slide1 l.
Download
Skip this Video
Download Presentation
Getting More From SAP

Loading in 2 Seconds...

play fullscreen
1 / 36

Getting More From SAP - PowerPoint PPT Presentation


  • 80 Views
  • Uploaded on

Getting More From SAP. David Jobling, CTO, Avanade UK Steve Butcher, Senior Architect for Mobile Solutions, Avanade UK Stef Shoffren, Snr Principal Consultant, Avanade UK. Agenda. Introduction SAP and Performance Point Analytics SAP and Windows Mobile Q&A. Introduction.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Getting More From SAP' - signa


Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
getting more from sap
Getting More From SAP

David Jobling, CTO, Avanade UK

Steve Butcher, Senior Architect for Mobile Solutions, Avanade UK

Stef Shoffren, Snr Principal Consultant, Avanade UK

agenda
Agenda
  • Introduction
  • SAP and Performance Point Analytics
  • SAP and Windows Mobile
  • Q&A
introduction
Introduction
  • Thousands of SAP implementations worldwide – customised
  • Cost of client licences prohibits the dissemination of the data
  • ‘SAP Surround’ is a suite of patterns and techniques to make SAP data more available and easier to work with
    • Extract to SQL Server for low cost, high value reporting and analytics
    • Expose via new channels using stock technology such as .NET and Windows Mobile
performance point analytics and sap
Performance Point Analytics and SAP

Customer Case Study

Stef Shoffren

customer situation
Customer Situation
  • Large, multi-national consumer goods company
  • Fragmented ERP systems
    • Converging onto SAP
  • Fragmented Reporting systems throughout Europe
  • Additional reporting requirements
why not use sap bex
Why not use SAP Bex?
  • SAP Business Explorer allows reporting on SAP BW held data but....
  • Can be very slow
  • Unintuitive for users
  • Lacking in functionality
  • Within the customer, SAP BW is vertically separated by country
why use microsoft performancepoint analytics
Why use Microsoft PerformancePoint Analytics
  • Clean easy to use interface
  • Web delivery of reports
  • Export to Excel functionality
  • Rich charting
  • Fast implementation times
  • High performance
  • European reporting possibilities
parallel projects
Parallel Projects
  • Sales Reporting
    • Large volumes
    • Data source: Multiple SAP BW databases
  • Promotional Analysis
    • Medium volumes
    • Data sources
      • Multiple SAP BW Databases
      • Siebel
sap bw terminology
SAP BW Terminology
  • InfoObject
    • A reference object (eg customer, product)
  • InfoCube
    • Self-contained dataset, normally localised to a business area (eg Direct Sales cube)
  • InfoSpoke
    • Mechanism to extract data from InfoObjects/InfoCubes
high level architecture
High Level Architecture
  • Web Front End Scale Out
  • Analysis Services Scale Out
landscape alignment
Landscape Alignment

BW Support Track

3

3

2

1

LEGEND

F

T

PP

P

Change flow

SSAS Support Track

Data flow

2

1

3

PP

P

F / T

SSASSQL 2005

SSAS Release Track

BWNW 2004

U

R

D / T

Production sized

3

3

1

1

E

DR sized

2

3

Development sized

3

BW Release Track

D

T

U

R

3

3

3

1

E

3

solution development
Solution Development
  • Staged Rollout Sync’d with SAP Rollout
    • Major and Minor Release schedules aligned
  • Leveraged Avanade Global Delivery Network
    • Migrate Development offshore over time
    • Provide offshore support for long term cost effectiveness
  • Team Foundation Server for Source Control
    • Access to TFS for WAN – TFS Proxy?
getting the data out of sap bw
Getting the Data out of SAP BW
  • SAP OpenHub Service Provides InfoSpokes
    • Specify DataSource (InfoObject or InfoCube)
    • Specify Mode (Delta or Full)
    • Specify Destination (Database or Flat file)
  • Limitations
    • Resetting of the source data in BW will reset the delta
    • InfoObjects need 2 InfoSpokes (1 for attributes, 1 for texts)
adding value with the etl
Adding Value with the ETL
  • SAP InfoObject provide a fragmented view of dimensions
    • Eg Product is split into 3 separate areas with no combined view
    • Value add: Provide a unified view of products
  • Bill of Materials are provided as separate measures
    • Only a few measures are provided for BOMS
    • Provide ANY measure with the ability to be analysed by BOM
  • ACA Analytics
    • ETL Framework
    • Lineage Tracking
best practices
Best Practices
  • Prevent Duplicate Runs
    • Use the OHREQUID to identify if data is already loaded
  • Use Delta InfoSpokes for large source datasets that are frequently changing
  • Need for Lineage Tracking
futures
Futures
  • SQL Server 2008
    • Multiple Readonly SQL Server Analysis Services Instances
    • C# for ETL coding
    • SSIS Performance Improvements
  • Additional Divisional Reporting
    • Financials
mobile sap
Mobile SAP

Steve Butcher

project background
Project Background
  • Customer Summary
    • Resources organisation present in 25 countries over five continents
    • 4,766 Employees, 1,716 UK based
  • Customer Relationship
    • Successfully introduced Windows Mobile as a viable alternative to BlackBerry
    • Deploying Windows Mobile across International countries as a platform for mobile messaging
  • Customer Challenge
    • Restricted access to SAP back office functionality restricted to internal network or VPN
    • Accessibility of Workflow and Business Intelligence through Enterprise Portal
aims and objectives
Aims and Objectives
  • Aims and Objectives
    • Extend the reach of SAP systems
    • Enable users to interact with business workflow processes
    • Leverage the Windows Mobile platform
    • Minimise impact on SAP systems and development team
    • Inherit security levels and roles enforcing data access
  • Enhanced Functionality
    • Add functionality to filter data by column and row to easily view and navigate BI data
    • Ability to visualise data through chart representation
  • Corporate Programmes
    • Workplace of the Future
proposed mobile solution
Proposed Mobile Solution
  • Utilise Avanade mobile solution platform to provide remote offline access to Enterprise Portal, Business Intelligence and SAP Workflow
  • Publish data through mobile application gateway using customer virtualisation environment

22

high level solution architecture
High Level Solution Architecture

Mobile Enablement Platform (4 Main Elements)

  • Integration Layer
  • Mobile Application Gateway
  • Synchronisation Services
  • Device Application

23

solution components sap integration
Solution Components | SAP Integration
  • SAP Integration Layer
    • Enterprise Portal
    • Business Intelligence
    • Workflow

24

solution components mobile application gateway
Solution Components | Mobile Application Gateway
  • Mobile Application Gateway (MAG) Functions
    • Extensible gateway controlling data flow
    • Processing of data retrieved through integration layer
    • Application workflow management
    • Data manipulation based upon business logic

25

solution components sync services
Solution Components | Sync Services
  • Synchronisation Services Functions
    • Optimised data transfer mechanism
    • Offline data storage
    • Secure data transfer
    • Windows Active Directory integration
    • Network connectivity management
    • Scalable architecture based upon standard Microsoft technologies

26

solution components device application
Solution Components | Device Application
  • Device Application Functions
    • Data Presentation
    • User Credentials Capture
    • Data Updates
    • Synchronisation Initiation

27

implementation approach
Implementation Approach
  • Prototype integration options
    • Enterprise Portal: WebDAV
    • Business Intelligence: .NET SQL Data Provider
    • Workflow: Web Services
  • Implement mobile application gateway (MAG)
    • Design / Implement Solution Architecture
    • Utilise Production Virtual Environment
    • Publish to the Internet
  • Develop mobile application
    • Agree process flow
    • User Interface
    • Forms Navigation
implementation approach prototype sap integration
Implementation Approach | Prototype SAP Integration
  • Enterprise Portal
    • Options: RSS, WebDAV
    • High Level Tasks: Access WebDAV folder, Process XML, Store in Database
    • Main Issues: .NET unable to access SAP WebDAV
  • Business Intelligence
    • Options: Direct Database Integration, Database Pass-through
    • High Level Tasks: Enable external access to SAP query, Prove access to SAP Query using SSRS, Store query output in DB
    • Main Issues: Data Serialisation
  • SAP Workflow
    • Options: .NET Connector, Web Services
    • High Level Tasks: Identify ABAP function, Remote Enabled, Create Web Service, Generate WSDL
    • Main Issues: External Web Service access, J2EE Server required
implementation approach mobile application gateway
Implementation Approach | Mobile Application Gateway
  • High Level Tasks:
    • Design Solution Architecture
    • Implement Web Services
    • Implement SQL Replication
  • Main Issues:
    • .SQL Replication (SQL Mobile versions)
implementation approach mobile application gateway32
Implementation Approach | Mobile Application Gateway
  • High Level Tasks:
    • Deploy Mobile Application Gateway (MAG) on virtualization platform
    • Publish to Internet
    • Implement security model
implementation approach mobile application gateway33
Implementation Approach | Mobile Application Gateway
  • High Level Tasks:
  • Main Issues:
    • Users vs. Business Input
  • Process Flow
  • Forms Navigation
  • UI Design
  • Security (ACA Devices)

33