sap teched - abap studio - 21th · pdf filesap teched ba121: getting the data: ... sap bw/bi...

1 © 2012 LOCKHEED MARTIN CORPORATION. ALL RIGHTS RESERVED.

SAP TechEd

BA121: Getting the Data:

How Lockheed Martin Reports on

Enterprise Learning Data

Travis Steele Session BA121


Who I Am

Current role:

Project lead for SAP Business Objects (BOBJ) solution utilizing Web

Intelligence and Universe Design Tool (LSO module)

HANA lead involving acceleration (side-car), modeling, data

replication (LSO module)

SAP Interface team lead (LSO module)

SAP web services (REST & SOAP) team lead (LSO module)

Experience with:

SAP BW/BI CO Orders design and implementation and CO Projects

Query Changes (FI & CO modules)

ABAP developer for SAP PBL (WMIM & MM)

Module lead (WMIM & QM)

ME, WMIM & QM technical lead for SAP instances merger

BASIS support (roles, ids, Q transports)


Who Are We

Lockheed Martin Corporation

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 – 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


Lockheed Martin and SAP

1996: First licensed SAP

1999: One of the first certified SAP Competency Centers

2012: HCM Enterprise Learning Solution (LSO)

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


Learning Points

Objectives

Timeline

System Design

User Acceptance Testing

Issues

Lessons Learned

Next Steps


Objectives

Model HANA data to best answer the business

questions

Training History including delivery method (phase one)

Learning Plan (later phase)

Learning Activity (later phase)

Compliance Statistics & Status (later phase)

Demographics (later phase)

Implement BOBJ solution interfacing with HANA

Reduce existing batch job performance concerns in ECC

Lay the foundation to trigger the definition of future requirements

Investigate dashboarding

Consider strategy to implement BOBJ with

mobilization strategy in mind


Learning Points

Objectives

Timeline

System Design


Issues

Lessons Learned

Next Steps


Timeline


Learning Points

Objectives

Timeline

System Design


Issues

Lessons Learned

Next Steps


BOBJ Landscape Architecture

SAP

SLT

SAP

ECC

SAP

HANA

Secondary DB

Connection

SAP

BOBJ

&

Webi


Architecture deeper dive

HANA

SLT

BOBJ


Landscape

47 replicated tables

1 SLT rule assignment

44 Attribute views

2 Calculation views

1 Universe

3 Webi Template Reports

Universe.pdf


Rule assignment

http://scn.sap.com/community/replication-

server/blog/2014/02/27/how-toload-sap-long-text-to-hana-

using-slt

http://scn.sap.com/community/replication-server/blog/2014/02/27/how-toload-sap-long-text-to-hana-using-slt




















Attribute and Calculation views


Universe

Universe.pdf


Original Training History Report


Blank template


Training History Rpt Default


Training History Rpt All Fields


Learning Points

Objectives

Timeline

System Design


Issues

Lessons Learned

Next Steps



• Prerequisite for Testers to take online Webi training

• Developed incremental guidance for ad-hoc report creation related to business use cases

Demo Topics

Demo 1 Logging on

Navigation

Webi first query

Demo 2 Open existing Webi report

Sum/Count functions

Turn into functionality

Demo 3 Importing external file

Merge query

Demo 4 And/Or query filters

Filter bar

Adding filters in Webi

Input controls

Combined queries

Subquery

Demo 5

Blank template

Training History Rpt Default

Training History Rpt All Fields

Exporting files

Functions


Learning Points

Objectives

Timeline

System Design


Issues

Lessons Learned

Next Steps


Issues resulting in OSS incidents

Users not imported from entitlement system

Promotion management issue in CMC (different

SSL between dev and qa/prod)

Session timed out. Close java interface


Learning Points

Objective

Timeline

System Design


Issues

Lessons Learned

Next Steps


Lessons Learned

Hana replicated tables don’t necessarily keep the same

datatype as in the ECC system

Date issue cleanup

Required a jumpbox for QA/Prod UDT/IDT/Webi Rich client

access (and Design Studio)

Slight differences in HTML view vs applet view in BI

Launchpad

List of values for a filter are not grouped in any order and

maximum number of values returned less than 65,535

SAP Best practice is to use IDT rather than UDT


Replicated Data Types


List of values


HTML view vs Applet view

Applet

Applet

Applet

HTML

HTML

HTML


Learning Points

Objectives

Timeline

System Design


Issues

Lessons Learned

Next Steps


Next Steps

Enable additional ECC-side ABAP Acceleration.

Add the functional and matrix manager heirarchy

Create additional models and universes for reporting:

Learning Plan data

Learning Activity

Compliance Statistics & Status

Demographics

Implement dashboards based on requirements gathered

from UAT and go-live


Key Learnings

Creating HANA Models using Enterprise Learning Data

Designing the Enterprise Learning Data Universe

Reporting on Enterprise Learning Data using Webi in

the BI Launchpad


Questions?


Thank You

Feedback

Please complete a session evaluation for this session!

Session Code BA121

sap teched - abap studio - 21th · pdf filesap teched ba121: getting the data: ... sap bw/bi...

Documents