SAP OLAP, Business Intelligence, & Analytics

© 2011 SAP AG. All rights reserved. 2

Model for Data Warehouse for Tyson Foods

Central Fact

PK DIMID_PRODUCTPK DIMID_CUSTOMERPK DIMID_TIMEPK DIMID_COPATIMEPK DIMID_ORGANIZATIONPK DIMID_DISTRIBUTION

VV100-CASES VV101-UNIT OF MEASURE VV102-GROSS SALES VV105-PRODUCT MFG VV301-GEN DIV ADMIN COST VV403-ADVERTISING VV407-GUARANTEED LOANS VV409-INTERCO COGS VV412-INTERCO COST ADJ VV424-PRODUCT RELAT EXP VV426-SALES RELATED EXP VV433-PRICING PROMO VVA01-SURCHARGE VVA02-OFF INVOICE DISC VVA04-BILLBACK VVA06-SALES ADJUST VVA07-PRIMARY BROKERAGE VVA10-SGML EXPENSE VVA11-SHUTTLE FRT VVA13-OUTSIDE FREEZR COST VVA14-TYSN FREEZR CHARGE VVA15-DIRECT MAILING VVA16-SALES & MKT EXP VVA18-GEN AND ADMIN VVA19-G AND a VVB01--ACCRUED ADVERTISING VVB02-ACCRUED MKT VVB09-INTERCO SALES VVB10-STEVEDORING VVB12--SALES ACCRUAL VVB19--FREIGHT FWD VVB20-INCENTIVE BROKERAGE VVB32-GENERAL VVB34-R AND D ACCRUAL VVB35-REGULAR COOP VVB39-SAMS UPCHARGE VVB41-SPECIAL COOP CHARGES VVB42-SLOTTING VVB47-AD HOC PROGRAMS VVJ13-INVENTORY ADJUSTMENT VVJ17-CONTRACT COST DISCOUNT Central FactCol1

PRODUCT DIMENSION

PK DIMID_PRODUCT

SID_PRODUCT WWML3-MINOR PRODUCT LINE *NOTE-- SEE DRAWING A

CUSTOMER DIMENSION

PK DIMID_CUSTOMER

SID_CUSTOMER **NOTE-- SEE DRAWING B

COPATIME

PK DIMID_COPATIME

SID_COPATIME WWFWK-FISC WK WWFWE-FISC WK END

ORGANIZATION DIMENSION

PK DIMID_ORGANIZATION

SID_ORGANIZATION PRCTR- PROFIT CENTER WWPRS-PRICING SEGMENT WWMLG-BUSINESS DIVISION

TIME DIMENSION

PK DIMID_TIME

SID_TIME 0CALMONTH 0CALQUART1 0CALYEAR 0FISCPER 0FISCVARNT 0CALWEEK

DISTRIBUTION DIMENSION

PK DIMID_DISTRIBUTION

SID_DISTRIBUTION VKBUR-SALES PERSON ZZSBK- SECONDARY BROKER ZZPBK- PRIMARY BROKER BZIRK- SALES DISTRICT

TYSON FROZEN FOODSCENTRAL FACT AND DIMENSIONS

AB

Dimension tables provide inputs for Fact table.

Fact table pulls together lots of master and transactional data.

© 2011 SAP AG. All rights reserved. 3

SAP Analytics Landscape

© 2011 SAP AG. All rights reserved. 4

Analytics: Sources-Capabilities-Access

© 2011 SAP AG. All rights reserved. 5

Product Directions (from BEx suite to BusinessObjects)

*Now called Analysis

*Now called Dashboards

© 2011 SAP AG. All rights reserved. 6

SAP BusinessObjects Explorer

For data exploration and visualization

Support for heterogeneous data sources

Easy and intuitive to use

For casual users with no training required

© 2011 SAP AG. All rights reserved. 7

SAP BusinessObjects Analysis

OLAP data access

Available in various editions – Web, Excel and Powerpoint

Multiple OLAP cubes in the same workspace

Optimized for highly interactive analysis

Several visualization options (scatter charts, radar charts etc.)

Exception highlighting

Drill-down capability

Ideal for power user

© 2011 SAP AG. All rights reserved. 8

SAP BusinessObjects Web Intelligence

Intuitive Web-based interface with offline capabilities

Ad Hoc Query, reporting and analysis

Multi-source access

Filtering, ranking, sorting, alerting, breaks and sections

Business-centric view of data with Universes

© 2011 SAP AG. All rights reserved. 9

SAP BusinessObjects Dashboard Design

Personalized dashboard online and offline

Flash-based interactive dashboards

Visualize anywhere – portal, reports, PDF, MS Office, Flash

Powerful “what-if” analysis with input controls (sliders, dials etc.)

Drill-down capability

Stunning graphics with skins, maps, charts, gauges and selectors

Integration with SAP BW InfoCubes

© 2011 SAP AG. All rights reserved. 10

SAP BusinessObjects Crystal Reports

Standard tool for reporting

Build any kind of report –such as business, financial, legal, and regulatory reports

Sophisticated report formatting: create multi-page, multi-query, pixel-perfect reports

Templates and wizards to speed up report creation

Secure, large-scale distribution of reports over the Web

Connectivity to any data source

© 2011 SAP AG. All rights reserved. 11

Different tools for different users

© 2011 SAP AG. All rights reserved. 12

Upcoming: Embedded Analytics within SAP Business Suite

In SAP ERP 6.0 EhP 5 – 16 SAP Crystal Reports and 19 SAP BusinessObjects Dashboards!

© 2011 SAP AG. All rights reserved. 13

In-Memory Computing

Technology that allows the processing of massive quantities of real time data in the main memory of the server to provide immediate results from analyses and transactions

SAP HANA – High Performance Analytic Appliance• A flexible, data source agnostic in-memory

appliance to quickly process and analyze large volumes of transactional data in real time

• Combines SAP software components optimized on hardware (blades) provided, and delivered, by SAP’s leading hardware partners.