-
SAP First Guidance SAP BW 7.40
SAP Realtime Database Platform
Applicable Releases:
SAP BW 7.40 SP08
SAP HANA and Studio 1.0 SP08
SAP GUI 7.30
and higher (suggested)
Availability in BW7.4 SP08 and SP09, Note 2070577
With the current SAP BW Release 7.40 a new way of modeling the BW objects was introduced with the SAP BW modeling tools. Now with the Release SAP BW 7.40 SR2 (based on SPS08) it is also possible to model a new central object called advanced data store objects (aDSO). To enable the Backend and Frontend functionality there are certain steps necessary to enable the end to end usage. This SAP First Guidance Document consolidates all these activities from an implementation perspective. The Document is work in progress and not intended to be exhaustive, but it contains everything to successfully implement the BW-MT together with BW-aDSO.
For more information, contact [email protected]
SAP First Guidance - SAP BW on HANA: Implementing the BW modeling tools (BW-MT) as the new SAP BW Modeling Experience
-
SAP First Guidance SAP BW 7.40
SAP Realtime Database Platform
Version 1.52
March 2015
-
Copyright 2015 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
SAPs Support Services and may not be modified or altered in any way.
-
Document History
Document Version Description
1.00 First release based on 7.40 SP08
1.10 7.40 SP09 adaption
1.20 Changed delivery sequence of BW-aDSO
1.30 Update for 7.40 SP09 final, SPAU/SNOTE corrections
1.40 BW-MT 1.6 Update for Query Generation
1.50 BW-MT Note Analyzer, 7.40 SP10 adaption
1.51 Separation of the Appendix
1.52 Updates for 7.40 SP10, BW-MT 1.70
-
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.
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
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 2
Table of Contents
1. Introduction ........................................................................................................................... 3
1.1 SAP BW Modeling Tools (BW-MT) ................................................................................ 3
1.2 Eclipse based query generation with BW-MT............................................................... 3
1.3 SAP BW advanced data store object (BW-aDSO) ....................................................... 4
2. Implementation ..................................................................................................................... 6
2.1 Backend Upgrade Considerations ................................................................................ 6
2.1.1 From 7.40 SP07 to SP08 (SR2) ....................................................................... 6
2.1.2 From 7.40 SP07 to SP09 or higher .................................................................. 6
2.1.3 From 7.40 SP08 (SR2) to SP09 or higher ....................................................... 7
2.1.4 Sequence of the Backend Implementation SP08/09 .................................... 7
2.1.5 From 7.40 SP10 onwards (recommended) ..................................................... 7
2.2 Backend Functionality Implementation ........................................................................ 8
2.2.1 Apply SAP Notes for SPAU/SNOTE for SP08/09 .......................................... 8
2.2.2 SAP Notes to implement in advance for SP08/09 ......................................... 8
2.2.3 Apply the BW-MT Notes ................................................................................. 10
2.2.3.1 Implementation sequence for SP08 ......................... 10
2.2.3.2 Implementation sequence for SP09 and higher ....... 11
2.2.4 Apply the BW-aDSO Notes .............................................................................. 11
2.2.4.1 Implementation sequence for SP08 .......................... 11
2.2.4.2 Implementation sequence for SP09 .......................... 11
2.2.4.3 Implementation sequence for SP10 .......................... 12
2.2.5 Apply additional BW-HAP Notes .................................................................... 13
2.3 Frontend Considerations ............................................................................................. 14
2.3.1 Apply the latest SAP GUI 7.30/7.40 corrections .......................................... 14
2.3.2 Install the current SAP HANA SP08 Studio ................................................... 15
2.3.2.1 Update the SAP HANA Studio to Version 2 (SP09) . 15
2.3.3 Install the BW modeling tools ......................................................................... 16
2.3.3.1 Install the ABAP development tools .......................... 17
2.3.3.2 Update the BW modeling tools to Version 1.5.x ....... 18
2.3.3.3 Update the BW modeling tools to Version 1.6.x ...... 20
2.3.3.4 Update the BW modeling tools to Version 1.7.x ....... 22
2.3.4 Creating a BW Query using the BW-MT 1.6 or higher ................................... 25
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 3
1. Introduction
With SAP BW 7.40 a lot of new functionality is introduced. The Release 7.40 also introduces new areas
which are made exclusively for the usage of SAP BW together with the SAP HANA database.
For details of the complete overview of the possibilities of SAP BW 7.40 RS2 (based on SPS08) see the
Document in the SCN - Overview SAP BW 7.4 SR2 (based on SPS08) and further Roadmap and the Blog -
SAP BW? - Three things to know...
1.1 SAP BW Modeling Tools (BW-MT)
1.2 Eclipse based query generation with BW-MT
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 4
1.3 SAP BW advanced data store object (BW-aDSO)
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 5
Details of the scope for the advanced DSO (and BW7.4 SP08 in general) can be found here:
http://scn.sap.com/docs/DOC-58173 => see "Release of SAP BW 7.4 SP8" page 11 et seq.
See the Blog from Klaus Nagel - The advanced DataStoreObject renovating BWs persistency layer
SAP BW 7.4 on SAP HANA / the In-Memory Data Fabric
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 6
2. Implementation
2.1 Backend Upgrade Considerations Overall Presentation for the Upgrade - Upgrade to SAP Business Warehouse 7.40
Note 1751237 - Add. Info about the update/upgrade to SAP NetWeaver 7.4 (incl. SPs and SRs)
2.1.1 From 7.40 SP07 to SP08 (SR2) As the SAP BW 7.40 SP08 is as well a feature pack, the Implementation of the SP has to be done with
the SUM/DMO tool. Either the latest Version of SP11 or the SP12 is recommended here.
For details in creation of the needed stack.xml see the SAP First Guidance Document -
SAP First Guidance - SEM/BW Modelling in SolMan 7.1 with MOPZ
For details in the SUM/DMO procedure see the SAP First Guidance Document -
SAP First Guidance - Migration BW on HANA using the DMO option in SUM
2.1.2 From 7.40 SP07 to SP09 or higher See the recommendations from Chapter 2.1.1
Additional Notes to consider:
Note 2086899 - Upgrade Phase MAIN_SHDRUN/ACT_UPG creates error messages
Note 2077976 - Table pool deletion incorrectly handled
Before you start the Upgrade with the SUM tool, move the already successful imported SAP Notes with
the transaction SNOTE from In Process to the Section Done.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 7
After the technical Upgrade is finished and before you start re-implementing the existing SAP Notes use
the mass functionality in the transaction SPAU to reset all obsolete SAP Notes first.
2.1.3 From 7.40 SP08 (SR2) to SP09 or higher Even that the SP can be applied with the ABAP SPAM transaction, the usage of the SUM tool is
recommended, as the SPAU handling and performance of the runtime is improved compare to the SPAM.
See the recommendations from Chapter 2.1.1
2.1.4 Sequence of the Backend Implementation SP08/09 1. Technical Upgrade to 7.40 SP08/09 as described above
2. Implement Corrections with high priority either for SP08 , SP09 or higher
3. Implement SAP Notes for NCUM (Non-Cumulative), HCPR (HANA Composite Provider), WSP (BW
Workspaces) Enhancements and problem solutions, External SAP HANA view, Open ODS view
either for SP08 or SP09
4. Implement the BW-MT SAP Notes either for SP08 , SP09 or higher
5. Implement the BW-aDSO SAP Notes either for SP08, SP09 or higher
6. Test the BW-aDSO scenario with the current BW-MT frontend
2.1.5 From 7.40 SP10 onwards (recommended) Starting with SAP BW 7.40 SP10 which will be released in Q1/2015 makes the described procedure for the
ABAP Backend in Chapter 2.1.4 almost obsolete.
If you want to start with the usage of the advanced DSO and the Query Generation with the BW modeling
tools, this would be the most eruption free option at all.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 8
2.2 Backend Functionality Implementation
2.2.1 Apply SAP Notes for SPAU/SNOTE for SP08/09
Note 1668882 - Note Assistant: Important notes for SAP_BASIS 730,731,740
Note 1679201 - Short dump OPEN_DATASET_NO_AUTHORITY in SPAU/SPDD
Note 2017638 - Corrections to SAP_UPDATE_DBDIFF and RS_BW_POST_MIGRATION
Note 2065063 - UPD: Collective run can't be triggered; update requests appear in status V1 processed
Note 2067561 - Cannot change component type with SNOTE
Note 2069795 - Avoid deadlock on database table DDFTX
Note 2073470 - RSWWWIDE: F1 Help for checkbox "Top-Level Work Items Only"
Note 2077553 - Obsolete version Implemented notes - Automatic adjust. for manual activities in SPAU
Note 2077587 - Change Matching Interfaces using SNOTE
Note 2080943 - SNOTE: Improvement of error message if object cannot be included in transport request
Note 2087437 - SNOTE: Deletion -> Remove texts from generated programs
Note 2088226 - SNOTE: Change to object with original in other system cannot be included in request
Note 2092021 - SPAU: Enhancement Framework objects also appear in "Other objects"
Note 2092114 - STRUST certificate response improvements
Note 2099092 - SE95: Display of objects in SAP Notes
2.2.2 SAP Notes to implement in advance for SP08/09
You can always look for the latest BW-MT Notes when you use the following Key Words in the SAP Notes
Search as follows - http://help.sap.com/notes SAPKW74009/SAPKW74010 and Keyword
NCUM (Non-Cumulative), HCPR (HANA Composite Provider), WSP (BW Workspaces)
Enhancements and problem solutions, External SAP HANA view, Open ODS view
Note 2062834 - Workspaces: Collective corrections for 7.40 SP8 - Part 2/2
Note 2070246 - Workspaces: Workspace Designer corrections as of 7.40 SP8
Execution of report: RS_UDO_NOTE_2081698, 2097526 and 2088567
Note 2083820 - Workspaces: Workspace Designer corrections as of 7.40 SP5
Note 2083403 - BW Workspaces: Local provider name instability - 740 SP08
Note 2073614 - Enhancement of InfoProvider Properties Maintenance (part 2)
Note 2093908 - InfoObject master data maintenance - collective corrections #9
Execution of report: RS_UDO_NOTE_2090146
Note 2097526 - BW-WHM-DBA-IOBJ
Note 2097526 - InfoObject as InfoProvider: Nachgenerierung des ColumnViews
Note 2066625 - Enhancements and problem solutions for SAP BW 7.40 SP10 (SAPBW74010)
Execution of report: RS_UDO_NOTE_2066625 and report RSDDB_INDEX_CREATE_MASS
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 9
Note 2067533 - Enhancements and problem solutions for SAP BW 7.40 SP10 (SAPBW74010)
Note 2092675, Execution of report: RS_UDO_NOTE_2067533, RS_UDO_NOTE_2067533_POST
Note 2069735 - Enhancements a. problem solutions for SAP BW 7.40 SP10 (SAPBW74010)
Note 2082113 - Enhancements a. problem solutions for SAP BW 7.40 SP10 (SAPBW74010) part 2
Note 2094221 - Enhancements a. problem solutions f. SAP BW 7.40 SP10 (SAPBW74010) part 3
Execution of report: RS_UDO_NOTE_2103571, RS_UDO_NOTE_2094221
Note 2033519 - External SAP HANA view for Advanced DataStore Object
Note 2068357 - External SAP HANA view: corrections for SAPKW74009
Note 2088567 - HCPR: CompositeProvider corrections for Release 7.40, part 10
Note 2107067 - HCPR: CompositeProvider corrections for Release 7.40, part 11
Note 2122411 - HCPR: CompositeProvider corrections 740 part 12
Note 2064668 - NCUM pushdown (corrections part II)
Note 2065824 - NCUM pushdown (corrections Part III)
Note 2096986 - NCUM: NCUM pushdown (corrections part IV)
Note 2097807 - BW740 SP08: RS_FBPA_AFTER_IMPORT fails because of BRAIN300
Note 2117312 - Collection note HAPs & HANA-Transformations
Note 2118057 - BW 7.40 SP8/SP9/SP10: HANA Analysis Proc a. HANA Transformations (Part 9)
Note 2079815 - Open ODS View- Corr. F. HANA CalcScenario, HANA Optimized Query Execution
Note 2103460 - Open ODS view: Data flow generation in main. using BW modeling tools 1/2
Note 2103568 - Open ODS view: Data flow generation in main. using BW modeling tools 2/2
Note 2076701 - BW HANA SDA: Corrections in BW 7.40 SP10
Note 2068075 - BICS: Values of exit variables remain empty after refresh
Note 2075103 - InA: SP10 Multiple Corrections
Note 2078969 - Classic DataStore missing in RSA1 Transport View
Note 2103833 - ABAP BICS: 7.40 SP10 Corrections
Note 2109129 - SAP HANA Execution: Inserted value too large for column
Note 2039115 - Advanced DSO: Definition of Calculation Scenario wrong
Note 2078256 - HCPR/ADSO: Corrections for InfoProvider support tools
Note 2083080 - Support for part pruning for ADSO
Note 2087670 - Query runtime for open ODS view in connection with advanced DSO
Note 2100659 - Non-cumulatives: Support of non-cumulative handling for advanced DSO
Note 2106590 - ADSO: Wrong Icon
Note 2008670 - Corrections for ST-A/PI 01Q & 01R (BW related content)
Under no circumstances cancel the implementation of an extended SAP Note when the Pop-Up applies
that there are Syntax Errors occur. This will lead to inconsistencies and a complete reset of the Note.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 10
2.2.3 Apply the BW-MT Notes
You can always look for the latest BW-MT Notes when you use the following Key Words in the SAP Notes
Search as follows http://help.sap.com/notes SAPKW74009/SAPKW74010 BW-MT
Note 1954169 - BWMT - Installation Details
Note 2091812 - BW Update 740 sp05/sp06/sp07 -> sp08/sp09
Note 2094475 - Report to implement BW-MT notes
BW Modeling Tools Install guide - http://service.sap.com/~sapidb/011000358700001144122013E
2.2.3.1 Implementation sequence for SP08
Use the Report Z_BW_NOTES_ANALYZER attached to the SAP Note
Note 2094475 - Report to implement BW-MT notes to implement the BW-MT SAP Notes.
(Up)Load the attached XML file BWMT_740_SP08_02.xml to the Report and execute.
.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 11
2.2.3.2 Implementation sequence for SP09 and higher
Follow the Instructions from Chapter 2.2.3.1
(Up)Load the attached XML file BWMT_740_SP09_02.xml to the Report and execute.
2.2.4 Apply the BW-aDSO Notes
You can always look for the latest BW-MT Notes when you use the following Key Words in the SAP Notes
Search as follows http://help.sap.com/notes SAPKW74009/ SAPKW74010 BW-aDSO
Note 2070577 - (advanced) DataStore Object - availability in BW7.4 SP08, SP09 and SP10
Please make sure, that you first implement the SAP Notes mentioned in Chapter 2.2.2 before continuing
with the BW-aDSO Notes.
If under some circumstances some of the already implemented BW-aDSO Note becomes inconsistent,
due to updates and corrections within these SAP Notes, e.g. 2051588, 2054460, 2063018, you must first
de-implement the additional Notes. Otherwise the time consuming implementation of the additional
Notes has to be done again.
2.2.4.1 Implementation sequence for SP08
Follow the Procedure from the following SAP Note:
Note 2070577 - (advanced) DataStore Object - availability in BW7.4 SP08, SP09 and SP10
2.2.4.2 Implementation sequence for SP09
Follow the Procedure from the following SAP Note:
Note 2070577 - (advanced) DataStore Object - availability in BW7.4 SP08, SP09 and SP10
Use the Report Z_BW_NOTES_ANALYZER attached to the SAP Note
Note 2094475 - Report to implement BW-MT notes to implement the BW-MT SAP Notes.
(Up)Load the attached XML file BWMT_ADSO_740_SP09_N23.xml to the Report and execute.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 12
2.2.4.3 Implementation sequence for SP10
Follow the Procedure from the following SAP Note:
Note 2070577 - (advanced) DataStore Object - availability in BW7.4 SP08, SP09 and SP10
If you're searching for advanced DSO related notes which are part of SP11, you can use SAP Notes Search
and filter according to the attachment Filter__ADSO_SP11_Notes.PNG
Note 2109210 - BW-aDSO: Do not implement! Note 19 / Part 1 (UDO)
Execution of report: RS_UDO_NOTE_2001253
Note 2109311 - BW-aDSO: Do not implement! Note 19 / Part 2 (Sourcecode)
---------------------------------------------------------------------------
Note 2119846 - BW-aDSO: Do not implement! Note 20 / Part 1 (UDO)
Execution of report: RS_UDO_NOTE_2119846
Note 2118292 - BW-aDSO: Do not implement! Note 20 / Part 2 (Sourcecode)
---------------------------------------------------------------------------
Note 2121237 - BW-aDSO: Do not implement! Note 21 / Part 1 (UDO)
Execution of report: RS_UDO_NOTE_2121237
Note 2121238 - BW-aDSO: Do not implement! Note 21 / Part 2 (Sourcecode)
---------------------------------------------------------------------------
Note 2126869 - BW-aDSO: Do not implement! Note 22 / Part 1 (UDO)
Execution of report: RS_UDO_NOTE_2128669
Note 2126870 - BW-aDSO: Do not implement! Note 22 / Part 2 (Sourcecode)
---------------------------------------------------------------------------
Note 2127121 - BW-aDSO: Do not implement! Note 23 / Part 1 (IF)
Note 2127122 - BW-aDSO: Do not implement! Note 23 / Part 2 (UDO)
Execution of report: RS_UDO_NOTE_2127122
Note 2129968 - BW-aDSO: Do not implement! Note 23 / Part 3 (Sourcecode)
---------------------------------------------------------------------------
Note 2132524 - ADSO: Incorrect field names in v2 view structure (UDO)
Execution of report: RS_UDO_NOTE_2132165
Note 2132165 - ADSO: Incorrect field names in V2 view structure
---------------------------------------------------------------------------
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 13
Note 2132732 - ADSO: Corrections
Note 2132987 - ADSO: Manage UI dumpt mit COMPUTE_INT_PLUS_OVERFLOW
Note 2135279 - ADSO: MNG UI dumpt mit COMPUTE_INT_PLUS_OVERFLOW
Note 2135205 - ADSO: Dataflow: Text, Name InfoSource will not be taken
Note 2128157 - SAP BW 7.40(SP11) advanced DSO read in Transformation
Note 2131815 - ADSO without setting 'activate data' cannot be activated
Note 2008670 - Corrections for ST-A/PI 01Q & 01R (BW related content)
2.2.5 Apply additional BW-HAP Notes
As the analytical capabilities on BW on HANA also used, it is suitable to implement the main correction for
BW-HAP (HANA analytical processes) as well. The Implementation of the relevant SAP Notes follows also
the procedure already explained by uploading a XML file with the Report Z_BW_NOTES_ANALYZER
Note 2117312 - Collection note HAPs & HANA-Transformations
(Up)Load the attached XML file BW_HAPTRF_740_SP09.xml to the Report and execute.
Furthermore there are some collective SAP Notes as well (component BW-WHM-DST-HAP):
Note 2144057 - SAP HANA Processing: BW 7.40 SP8 - SP11: HANA Analysis Processes and HANA
Transformations (Part 10)
Note 2152643 - SAP HANA Processing: BW 7.40 SP9 - SP11: HANA Analysis Processes and HANA
Transformations (Part 11) - Manual Activities
Execution of report: RSDHA_NOTE_2151197
Note 2151197 - SAP HANA Processing: BW 7.40 SP9 - SP11: HANA Analysis Processes and HANA
Transformations (Part 11)
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 14
2.3 Frontend Considerations
2.3.1 Apply the latest SAP GUI 7.30/7.40 corrections
Got to https://support.sap.com/software/patches.html and download the latest SAP GUI Patches for 7.30 or the new released SAP GUI 7.40.
This is also valid for the following components as well.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 15
2.3.2 Install the current SAP HANA SP08 Studio Note 2004651 - SAP HANA Platform SPS 08 Release Note
Note 2085810 - SAP HANA SPS 08 Database Revision 85
2.3.2.1 Update the SAP HANA Studio to Version 2 (SP09)
If you already installed a pre Version of the new SAP HANA Studio 2, you will be asked to migrate the
existing Studio Add-Ons and install some new components available now.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 16
2.3.3 Install the BW modeling tools
You can always go to the external URL - https://tools.hana.ondemand.com/#bw to update to the latest
Version of the ABAP in Eclipse and SAP BW Modeling tools.
Please Note that the Version 1.5.x or higher is necessary to use the BW-MT together with aDSO.
Note 2067813 - BW Modeling Tools for SAP HANA BW Release Note 1.5 PL0
Note 1955808 - BW Modeling Tools for SAP HANA BW: Supportstrategy
Note 2055662 - Standard transport management settings are not taken into account in the BW Modeling
Tools client
For download and installation instructions we strongly recommend to consult the installation guide for the
BW Modeling Tools on http://service.sap.com/~sapidb/011000358700001144122013E
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 17
2.3.3.1 Install the ABAP development tools
Note 2089844 - RTC of ABAP development tools for SAP NetWeaver 2.36
(The Installation guide is attached to the Note)
Add the downloaded ZIP file as local archive to the SAP HANA studio repository.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 18
2.3.3.2 Update the BW modeling tools to Version 1.5.x
There are two possibilities to update the BW-MT application:
You can access the update site at https://tools.hana.ondemand.com/
You can download the latest packages from the SAP at
https://support.sap.com/software/patches.html
This example describes the second option via the SAP Support Portal Support Packages and Patches
Get the latest files at the following location:
Unpack the *.ZIP file to a temporary directory and define a path to the directory following the screen in
the SAP HANA Studio.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 19
Now locate the local directory in the available software dialog of the SAP HANA Studio:
Install the Updates as described on the screen.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 20
Now you can use the latest version of the BW-MT together with the BW-aDSO functionality.
2.3.3.3 Update the BW modeling tools to Version 1.6.x
Start the SAP HANA Studio and go to Menu HELP install new Software and create a new Repository
based on a local Archive. You dont have unzipped the download file beforehand for that operation.
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 21
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 22
2.3.3.4 Update the BW modeling tools to Version 1.7.x
You will need to update your SAP HANA Studio to Rev. 92 or higher
Note 2115517 - SAP HANA SPS 09 Database Revision 92
Note 1954169 - BWMT - Installation details
Note 2126477 - RTC of ABAP development tools for SAP NetWeaver 2.41
Note 2067815 - BW Modeling Tools for SAP HANA BW Release Note 1.7 PL0
Note 2138863 - BW Modeling Tools for SAP HANA BW Release Note 1.7 PL1
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 23
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 24
See also the Blog from Stefan Hoffmann:
http://scn.sap.com/community/bw-hana/blog/2014/01/29/sap-bw-modelling-tools
And the SAP First Guidance Document - SAP BW 7.40 SP5 on HANA OpenODSView
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 25
2.3.4 Creating a BW Query using the BW-MT 1.6 or higher
Note 2067814 - BW Modeling Tools for SAP HANA BW Release Note 1.6 PL0
Note 2104488 - BW-MT: Corrections initial release of 1.6
ADT 2.36 - New version of ABAP Development Tools available now
Note 2071109 - Compatibility between BEx Query Designer and BW-MT Query Designer
Additional Notes for 7.40 for the ABAP Backend for BW-MT 1.6 included in 7.40 SP10:
Note 2073656 - BW MT: InfoObject development, part 1
Note 2102953 - BW-MT: Technical prerequisites for InfoObject Modeling
Execution of report: RS_UDO_NOTE_2102953 (Note 2102975)
Note 2073697 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP09 1
Note 2085060 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP09 2
Execution of report: RS_UDO_NOTE_2085060
Note 2094100 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP09 3
Execution of report: RS_UDO_NOTE_2094100
Note 2098294 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP09 4
Note 2110335 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP10 1
See the newly create Blog - http://scn.sap.com/docs/DOC-60474
For the following SAP Notes for the ABAP Backend the BW-MT 1.7 are required:
Note 2130028 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP10 2
Execution of report: RS_UDO_NOTE_2130028 afterwards
Note 2136139 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP10 3
Execution of report: RS_UDO_NOTE_2136139 afterwards
Note 2142635 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP10 4
Execution of report: RS_UDO_NOTE_2142635 afterwards
-
SAP First Guidance Implementation BW-MT and BW-aDSO
April 2015 26
The BW Modeling Tools for SAP HANA BW (in short: BW Modeling Tools) represents a new modeling IDE
(Integrated Development Environment) build on top of the Eclipse platform.
Its main objective is to support BW model developers in today's increasingly complex BI environments by
offering state-of-the-art modeling tools. These tools include integration with SAP HANA modeling and the
consumption of HANA elements in BW Open ODS Views, Advanced DSOs or CompositeProviders with
powerful UI (user interface) capabilities.
-
www.sap.com/contactsap
http://scn.sap.com/docs/DOC-7856