SAP-NLS Update Q1/2016

Roland Kramer, SAP EDW (BW/HANA), SAP SE

February 2016
Three things to know – Migration SAP BW on HANA
Blog: Three things to know when migrating SAP BW on SAP HANA

BW
7.40

HANA
DMO DB
upgrade/migration/unicode
in one technical step

BW
BW House- SAP Near-line
7.0x

keeping task any storage (NLS)

DB
smaller ROW store smaller COLUMN store
footprint in SAP HANA footprint in SAP HANA
SAP IQ

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 2

Nearline Storage (NLS) with SAP IQ
Decision Matrix Dynamic Tiering vs. SAP-NLS on InfoProvider Types

Supported
InfoProvider aDSO Standard w/o
Types per
InfoCube PSA
(BW 7.50) DSO DSO
‚temperature‘

not not
HOT recommended recommended
SAP
HANA
currently not currently not
WARM supported supported

supported by
COLD SAP
the PBS CBW
IQ

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 3

Nearline Storage (NLS) with SAP IQ
Specific features of SAP’s Nearline Solution for BW based on SAP IQ
Available as of today (July 2015)
• Optimized query performance when accessing NLS IQ data through
HANA Smart Data Access (SDA)
• NLS support for BW Inventory Cubes
SAP BW
NLS Interface • Automated mass generation of Data Archiving Processes based on
query selection statistics
SAP
• Generated HANA Models of an InfoProvider can access data in NLS
InfoCubes IQ
• Optimized lookup to archived data in NLS IQ using the Nearline
Interface Interface API
(Advanced)
DataStore
Objects
• DBA Cockpit for integrated Sybase IQ Monitoring
• Backup Automation: Event trigger for incremental backup in IQ after
data relocation to NLS
• Full SSL encryption of SAP IQ including SDA to SAP HANA
SAP HANA • Massive Performance Improvement through load striping
(0.7 - 1TB/h with over 90% compression)

© 2015
2014 SAP
SAP SE
SE or
or an
an SAP
SAP affiliate
affiliate company.
company. All
All rights
rights reserved.
reserved. Internal 4
Big Data - Nearline Storage (NLS) with SAP IQ
SAP BW 7.50 - starting with SP02

Recap BW 7.4 SP8

• NLS Support for BW Inventory InfoCubes
• Mass Maintenance Support
SAP BW • Query optimizations for NLS
• Throughput optimizations in archiving through new

InfoCubes
NLS Interface parallelization options and load striping
SAP IQ
DataStore
Object
New with SAP BW 7.50
Interface • NLS support for Advanced DSOs with active tables*
• Reporting value help (F4) can display posted values
aDSO
from near-line storage for Advanced DataStore
Objects*
Transparent access to all data (*)
• CompositeProvider can use Advanced DataStore
Disk Objects with NLS in specific join scenarios*
Store
SAP HANA • BW process type to create Database Statistics for
NLS accesses (via Virtual Tables)
(*) Functional limitations apply as of SPS 10 * See SAP Note 2215265

© 2015
2014 SAP
SAP SE
SE or
or an
an SAP
SAP affiliate
affiliate company.
company. All
All rights
rights reserved.
reserved. Internal 5
Nearline Storage (NLS) with SAP IQ
More Flexibility with Transaction RSDANLCON - system copy and performance

Additional Information
provided via F1 Help

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 6

Nearline Storage (NLS) with SAP IQ
NLS Support for Inventory Cubes - Solution Details

• The allowed characteristics for time slices in the Data Archiving Process shall be only the most refined common
time reference characteristic. Users can only enter relatively time conditions such as ‘Only Data Records Older
than’ to ensure that the resulting Archiving interval is consistently with an lower boundary equal ‘0’ without gaps.
This ensures the best query performance.

• Archiving of uncompressed data is not possible for Non-Cumulative Cubes.

• During the execution of a query the inventory-handling in the data-manager checks whether there is an adjunct
near-line-storage and if the time-interval, requested by the query has an overlap with the overall time slice
partition in the near-line-storage (Partition Pruning)

• If so a query with the same restriction as the ‘delta’-query of the standard inventory-handling is sent to the
archive, too.

• The records, which are returned from the archive, are added to the deltas read from the standard cube and then
the further inventory-processing works as usual

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 7

Nearline Storage (NLS) with SAP IQ
Inventory InfoProvider - Theory
Near-line Online

goods receipt

goods issue

Calculated during query

runtime
Delta query

t1 t2 persistent

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 8

NLS Solution for Inventory InfoCubes
Fully supported with SAP BW 7.40 SR2 (SP08)

Restrictions in the DAP (Design time)

 The only allowed time characteristics in the
Data Archiving Process is the most refined
common time reference characteristic (default value)
 Users can only enter relatively time conditions

Precondition for Archiving

 Data has to be compressed before archiving

Execution of inventory query

(with existing Near-line-Storage)
 Partition Pruning in data manager
 Delta Query on near-line Storage

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 9

