SAP First Guidance - SAP NetWeaver BW 7.40 / 7.50 powered by SAP HANA - Inventory Handling and Non-Cumulative Key Figures
One of the key differentiators of SAP BW are the various easy-to-consume options to model business semantics without the need to care for their technical implementation. The delta capability of DataStores, hierarchies, elimination of internal business volume, and non-cumulative key figures are just a few examples. Download the DocumentSAP First Guidance
SAP NetWeaver BW 7.40 / 7.50
SAP HANA Platform
Applicable Releases:
SAP BW 7.40 powered by SAP HANA (SP05 or higher)
SAP BW 7.50 powered by SAP HANA
This First Guidance Document is part of a series of documents that should help understand
the various concepts of SAP BW powered by SAP HANA. It is not intended to be exhaustive.
Its purpose is to deliver additional information besides SAP Help and blogs.
For more information or feedback, please contact: dominik.graus@sap.com.
Version 1.1
April 2016
SAP First Guidance
SAP NetWeaver BW 7.40 / 7.50 powered by SAP HANA
Inventory Handling and Non-Cumulative Key Figures
SAP NetWeaver BW 7.40 / 7.50
SAP HANA Platform
Applicable Releases:
SAP BW 7.40 powered by SAP HANA (SP05 or higher)
SAP BW 7.50 powered by SAP HANA
This First Guidance Document is part of a series of documents that should help understand
the various concepts of SAP BW powered by SAP HANA. It is not intended to be exhaustive.
Its purpose is to deliver additional information besides SAP Help and blogs.
For more information or feedback, please contact: dominik.graus@sap.com.
Version 1.1
April 2016
SAP First Guidance
SAP NetWeaver BW 7.40 / 7.50 powered by SAP HANA
Inventory Handling and Non-Cumulative Key Figures
© Copyright 2016 SAP AG. 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 AG. The
information contained herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors
contain proprietary software components of other software vendors.
Microsoft, Windows, Excel, Outlook, and PowerPoint are registered
trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p,
System p5, System x, System z, System z10, System z9, z10, z9, iSeries,
pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390,
OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power
Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER,
OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS,
HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex,
MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and
Informix are trademarks or registered trademarks of IBM Corporation.
Linux is the registered trademark of Linus Torvalds in the U.S. and other
countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either
trademarks or registered trademarks of Adobe Systems Incorporated in
the United States and/or other countries.
Oracle is a registered trademark of Oracle Corporation.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open
Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame,
and MultiWin are trademarks or registered trademarks of Citrix Systems,
Inc.
HTML, XML, XHTML and W3C are trademarks or registered trademarks
of W3C®, World Wide Web Consortium, Massachusetts Institute of
Technology.
Java is a registered trademark of Sun Microsystems, Inc.
JavaScript is a registered trademark of Sun Microsystems, Inc., used
under license for technology invented and implemented by Netscape.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP
BusinessObjects Explorer, StreamWork, and other SAP products and
services mentioned herein as well as their respective logos are
trademarks or registered trademarks of SAP AG in Germany and other
countries.
Business Objects and the Business Objects logo, BusinessObjects,
Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other
Business Objects products and services mentioned herein as well as their
respective logos are trademarks or registered trademarks of Business
Objects Software Ltd. Business Objects is an SAP company.
Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere,
and other Sybase products and services mentioned herein as well as their
respective logos are trademarks or registered trademarks of Sybase, Inc.
Sybase is an SAP company.
All other product and service names mentioned are the trademarks of
their respective companies. Data contained in this document serves
informational purposes only. National product specifications may vary.
The information in this document is proprietary to SAP. No part of this
document may be reproduced, copied, or transmitted in any form or for
any purpose without the express prior written permission of SAP AG.
This document is a preliminary version and not subject to your license
agreement or any other agreement with SAP. This document contains
only intended strategies, developments, and functionalities of the SAP®
product and is not intended to be binding upon SAP to any particular
course of business, product strategy, and/or development. Please note
that this document is subject to change and may be changed by SAP at
any time without notice.
SAP assumes no responsibility for errors or omissions in this document.
SAP does not warrant the accuracy or completeness of the information,
text, graphics, links, or other items contained within this material. This
document is provided without a warranty of any kind, either express or
implied, including but not limited to the implied warranties of
merchantability, fitness for a particular purpose, or non-infringement.
SAP shall have no liability for damages of any kind including without
limitation direct, special, indirect, or consequential damages that may
result from the use of these materials. This limitation shall not apply in
cases of intent or gross negligence.
The statutory liability for personal injury and defective products is not
affected. SAP has no control over the information that you may access
through the use of hot links contained in these materials and does not
endorse your use of third-party Web pages nor provide any warranty
whatsoever relating to third-party Web pages.
SAP “How-to” Guides are intended to simplify the product implement-
tation. While specific product features and procedures typically are
explained in a practical business context, it is not implied that those
features and procedures are the only approach in solving a specific
business problem using SAP NetWeaver. Should you wish to receive
additional information, clarification or support, please refer to SAP
Consulting.
Any software coding and/or code lines / strings (“Code”) included in this
documentation are only examples and are not intended to be used in a
productive system environment. The Code is only intended better explain
and visualize the syntax and phrasing rules of certain coding. SAP does
not warrant the correctness and completeness of the Code given herein,
and SAP shall not be liable for errors or damages caused by the usage of
the Code, except if such damages were caused by SAP intentionally or
grossly negligent.
Disclaimer
Some components of this product are based on Java™. Any code change
in these components may cause unpredictable and severe malfunctions
and is therefore expressively prohibited, as is any decompilation of these
components.
Any Java™ Source Code delivered with this product is only to be used by
SAP’s Support Services and may not be modified or altered in any way.
No part of this publication may be reproduced or transmitted in any form
or for any purpose without the express permission of SAP AG. The
information contained herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors
contain proprietary software components of other software vendors.
Microsoft, Windows, Excel, Outlook, and PowerPoint are registered
trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p,
System p5, System x, System z, System z10, System z9, z10, z9, iSeries,
pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390,
OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power
Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER,
OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS,
HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex,
MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and
Informix are trademarks or registered trademarks of IBM Corporation.
Linux is the registered trademark of Linus Torvalds in the U.S. and other
countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either
trademarks or registered trademarks of Adobe Systems Incorporated in
the United States and/or other countries.
Oracle is a registered trademark of Oracle Corporation.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open
Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame,
and MultiWin are trademarks or registered trademarks of Citrix Systems,
Inc.
HTML, XML, XHTML and W3C are trademarks or registered trademarks
of W3C®, World Wide Web Consortium, Massachusetts Institute of
Technology.
Java is a registered trademark of Sun Microsystems, Inc.
JavaScript is a registered trademark of Sun Microsystems, Inc., used
under license for technology invented and implemented by Netscape.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP
BusinessObjects Explorer, StreamWork, and other SAP products and
services mentioned herein as well as their respective logos are
trademarks or registered trademarks of SAP AG in Germany and other
countries.
Business Objects and the Business Objects logo, BusinessObjects,
Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other
Business Objects products and services mentioned herein as well as their
respective logos are trademarks or registered trademarks of Business
Objects Software Ltd. Business Objects is an SAP company.
Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere,
and other Sybase products and services mentioned herein as well as their
respective logos are trademarks or registered trademarks of Sybase, Inc.
Sybase is an SAP company.
All other product and service names mentioned are the trademarks of
their respective companies. Data contained in this document serves
informational purposes only. National product specifications may vary.
The information in this document is proprietary to SAP. No part of this
document may be reproduced, copied, or transmitted in any form or for
any purpose without the express prior written permission of SAP AG.
This document is a preliminary version and not subject to your license
agreement or any other agreement with SAP. This document contains
only intended strategies, developments, and functionalities of the SAP®
product and is not intended to be binding upon SAP to any particular
course of business, product strategy, and/or development. Please note
that this document is subject to change and may be changed by SAP at
any time without notice.
SAP assumes no responsibility for errors or omissions in this document.
SAP does not warrant the accuracy or completeness of the information,
text, graphics, links, or other items contained within this material. This
document is provided without a warranty of any kind, either express or
implied, including but not limited to the implied warranties of
merchantability, fitness for a particular purpose, or non-infringement.
SAP shall have no liability for damages of any kind including without
limitation direct, special, indirect, or consequential damages that may
result from the use of these materials. This limitation shall not apply in
cases of intent or gross negligence.
The statutory liability for personal injury and defective products is not
affected. SAP has no control over the information that you may access
through the use of hot links contained in these materials and does not
endorse your use of third-party Web pages nor provide any warranty
whatsoever relating to third-party Web pages.
SAP “How-to” Guides are intended to simplify the product implement-
tation. While specific product features and procedures typically are
explained in a practical business context, it is not implied that those
features and procedures are the only approach in solving a specific
business problem using SAP NetWeaver. Should you wish to receive
additional information, clarification or support, please refer to SAP
Consulting.
Any software coding and/or code lines / strings (“Code”) included in this
documentation are only examples and are not intended to be used in a
productive system environment. The Code is only intended better explain
and visualize the syntax and phrasing rules of certain coding. SAP does
not warrant the correctness and completeness of the Code given herein,
and SAP shall not be liable for errors or damages caused by the usage of
the Code, except if such damages were caused by SAP intentionally or
grossly negligent.
Disclaimer
Some components of this product are based on Java™. Any code change
in these components may cause unpredictable and severe malfunctions
and is therefore expressively prohibited, as is any decompilation of these
components.
Any Java™ Source Code delivered with this product is only to be used by
SAP’s Support Services and may not be modified or altered in any way.
Document History
Document Version Description
1.0 First version of this guide
1.1 Updated chapter '2.2 Data Extraction and Transformation' and
chapter '4 Non-Cumulatives in Advanced DataStores'
Document Version Description
1.0 First version of this guide
1.1 Updated chapter '2.2 Data Extraction and Transformation' and
chapter '4 Non-Cumulatives in Advanced DataStores'
Typographic Conventions
Type Style Description
Example Text Words or characters quoted
from the screen. These
include field names, screen
titles, pushbuttons labels,
menu names, menu paths,
and menu options.
Cross-references to other
documentation
Example text Emphasized words or
phrases in body text, graphic
titles, and table titles
Example text File and directory names and
their paths, messages,
names of variables and
parameters, source text, and
names of installation,
upgrade and database tools.
Example text User entry texts. These are
words or characters that you
enter in the system exactly
as they appear in the
documentation.
<Example
text>
Variable user entry. Angle
brackets indicate that you
replace these words and
characters with appropriate
entries to make entries in the
system.
EXAMPLE TEXT Keys on the keyboard, for
example, F2 or ENTER.
Icons
Icon Description
Caution
Note or Important
Example
Recommendation or Tip
Type Style Description
Example Text Words or characters quoted
from the screen. These
include field names, screen
titles, pushbuttons labels,
menu names, menu paths,
and menu options.
Cross-references to other
documentation
Example text Emphasized words or
phrases in body text, graphic
titles, and table titles
Example text File and directory names and
their paths, messages,
names of variables and
parameters, source text, and
names of installation,
upgrade and database tools.
Example text User entry texts. These are
words or characters that you
enter in the system exactly
as they appear in the
documentation.
<Example
text>
Variable user entry. Angle
brackets indicate that you
replace these words and
characters with appropriate
entries to make entries in the
system.
EXAMPLE TEXT Keys on the keyboard, for
example, F2 or ENTER.
Icons
Icon Description
Caution
Note or Important
Example
Recommendation or Tip
First Guidance – Inventory Handling and Non-Cumulative Key Figures
April 2016
1
Table of Contents
1. Introduction .......................................................................................................................... 2
2. Scenario ................................................................................................................................ 2
2.1 Data Model ........................................................................................................................ 2
2.2 Data Extraction and Transformation ............................................................................. 4
3. Non-Cumulatives in InfoCubes ............................................................................................ 6
3.1 Non-Cumulatives in Classic InfoCubes .......................................................................... 6
3.1.1 Initial Stock Balance ........................................................................................... 7
3.1.2 Delta Movements ................................................................................................ 9
3.1.3 Historical Movements ........................................................................................12
3.1.4 Query Processing ...............................................................................................15
3.2 Non-Cumulatives in HANA-optimized InfoCubes in 7.3x .......................................... 16
3.2.1 Initial Stock Balance ......................................................................................... 16
3.2.2 Delta Movements .............................................................................................. 19
3.2.3 Historical Movements ....................................................................................... 20
3.2.4 Query Processing .............................................................................................. 23
3.2.5 Conversion of classic InfoCubes to HANA-optimized InfoCubes ................ 25
3.3 Non-Cumulatives in HANA-optimized InfoCubes in 7.40 and 7.50 ......................... 27
3.3.1 Initial Stock Balance ......................................................................................... 27
3.3.2 Delta Movements .............................................................................................. 29
3.3.3 Historical Movements ........................................................................................31
3.3.4 Query Processing .............................................................................................. 33
3.3.5 Switch of HANA-optimized InfoCubes created in SAP BW 7.3x to the
Optimized Non-Cumulative Handling as from SAP BW 7.40 ....................... 36
3.4 Summary Non-Cumulatives in InfoCubes ................................................................... 38
4. Non-Cumulatives in Advanced DataStores .......................................................................40
4.1.1 Initial Stock Balance ......................................................................................... 43
4.1.2 Delta Movements .............................................................................................. 45
4.1.3 Historical Movements ....................................................................................... 46
4.1.4 Query Processing .............................................................................................. 49
4.1.5 Extracting from Advanced DataStores ............................................................51
4.1.6 Non-Cumulatives in Advanced DataStores with Delta Calculation
Capabilities ........................................................................................................ 52
5. Non-Cumulatives in External SAP HANA Views ................................................................ 56
5.1.1 Restrictions ........................................................................................................ 56
5.1.2 Performance ...................................................................................................... 57
6. Archiving Data from InfoCubes with Non-Cumulatives .................................................... 59
7. Appendix ............................................................................................................................. 62
April 2016
1
Table of Contents
1. Introduction .......................................................................................................................... 2
2. Scenario ................................................................................................................................ 2
2.1 Data Model ........................................................................................................................ 2
2.2 Data Extraction and Transformation ............................................................................. 4
3. Non-Cumulatives in InfoCubes ............................................................................................ 6
3.1 Non-Cumulatives in Classic InfoCubes .......................................................................... 6
3.1.1 Initial Stock Balance ........................................................................................... 7
3.1.2 Delta Movements ................................................................................................ 9
3.1.3 Historical Movements ........................................................................................12
3.1.4 Query Processing ...............................................................................................15
3.2 Non-Cumulatives in HANA-optimized InfoCubes in 7.3x .......................................... 16
3.2.1 Initial Stock Balance ......................................................................................... 16
3.2.2 Delta Movements .............................................................................................. 19
3.2.3 Historical Movements ....................................................................................... 20
3.2.4 Query Processing .............................................................................................. 23
3.2.5 Conversion of classic InfoCubes to HANA-optimized InfoCubes ................ 25
3.3 Non-Cumulatives in HANA-optimized InfoCubes in 7.40 and 7.50 ......................... 27
3.3.1 Initial Stock Balance ......................................................................................... 27
3.3.2 Delta Movements .............................................................................................. 29
3.3.3 Historical Movements ........................................................................................31
3.3.4 Query Processing .............................................................................................. 33
3.3.5 Switch of HANA-optimized InfoCubes created in SAP BW 7.3x to the
Optimized Non-Cumulative Handling as from SAP BW 7.40 ....................... 36
3.4 Summary Non-Cumulatives in InfoCubes ................................................................... 38
4. Non-Cumulatives in Advanced DataStores .......................................................................40
4.1.1 Initial Stock Balance ......................................................................................... 43
4.1.2 Delta Movements .............................................................................................. 45
4.1.3 Historical Movements ....................................................................................... 46
4.1.4 Query Processing .............................................................................................. 49
4.1.5 Extracting from Advanced DataStores ............................................................51
4.1.6 Non-Cumulatives in Advanced DataStores with Delta Calculation
Capabilities ........................................................................................................ 52
5. Non-Cumulatives in External SAP HANA Views ................................................................ 56
5.1.1 Restrictions ........................................................................................................ 56
5.1.2 Performance ...................................................................................................... 57
6. Archiving Data from InfoCubes with Non-Cumulatives .................................................... 59
7. Appendix ............................................................................................................................. 62