1© 2015 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

SAP TechEd

Open Sesame: How Lockheed Paved the

Way to Enterprise Procurement Analytics

Pit C. TanSession DMM218

2© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Who I Am Current role:

Analytics and Reporting Tech Lead and Lead Engineer for LM’s

Corporate Procure-To-Pay (P2P) application

Technology includes BW HANA, HANA side-car, BOBJ

ABAP Acceleration (side-car), HANA modeling, SLT data replication

(sources: SUS, SRM, and ECC)

Migration of Oracle databases to HANA

Exposing Procurement data from BW and transaction systems

Investigating SAPUI5 with HANA backend (via ADBC)

Investigating SoH for ECC.

HANA upgrades & system management with Basis

Experience with:

SAP MM, QM, and Material Cost Estimating

3© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Who Are We

Lockheed Martin Corporation (LM)

Global defense, security, aerospace, and advanced technology

company. The majority of Lockheed Martin's business is with the

U.S. Department of Defense and U.S. federal government agencies.

Lockheed Martin operates in five business areas (BA’s) –

Aeronautics, Information Systems & Global Solutions, Missiles and

Fire Control, Mission Systems, and Training and Space Systems.

112,000 employees worldwide

2014 – Sales of 45.6 Billion USD

The Corporation's New York Stock Exchange symbol is LMT and its

web-address is www.lockheedmartin.com

4© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Lockheed Martin and SAP

1996: First licensed SAP

1999: One of the first certified SAP Competency Centers

2013: BW HANA (P2P), BI HANA side-car (P2P)

The Lockheed Martin SAP Landscape

10 SAP Finance and Operations systems, including international

Enterprise Procurement/Accounts Payable/MRP

Single Solution Manager system

Various BW, Business Objects and HANA implementations

5© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Learning Points

Satisfy diverse LM BA requirements

Use Cases satisfying requirements

Using HANA to expose SAP BW and ERP/SRM/SUS data

Monitoring system

Issues

Lessons Learned

Future

6© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Satisfy diverse LM BA requirements

Enable businesses to make real-time information driven

decisions

Reduce cost and reporting cycle time thru a simplified and

agile open access model

Open Architecture supports BA system access

Join P2P with BA top level data analytics

Self-service analytics for power user

7© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Learning Points

Satisfy diverse LM BA requirements

Use Cases satisfying requirements

Using HANA to expose SAP BW and ERP/SRM/SUS data

Monitoring system

Issues

Lessons Learned

Future

8© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Use Cases satisfying requirements

BA HANA via Smart Data Access (SDA)

BA BOBJ via JDBC or ODBC

P2P BOBJ self-service shareable queries

Provide alternative to SQVI/SE16(N) for increase

productivity

Oracle via ODBC

Microsoft SQL Server & Reporting tools via ODBC

BW InfoProviders are available via HANA Information

Views and SQL Views (“Extracts”)

9© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Learning Points

Satisfy diverse LM BA requirements

Use Cases satisfying requirements

Using HANA to expose SAP BW and ERP/SRM/SUS data

Monitoring system

Issues

Lessons Learned

Future

10© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Using HANA to expose BW, ERP,

SRM, SUS BW HANA

Expose BW modelled data thru HANA Information Views

and SQL Views

BI HANA

Expose SUS, SRM, and ECC tables

SLT for SUS, SRM, and ECC schemas

HANA Database ID Security

11© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

BW HANA

How to Import BW Objects to HANA Information Views?

Required HANA security settings

HANA Studio steps

URL Information

SQL Views?

Can be utilized to use Information Views so that the

metadata can be customized to suit BA needs like using

a custom schema name instead of _SYS_BIC or custom

field names instead of the BW names.

Can resolve shortening of names to 30 character limit for

schema, table, and column name in a SELECT

statement.

12© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

BI HANA

Replication Setup - Create three SLT Server Configuration

ECC

ECCDB schema

SRM

SRMDB schema

SUS