Nearline Storage (NLS) with SAP IQ
SAP IQ Monitoring with Version 16.0 SP08 and higher
Available as of today (June 2015)

© 2015
2014 SAP
SAP SE
SE or
or an
an SAP
SAP affiliate
affiliate company.
company. All
All rights
rights reserved.
reserved. Internal 10
Nearline Storage (NLS) with SAP IQ
ABAP integration into DBACOCKPIT
Available as of today (June 2015)

© 2015
2014 SAP
SAP SE
SE or
or an
an SAP
SAP affiliate
affiliate company.
company. All
All rights
rights reserved.
reserved. Internal 11
Nearline Storage (NLS) with SAP IQ
Everything you need to know about SAP IQ - SAP First Guidance

28.03.2013

© 2015
2014 SAP
SAP SE
SE or
or an
an SAP
SAP affiliate
affiliate company.
company. All
All rights
rights reserved.
reserved. Internal 12
Synergy PBS CBW Add-On and the SAP-NLS Implementation
Closing the functional gap on lower BW Releases
SAP-NLS Release capabilities
Inventory Cubes
PBS CBW NLS IQ Add-On 7.40
Smart Data Access
• Detailed e2e Monitoring
• Detailed Query Analysis
• Fast Copy/Snapshot option SAP-NLS Reporting Layer (MultiProvider)
• Utilities for Planning NLS Projects
7.3x
• Add. Enhancement
PSA DAP
SAP-NLS for InfoCubes, DSOs and non Reporting Layer (Corp. Memory)
7.0x
BW Porting
Nearline Adapter (ABAP and Unicode based) from
7.0x
DBSL for Sybase ASE/IQ Kernel based; Open SQL + Native IQ SQL via ADBC)
General Porting onwards

Kernel
DB Client
ODBC Driver from IQ 7.2x

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 13

Outlook: SAP IQ DB Installation
With three Parameters fulfill a complete SAP IQ database for SAP-NLS

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 14

New possibilities with the CBW Add-On von PBS
“Automatic Unicode Migration” for historical data in SAP BW

• the Primary database must not be converted

to unicode beforehand and SAP IQ is already
implemented in the CESU-8 UC format.

• The Add-On can be used together with the

classical BW database platforms and with
BW on HANA.

• The nearline usage will result in a massive

database size reduction of the primary
database and improves the overall runtime of
the migration to BW on HANA.

• Details
CBW für SAP Nearline Storage mit IQ

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 15

The SAP-NLS Implementation - Release Capabilities
Evolving together with SAP BW, IQ and HANA aDSO
7.50
straggler mgt.

Inventory Cubes
Smart Data Access 7.40

SAP-NLS Reporting Layer (MultiProvider)

7.3x

SAP-NLS for InfoCubes, DSOs and non Reporting Layer (Corp. Memory)
7.0x
BW Porting
Nearline Adapter (ABAP and Unicode based) from
7.0x
General Porting onwards
DBSL for Sybase ASE/IQ Kernel based; Open SQL + Native IQ SQL via ADBC

Kernel
DB Client
ODBC Driver from IQ 7.2x

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 16

Roadmap* SAP BW-on-HANA NLS with SAP IQ
Summary
Today Planned Innovations Future Direction*
(BW 7.5 SP01) (BW 7.5 SP04) (2016/2017*)

• Supporting the Advanced DataStore • Supporting Advanced DataStore • NLS integration with HANA Data
Object (with Active Table, except “direct Objects w/o activation Lifecycle Management (including NLS
update” – see SAP Note 2215265) • Partner Interface for Nearline Storage exceptional update support for
• Reporting value helps (e.g. variable on Advanced DataStore Object Advanced DataStore Objects)
dialog) can display posted values from • Supporting Advanced DataStore
• Mass Maintenance Support to include
nearline storage for Advanced Data Archiving Processes on Advanced Objects with inventory support
DataStore Objects DataStore Objects • Selective Deletion on Nearline Stores
• CompositeProvider can use Advanced • Nearline Storage on HADOOP • SAPHostAgent Integration - Engine
DataStore Objects that use nearline based SAP installation routine of the
storage in join conditions • NLS exceptional update support for
classic DataStore Objects (piloting only) SAP IQ database
• Creation of Database Statistics for
Virtual Tables as BW process type (for
optimized access to Nearline Tables in
SAP IQ)

*This is the current state of planning and may be changed by SAP at any time.

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Internal 17

Thank you
Roland Kramer
Product Management SAP EDW (BW/HANA)
SAP SE | Dietmar-Hopp-Allee 16 | DE-69190 Walldorf | Germany
[email protected]
@RolandKramer

© 2015 SAP SE or an SAP affiliate company. All rights reserved.

© 2016 SAP SE or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate
company) in Germany and other countries. Please see http://global12.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices.

Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors.

National product specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its
affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and
services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as
constituting an additional warranty.

In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop
or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future
developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time
for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-
looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place
undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.

© 2016 SAP SE or an SAP affiliate company. All rights reserved. Public