May 2015

Target Takes an International Journey with SAP HANA and Hitachi

Robb Neuenschwander, Lead Technical Architect Consultant, Target Corp.Scott Adcock, Technical Architect Consultant, Target Corp.Jason Whitfield, Strategic Initiative Consultant, Hitachi

• Target History

– Target Corporation was originally a division of Dayton Hudson Corporation.

– First Target store opened in 1962 (Roseville, MN)

– Headquartered in Minneapolis, MN

– Formats: SuperTarget, CityTarget, and most recently TargetExpress

TARGET BACKGROUND AND HISTORY

1800+ Stores US366,000+ Employees

36th in 2014 Fortune 500

$72.6B in revenue in 2014

36 Distribution Centers US

2nd largest discount retailer US

TARGET’S TIMELINE WITH SAP HANA

512GB Scale-up applianceacquired for lab use

2012 2013 2014 2015

4+2 Scale-Out (1TB Nodes)Supporting ERMA for Target Canada

4+1 Scale-Out (1TB Nodes)Supporting BW/BPC for Target Domestic

Expanded Target Canada Environment12 TB instance

• Context for International expansion in Canada– Two years from “go” to “open”– Limited scope BW on SQLServer (limited reporting)

• ERMA (Extended Retail Method of Accounting)

– Elements of Cost Method and Retail Method of Accounting

– ERMA on MS SQL Server cannot support volume of article (item) reclassifications (a must for our business)

– Design discussions with Hitachi on scaling for volume • Leveraged lab instance for research and design• Collaborative environment design driven by needs and

budget• Ratification of solution options with SAP

– Initial deployment – Hitachi UCP 8+2 BW on HANA on 512GB nodes

– Implementation Success• Removed need for physical reclassification. 4 weeks ->

instant• 50x improvement in query speed without redesign.

– Implementation Challenges• Appliance Model | Staff Experience | High Availability

ERMA USE CASE: GOING FROM 0 TO 100 IN A YEAR

INITIAL HANA DEPLOYMENT IN INTERNATIONAL BI ARCHITECTURE

SAP BW 7.4

Non-SAP or non Target

BEx

Mostly manual with Winshuttle query or TCode

SAP BW 7.3

/

Some manual, some automated

Mostly manual via BEx, slow an un automated

BEx

CSDS

EUC SQL “Now”

Other

• More demand, more cracks for Canada– Need for reporting/analytics in more subject areas– BW Partitioning and scaling blunted by rate of growth– Partnered with Hitachi on the growth of HANA– Trade-in and build-out of new environments

• Hitachi UCP 11+2 deployment with 1TB blades

– Using the data via HANA Modeling– Data Volume Management

• Meanwhile demand causing problems in domestic BPC instance

– Growing backlog of planning scenarios – insufficient capacity

– Implement BPC10 upgrade on BW on HANA– Hitachi UCP 4+1 (1TB Blades) Scale-Out– Implementation Success

• 71% improvement of BW/BPC data loads• Key planning scenarios implemented for new business

BW/BPC DOMESTIC USE CASE + CANADA EXPANSION

MATURE STATE INTERNATIONAL BI ARCHITECTURE

SAP BW 7.4+

Batch3rd Party

Application

Big Red

SmartData

FutureDevelopment

BW Extended Storage Near Line Storage

ODBC and MDX Access

SAP HANA Studio

Innovation Data

Physical integrationOr

SmartData

SmartData

Selective Realtime

BEx

Tool X

Tool X

• Hitachi and Target have a strong partnership with converged compute and storage business

• Hitachi has a competitive range of product configuration offerings.

• Hitachi featured strong engineering talent associated with the platform.

• Target was able to leverage implementation services through Hitachi Consulting Services.

WHY HITACHI UCP FOR SAP HANA