SUSDB schema

13© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

HANA Database ID Security

Provide a read-only database id using HANA user type

“Restricted”

Advantage

Read only compared to a typical database id

When created it has no privileges unlike the typical

database id where it gets PUBLIC

Add privileges only to SCHEMA or tables or objects it

has read access to

Cannot see system information in SYS schema

URL Information

14© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Learning Points

Satisfy diverse LM BA requirements

Use Cases satisfying requirements

Using HANA to expose SAP BW and ERP/SRM/SUS data

Monitoring system

Issues

Lessons Learned

Future

15© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Monitoring system - Auditing

Setup HANA Auditing:

Show top tables used and by which user

Tables not used for a period of time that consume large

memory can be removed

Show SQL statements used

URL Information

Tips on what to audit:

Define who you want to track and why

Do not track SLT ids – will add lots of entries

Consider not tracking ABAP Accelerator id

16© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Monitoring system - Memory

Monitor Loads and Unloads

Turn on Most Expensive SQL Trace

Consider turning on maximum memory used for queries.

SPS08 is global only. SPS09 or SPS10 supports per

database id

17© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Learning Points

Satisfy diverse LM BA requirements

Use Cases satisfying requirements

Using HANA to expose SAP BW and ERP/SRM/SUS data

Monitoring system

Issues

Lessons Learned

Future

18© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Issues

Oracle instances that are configured ASCII have data

truncated. P2P BW and BI HANA are both Unicode.

Resolved by creating SQL Views with function

TO_VARCHAR.

Oracle Gateway configuration settings were difficult to

figure out at first. There are specific settings that were not

clear. Eventually found correct gateway configuration for

both Oracle setup as ASCII and non-ASCII. Email me if

needed.

Oracle Gateway does not always send the exact query. In

one query, it removed the WHERE clause thereby

retrieving all records from HANA. Redesigned Oracle

query – although not always the most efficient but better

than no WHERE clause coming into HANA.

19© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Learning Points

Satisfy diverse LM BA requirements

Use Cases satisfying requirements

Using HANA to expose SAP BW and ERP/SRM/SUS data

Monitoring system

Issues

Lessons Learned

Future

20© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Lessons Learned

Good communication plan that includes Business Analyst

Leads versus the Power Users or BAs.

Understanding of data and SQL Savvy (have used

SE16(N) and SQVI).

HANA provides standard SQL objects not just Information

Views.

Productivity opportunity versus using SQLVI/SE16(N)

Performance can be an issue when JOINING tables that

are located in separate servers.

21© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Learning Points

Satisfy diverse LM BA requirements

Use Cases satisfying requirements

Using HANA to expose SAP BW and ERP/SRM/SUS data

Issues

Lessons Learned

Future

22© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Future

Possibilities:

Delivered content to HANA side-car: RDS, HANA Live,

BW Content (DXC)

Convert standard and custom BW modeled data to BI

HANA (side-car)

Lumira self-service

Power User ability to share Universes and WebI Free

Hand SQL in the repository

Upgrade to ECC, SRM, and SUS might create issues with

SLT. This could pose a down time.

Latest SLT version do support systematic structure

changes from sources

23© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Questions?

24© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Thank You

Feedback

Please complete a session evaluation for

this session!

Session Code DMM218

26© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Import BW Objects

http://help.sap.com/saphelp_hanaplatform/helpdata/en/4c/bc34af5f1

546e6b4dfb8fb05f25bca/content.htm

HANA Database Users

http://help.sap.com/saphelp_hanaplatform/helpdata/en/bd/856a90b

b5710148a47e5765db45e3e/content.htm?frameset=/en/ed/7af17e5

ae14de694d9bee5f35098f4/frameset.htm&current_toc=/en/00/0ca1

e3486640ef8b884cdf1a050fbb/plain.htm&node_id=225

References and Helpful Links

27© 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

Contact Information

Pit C. Tan – pitirim.c.tan@lmco.com (484)636-5566