sap first guidance - bw-mt and adso v1a248.g.akamai.net/n/248/420835/60396f1a4fa9b54dbc2... · this...

SAP First Guidance

SAP BW 7.40/7.50/BW/4

SAP Realtime Database Platform

Applicable Releases:

SAP BW 7.40 SP08, 7.50 SP01, BW/4 SP00

SAP HANA and Studio 2.0 SP12

SAP GUI 7.40

and higher (suggested)

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. SAP BW 7.50 SP01 and SP04 is adding much more additional functionality, e.g. the feature complete BEx usage with the latest BW-MT tools. The BW-MT are mandatory for the usage with BW/4HANA. 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

mailto:[email protected]

SAP First Guidance

SAP BW 7.40/7.50/BW/4

SAP Realtime Database Platform

Version 1.70

June 2018

© Copyright 2018 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.

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

1.53 Corrections/Updates June 2015, BW-MT 1.80

1.54 Corrections/Updates July 2015

1.55 Additions for SAP BW 7.50 SP01, BW-MT 1.11

1.56 Additions for SAP BW 7.50 SP02, BW-MT 1.12

1.57 Update 04/2016, BW-MT 1.13

1.58 Update 09/2016, BW-MT 1.14/15

1.60 Update 11/2016, BW-MT 1.16

1.61 Update 01/2017

1.62 Update 02/2017, BW-MT 1.17

1.63 Update 05/2017, BW-MT 1.18

1.64 Update 05/2017, Repair F4 and Metadata search

1.65 Update 09/2017

1.66 Update 01/2018

1.69 Update 03/2018, BW-MT 1.19

1.70 Update 06/2018

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

SAP First Guidance … Implementation BW-MT for BW-aDSO

June 2018 2

Table of Contents

1. Introduction ......................................................................................................................... 4

1.1 SAP BW Modeling Tools (BW-MT) ...................................................................................4

1.2 Eclipse based query generation with BW-MT .................................................................4

1.3 SAP BW advanced data store object (BW-aDSO) .......................................................... 5

2. Implementation ................................................................................................................... 7

2.1 Backend Upgrade Considerations.................................................................................... 7

2.1.1 From 7.40 SP07 to SP08 (SR2) .......................................................................... 7

2.1.2 From 7.40 SP07 to SP09 or higher..................................................................... 7

2.1.3 From 7.40 SP08 (SR2) to SP09 or higher .........................................................8

2.1.4 Sequence of the Backend Implementation SP08/09 ......................................8

2.1.5 From 7.40 SP10 onwards (recommended) .......................................................8

2.2 Backend Functionality Implementation.......................................................................... 9

2.2.1 Apply SAP Notes for SPAU/SNOTE for SP08/09 ........................................... 9

2.2.2 SAP Notes to implement in advance for SP08/09 .......................................... 9

2.2.3 Apply the BW-MT Notes ......................................................................................11

2.2.3.1 Implementation sequence for SP08........................... 11

2.2.3.2 Implementation sequence for SP09 and higher ....... 12

2.2.4 Apply the BW-aDSO Notes ................................................................................ 12



2.2.4.3 Implementation sequence for SP10 ........................... 13

2.2.5 Apply additional BW-HAP Notes ....................................................................... 14

2.2.6 Apply additional BW-GUIBB Notes (WD GRID) ............................................... 15

2.3 Frontend Considerations ................................................................................................. 15

2.3.1 Apply the latest SAP GUI 7.30/7.40 corrections ............................................ 15

2.3.2 Install the current SAP HANA SP08 Studio ..................................................... 16

2.3.2.1 Update the SAP HANA Studio to Version 2 (SP09) . 17

2.3.3 Install the BW modeling tools ............................................................................ 17

2.3.3.1 Install the ABAP development tools ........................... 18

2.3.3.2 BW modeling tools Version 1.5.x (nlim) ..................... 19

2.3.3.3 BW modeling tools Version 1.6.x (nlim) .................... 22

2.3.3.4 BW modeling tools Version 1.7.x (nlim)..................... 24

2.3.4 Creating a BW Query using the BW-MT 1.8 or higher .................................... 26

2.3.4.1 BW modeling tools Version 1.13.x (nlim) ................... 29


2.3.4.3 BW modeling tools Version 1.15.x (nlim) .................... 31




3.1.1.2 Update the BW modeling tools to Version 1.19.x ..... 36


June 2018 3

3.2 Tipp’s and Troubleshooting ........................................................................................... 38

3.2.1 Backend search RSOSM/RSOS_SEARCH ..................................................... 38

3.2.2 Repair F4 help for BW-MT and AO ................................................................... 40

3.2.2.1 Report RSDDB_LOGINDEX_CREATE ........................ 40

3.2.2.2 Report RSDG_ADSO_ACTIVATE ............................... 40

3.2.2.3 External HANA View for Hierarchy ............................. 41

3.2.3 SICF Services need SSL connection ................................................................ 42


June 2018 4

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

https://scn.sap.com/docs/DOC-58173

http://scn.sap.com/community/bw-hana/blog/2014/02/06/sap-bw--three-things-to-know


June 2018 5

1.3 SAP BW advanced data store object (BW-aDSO)


June 2018 6

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

http://scn.sap.com/docs/DOC-58173

http://scn.sap.com/community/bw-hana/blog/2015/01/19/the-advanced-datastoreobject-renovating-bws-persistency-layer



June 2018 7

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”.


https://css.wdf.sap.corp/sap/support/notes/1751237




June 2018 8

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.


June 2018 9

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 1975910 - Mass reset of obsolete notes in SPAU

Note 1972294 - SPAU: Resetting of obsolete SAP Notes

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

(Components BC-DWB-DIC-AC/BC-UPG-NA, SAPKB74009/SAPKB74010)

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, BW-WHM-DBA-IOBJ

• 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 - InfoObject as InfoProvider: Regeneration of column views

http://service.sap.com/sap/support/notes/1668882

















http://help.sap.com/notes





June 2018 10

• 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

• 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)



https://websmp103.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=REDIR&_NNUM=2033519&_NLANG=E





















June 2018 11

2.2.3 Apply the BW-MT 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_04.xml to the Report and execute.

….

http://help.sap.com/notes

https://css.wdf.sap.corp/sap/support/notes/2091812


http://service.sap.com/~sapidb/011000358700001144122013E


https://websmp130.sap-ag.de/sap/support/sapnotes/public/services/attachment.htm?iv_key=012003146900001885122014&iv_version=0004&alt=2BCE4CB10DF674B172F4F3F7B32A284F4933B530308FF70F378C3730B4322B8A32CE2AD0ADAA4A0D8ACACEC82D898C74F377740D490A71764BCA352C728C8F8FF0CF0F0932D6750C09514BCECFCFCE4C8DCF4BCC4DB5F575F4F4F3F57771F571F6F70B01B25D83D4120B0A722092A599504EB16D715E3E00&iv_guid=DCE259BFDF07B84E86F4C5A79C1D7824


June 2018 12

2.2.3.2 Implementation sequence for SP09 and higher

Note 2133546 - BW-MT: Query Designer - Composite SAP Note

Follow the Instructions from Chapter 2.2.3.1

(Up)Load the attached XML file BWMT_740_SP09_04.xml to the Report and execute.

(Components BW-MT, BW-MT-HCPR, SAPKB74009/SAPKB74010)

2.2.4 Apply the BW-aDSO Notes


Search as follows - http://support.sap.com/notes BW-aDSO

(Component BW-WHM-DBA-ODS, SAPKW74009/SAPKW74010)

Note 2070577 - (advanced) DataStore Object - availability in BW7.4 SP08, SP09 and SP10

Note 2141114 - aDSO Implementation Prerequisites

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.


Follow the Procedure from the following SAP Note:





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.


https://websmp230.sap-ag.de/sap/support/sapnotes/public/services/attachment.htm?iv_key=012003146900001885122014&iv_version=0004&alt=2BCE4CB10DF674B172F4F3F7B32A284F4933B5303288F70F378A3730B4722933774D4CAB4A71334B740F30F47609332B742DD40D2EB1F489AA4A2DCD093270370D2937CC70D7750C09514BCECFCFCE4C8DCF4BCC4DB5F575F4F4F3F57771F571F6F70B01B25D83D4120B0A722092A599504EB16D715E3E00&iv_guid=50ABF7E3125B0D488DD57DBC3C3549D7

http://support.sap.com/notes







June 2018 13




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)


• Note 2109311 - BW-aDSO: Do not implement! Note 19 / Part 2 (Sourcecode)

---------------------------------------------------------------------------




---------------------------------------------------------------------------




---------------------------------------------------------------------------




---------------------------------------------------------------------------

• Note 2127121 - BW-aDSO: Do not implement! Note 23 / Part 1 (IF)




---------------------------------------------------------------------------

• Note 2132524 - ADSO: Incorrect field names in v2 view structure (UDO)


• Note 2132165 - ADSO: Incorrect field names in V2 view structure

---------------------------------------------------------------------------

• Note 2170305 - ADSO: Corrections (II) - UDO for SAP Note 2144548


• Note 2144548 - ADSO: Corrections (II)

---------------------------------------------------------------------------


https://service.sap.com/sap/support/sapnotes/public/services/attachment.htm?iv_key=012003146900000958842014&iv_version=0018&alt=2BCE4CB10DF674B172F4F3F7B32A284F4933B530348FF70F378A3730B4B2B03435F2AFAC702C2E367531080C2B71B57076F2C8F6D24D744DAEF02B728E774BF3352A8F370ED1750C09514BCECFCFCE4C8DCF4BCC4DB5F575F4F4F3F57771F571F6F70B01B25D83D4120B0A722092A599504EB16D715E3E00&iv_guid=68A3E9C1ED00C1458DD0AB33D4C25D69















June 2018 14

• 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 2176069 - ADSO: Fehler bei der Remodellierung

• 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)

• Note 2252865 - InfoObject search: CL_RSO_IS_VALUES_INFOOBJECTS,

ASSERTION_FAILED

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)


Transformations (Part 11) - Manual Activities

Execution of report: RSDHA_NOTE_2151197






















https://websmp130.sap-ag.de/sap/support/sapnotes/public/services/attachment.htm?iv_key=012006153200000103122015&iv_version=0001&alt=2BCE4CB10DF674B172F4F3F7B32A284F4933B5303488F70F378C3730B4AA488D772CF3AC34F14C0DF0314DCA2E4A0BF4290976AB08754E7736F40DAFF2CA30F7324FCDCC70D5750C09514BCECFCFCE4C8DCF4BCC4DB5F575F4F4F3F57771F571F6F70B01B25D83D4120B0A722092A599504EB16D715E3E00&iv_guid=60672D692B9E80458680A841D3900C26
















June 2018 15

2.2.6 Apply additional BW-GUIBB Notes (WD GRID)

With BW 7.40 you have an additional possibility to visualize the query output UI5 based via the

Transaction RSRT (component BC-WD-CMP-FPM). The corrections for the component GUIBB are part of

the user interface technology 7.40

Search as follows: http://support.sap.com/notes

SAPK-74013INSAPUI/ SAPK-74014INSAPUI GUIBB or with the component as filter.

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.

The Format of the SAP UI Landscape Format has change with SAP GUI 7.40

Note 2220930 - How to enable SAP UI Landscape format for SAP GUI for Windows 7.40

http://support.sap.com/notes

https://websmp230.sap-ag.de/sap/bc/bsp/spn/spat/index.htm?sp1=SAPK-74014INSAPUI

https://websmp230.sap-ag.de/sap/bc/bsp/spn/spat/index.htm?sp1=SAPK-74014INSAPUI

https://support.sap.com/software/patches.html



June 2018 16

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



June 2018 17

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-On’s and install some new components available now.

2.3.3 Install the BW modeling tools

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

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.

Due to the dependency of the BW Modeling Tools on SAP HANA Studio components, you need to use the

SAP Update site for Eclipse 4.5 (Mars) please use the following update site

https://tools.hana.ondemand.com/mars

Find the BW-MT Installation Information in the new SAP Help Portal

https://uacp2.hana.ondemand.com/viewer/841c96bc79644fcfb9fa7103aad9c15b/latest/en-

US/428e710b0e544e7fb185d348b494c467.html


https://tools.hana.ondemand.com/#bw

https://tools.hana.ondemand.com/mars

https://uacp2.hana.ondemand.com/viewer/841c96bc79644fcfb9fa7103aad9c15b/latest/en-US/428e710b0e544e7fb185d348b494c467.html

https://uacp2.hana.ondemand.com/viewer/841c96bc79644fcfb9fa7103aad9c15b/latest/en-US/428e710b0e544e7fb185d348b494c467.html


June 2018 18

Please Note that the Version 1.5.x or higher is necessary to use the BW-MT together with aDSO.

Note 1944835 - SAP BW Modeling Tools - Delivery Schedule

Note 1955808 - BW Modeling Tools for SAP HANA BW: Supportstrategy

Note 1971987 - How do I delete the local cache in the BW modeling workbench for Eclipse?

If there are fundamental Problems with the BW-MT authorization please consult the following Note

Note 1969032 - Missing authority for resources related to BW Modeling Tools

Authorization object 'S_ADT_RES' Resource access by ABAP Development Tools and BW Modeling Tools.

URI - /sap/bw/modeling/*

URI - /sap/bc/*

2.3.3.1 Install the ABAP development tools

Before you apply the ABAP Development Tools (ADT) you must update some additional native Eclipse

Plug-In’s (Mylyn) to enable the embedded start of the classical SAP GUI within the SAP HANA Studio.




https://launchpad.support.sap.com/#/notes/1969032


June 2018 19

To get an overview about the different Eclipse Version’s (named by the Solar System) you can have a look

to the URL - https://www.eclipse.org/downloads/

Note 2237323 - RTC of ABAP development tools for SAP NetWeaver 2.54

(The Installation guide is attached to the Note) – ABAP in Eclipse 2.54 SP00 Patch 07

Add the downloaded ZIP file as local archive to the SAP HANA studio repository.

2.3.3.2 BW modeling tools Version 1.5.x (nlim)

There are two possibilities to update the BW-MT application:

• You can access the update site at https://tools.hana.ondemand.com/mars

• You can download the latest packages from the SAP at


This example describes the second option via the SAP Support Portal Support Packages and Patches

Get the latest files at the following location:

https://www.eclipse.org/downloads/


https://support.sap.com/sap/support/sapnotes/public/services/attachment.htm?iv_key=012003146900001898312015&iv_version=0001&alt=2BCE4CB10DF674B172F4F3F7B32A284F4933B530348EF70F378C3730B48A0FF0CEF04D8A0834494DF7F588CFCDF209F52A2A0A2F2BF00831312888A8F2892C2C2D4DD3F50DD7750C09514BCECFCFCE4C8DCF4BCC4DB5F575F4F4F3F57771F571F6F70B01B25D83D4120B0A722092A599504EB16D715E3E00&iv_guid=36DEAEF14A0F284784ECC7C5FE19F647

https://tools.hana.ondemand.com/mars/



June 2018 20

Unpack the *.ZIP file to a temporary directory and define a path to the directory following the screen in

the SAP HANA Studio.

Now locate the local directory in the available software dialog of the SAP HANA Studio:


June 2018 21

Install the Updates as described on the screen.

Note 2067813 - BW Modeling Tools for SAP HANA BW Release Note 1.5 PL0


June 2018 22

Now you can use the latest version of the BW-MT together with the BW-aDSO functionality.


Start the SAP HANA Studio and go to Menu HELP install new Software and create a new Repository

based on a local Archive. You don’t have unzipped the download file beforehand for that operation.


June 2018 23


June 2018 24


You 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 2163135 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP11 2








June 2018 25


June 2018 26

2.3.4 Creating a BW Query using the BW-MT 1.8 or higher Note 1969032 - Missing authority for resources related to BW Modeling Tools


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

Note 2188070 - BW-MT: Host name used for "Attach HANA" cannot be customized

RSADMIN parameter BWMT_ATTACH_HANA_REFHOST

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






http://scn.sap.com/community/abap/eclipse/blog/2014/12/06/adt-236--new-version-of-abap-development-tools-available-now





June 2018 27





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:


Execution of report: RS_UDO_NOTE_2130028 afterwards










Execution of report: RS_UDO_NOTE_ 2166293 afterwards











• Note 2197872 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP12 7 / 7.50 SP0 1


• Note 2202613 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP12 8 / 7.50 SP02

• Note 2188070 - BW-MT: Host name used for "Attach HANA" cannot be customized

RSADMIN Parameter BWMT_ATTACH_HANA_REFHOST=<hostname used in SAP HANA Studio>






















June 2018 28

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.


June 2018 29


For the usage of the Query Designer of the BW Modeling Tools 1.13 it's required to have SP12 installed on

the SAP BW 7.40 including the latest code corrections mentioned in the 1.13 Release Notes.

Furthermore, the SAP HANA Studio Version 2 (Revision 102 or higher) and the ABAP Development Tools

(Version 2.51 or higher) are necessary. Higher Versions of these tools are already introduced with 1.12.x

Note 1944835 - SAP BW Modeling Tools - Delivery Schedule




Note 2152359 - BW search/input help for InfoObjects returns no results


Note 2304877 - BW-MT: Query Designer Corrections for SAP NetWeaver 7.40 SP15 2 / 7.50 SP3 4



Note 2318796 - BW-MT: Query Designer Corrections for … 7.40 SP16 1 / 7.50 SP3 7 / 7.50 SP4 1





The BW-MT Version 1.13.x is downwards compatible to the SAP BW 7.40 Backend using the latest

corrections available for SAP BW 7.40 SP13/14/15 and SAP BW 7.50 SP01/02/03

Eclipse Software Site:

For Eclipse Neon (4.6), use - https://tools.hana.ondemand.com/neon/















https://tools.hana.ondemand.com/neon/


June 2018 30


For the usage of the Query Designer of the BW Modeling Tools 1.14 it's required to have SP12 installed on

the SAP BW 7.40 including the latest code corrections mentioned in the 1.14 Release Notes.

Due to a problem in the UI library of Eclipse 4.5 (Mars), it's possible that by using embedded web sessions

the HANA Studio / Eclipse will be closed without any message.

This problem can occur by using the data preview, master data maintenance, or hierarchy maintenance

on 7.50 SP04 (or newer). The problem is solved with a BW-MT version based on Eclipse 4.6 (Neon).

In case you are entering such problems, then please install SAP HANA Studio 2.3.8 (Rev 122) which base

on Eclipse 4.6. You will also need the latest ABAP Development Tools (Version 2.60 or higher).

Note 2354063 - SAP HANA SPS 12 Database Maintenance Revision 122.02


Note 2284434 - BW Modeling Tools for SAP HANA BW Release Note 1.14


Note 2328802 - Open ODS View: New Wizard in BW-Modeling Tools 1.14

Note 2339916 - 1ROWCOUNT details in query designer cannot be shown


See the SAP Notes relevant for the BW-MT 1.13.x


https://websmp202.sap-ag.de/~form/handler?_APP=01100107900000000342&_EVENT=DISPL_TXT&_NNUM=2339938&_NLANG=E





June 2018 31


Starting with 1.15 the DataFlow editor is part of the BW Modeling Tools.

The usage of the DataFlow editor requires BW/4HANA 1.00 as the server instance.

Modeling of Aggregation Levels, DataSource, InfoSource, Open Hub Destination and Semantic Group

Object. Requires SAP BW 7.50 SP04 on HANA or newer.

The minimum Backend Versions are SAP BW on HANA 7.50 SP05 and BW/4HANA 1.0 SP01

Installation Guide BW-MT 1.15 - https://service.sap.com/~sapidb/011000358700001144122013E

Note 1954169 - BWMT - Installation Details

Note 2133546 - BW-MT: Query Designer - Composite SAP Note

Note 2343707 - After an upgrade to BW 7.50 SP4 or higher no HANA Views can be added to a CoProvider



Note 2361868 - BW Modeling Tools for SAP HANA BW Release Note 1.15 Patch 01


Note 2152359 - BW search/value help/search/open object in SAP BW modeling tools returns no result

Eclipse Software Site: For Eclipse Neon (4.6), use - https://tools.hana.ondemand.com/neon/


Note 2361397 - BW-MT: Query Designer Corrections for SAP 7.40 SP15 10 / 7.50 SP3 12 / 7.50 SP5 2

Note 2348036 - BW-MT: Query Designer Corrections 1.00 SP0 1

Note 2359313 - BW-MT: Query Designer Corrections for BW/4HANA 1.00 SP0 2

Note 2364828 - BW-MT: Query Designer Corrections - 09/2016 1








Important note regarding the automatic task generation and support of old 3.x queries:

By default the automatic task generation for writing changes of a query on a transport request is switched

off. You can change the handling by set the RSADMIN parameter QUERY_TASK_CHECK to the value 'X'.

To open 3.x queries in HANA modeling tools you can add the following parameter to table RSADMIN:

OBJECT = QUERY_BW3X_SUPPORT VALUE = X

https://service.sap.com/~sapidb/011000358700001144122013E








https://tools.hana.ondemand.com/neon/














June 2018 32


Note 2363299 - SAP HANA 2.0 SPS 00 Database Revision 2.00.000


Note 2393196 - Modeling Tools for SAP BW/4HANA and SAP BW powered by SAP HANA: Release Note

1.16 Patch 01


1.16 Patch 02

Patches for SAP NetWeaver ADT 2.68

Note 2378227 - Application component cannot be maintained / editor does not work

Note 2392410 - Certain queries are not offered in the open dialog

Note 2397525 - Certain queries or subobjects are not displayed in the project explorer

Note 2396002 - Unable to open sub InfoAreas in BW eclipse Modelling tools perspective in HANA Studio

after BW support package update or upgrade

Note 2409105 - New DataSource cannot be found in project explorer / DataSource hierarchy

Note 2380962 - Enable BWMT Resource Capabilities Support and Navigation Attributes with Local

Names for CompositeProviders

Note 2416068 - Unterstützung History Version für BW-MT Objekte (HCPR, IOBJ, ADSO, SEGR,...)

Installation Guide BW-MT 1.16 - http://service.sap.com/~sapidb/011000358700001144122013E

Starting with 1.16 the editors will be grouped in the workbench feature apart from the editors related to

BW queries. Furthermore, with 1.16 it's possible to perform an installation without SAP HANA Studio. The

ABAP Development Tools are still required. Please check the installation guide for further details.

Shipment of the first version of the editor for application components. This feature is available on

BW/4HANA only. Please note that it's required to apply the correction 2378227 before the editor can be

used.


(Component BW-MT-ELEM)












https://service.sap.com/~form/handler?_APP=00200682500000001043&_EVENT=INFO&INFONR=002007974700001926892016


















June 2018 33



1.17 Patch 00


1.17 Patch 01


1.17 Patch 02


Starting with 1.17 the Initial Version of the new Source System editor for usage on top of BW/4HANA is

delivered.

Note 2421804 - BW/4 Source System Editor: Long Response Times with Remote Sources bases on

HANA SDI

Note 2427646 - MT: Service cannot be reached on BW reporting Preview

Note 2437368 - R: BWMT: 1.18: PRE: Exception on opening CKF from where used search results














Note 2475944 - BW-MT: Query Reporting Service - 06/2017 1

Note 2485006 - BW-MT: Query Reporting Service - 06/2017 2































June 2018 34



1.18 Patch 00


1.18 Patch 01


1.18 Patch 02


1.18 Patch 03


1.18 Patch 04


1.18 Patch 05




Note 2515487 - ADT: LandscapeXML format is not detected in certain environments

Note 2477132 - Eclipse Memory Error editing AMDP coding

Note 2624105 - Eclipse Does not startup after Webdynpro Change

With SAP BW Modelling tools 1.17, user can create any source system directly from Eclipse based SAP

BW Modelling tools. This is editor is only available for SAP BW/4 HANA system whereas in SAP BW on

HANA system user still need to define source system via traditional SAP GUI interface.

https://blogs.sap.com/2017/10/04/sap-bw-modelling-tools-odp-source-system-editor/

Starting with 1.18 the necessary extension and tools for BPC for BW/4HANA are delivered.

Tree structure for calculated and restricted key figures can be maintained in InfoProvider view

(corresponds to the tx. RSZTREE)

(BW/4HANA 1.0 SP4) A query can be created based on another query where a switch of the InfoProvider

is possible. Furthermore, the new created queries can be created as a link component. A linked

component cannot be changed, but synchronized in case the source query was changed.




















https://blogs.sap.com/2017/10/04/sap-bw-modelling-tools-odp-source-system-editor/



June 2018 35


The correction is only required for creation of linked queries on BW/4HANA 1.0 SP4 or higher.

Please note this code correction requires the Query Designer version 1.18 PL1 or higher of the BW Modeling

Tools (Component BW-MT-ELEM)

Note 2464336 - BW-MT: Query Replication Service – 05/2017 1









Note 2536608 - Query persistency does not consider new planning features - Part 1

Note 2537932 - BW-MT: Query Designer – Support for document ID


Note 2557307 - MT Query Designer: deletion of a query does not delete the entry in RSRREPDIR table





Note 2556121 - BEx Query Designer crashing displaying the folder structure in HANA CoProvider (HCPR)



Note 2586346 - Variable is not referenced to the query definition

Note 2588479 - BW Object not changeable also if changeability was set in RSA1

Note 2567717 - DataSource Replication with MT: DYNPRO_SEND_IN_BACKGROUND


























June 2018 36

3.1.1.2 Update the BW modeling tools to Version 1.19.x




1.19 Patch 00


1.19 Patch 01


1.19 Patch 02


Corrections and enhancements

• New editors and features

The new transformation editor, Document Store, Data Transfer Process and Planning Sequence will

be initially shipped with 1.19 and requires BW/4HANA 1.0 (SP8 or higher) on the server side.

It's now also possible to load flat files using the Data Source.

• Query Designer

It's now supported to switch between design time and runtime relevant texts. If you switch in the

preferences to the runtime relevant texts, the texts shown corresponds then to the texts which will be

shown during execution of the query. Please note it's required to apply the backend correction

2564954, otherwise the required text information is not available in the InfoProvider View.

• Query Designer - Data Preview

Starting with 1.19 it's possible to use a native data preview on BW/4HANA 1.0 (minimum SP4) which

is not web-based like the other data previews. For using this data preview it's recommended to apply

the backend correction 2562341 or to install SP8. The intention of the new data preview is to

show quickly the initial runtime state if a query will be executed. Navigation steps are not supported.

The Installation of the BW-MT is now simplified to four components now.











June 2018 37

Please Note that with the availability of the SP08 for BW/4 (aka FP01 for BW/4) you must update the BW-

MT to this Version.

With BW/4 SP08 and the current BW- MT 1.19, the Eclipse Development Environment should be almost “feature complete”.

The following SAP Notes are needed for the ABAP Backend together with BW-MT 1.19 are required:

Note 2621676 - Transformation in BW Modeling Tools

Note 2631472 - Korrekturen für Transformationen mit Routinen und Formeln

Note 2639435 - Transformations are opened in SAP GUI instead of in Eclipse

Note 2643781 - BW/4 1.0 SP9: Syntax errors during import of Transformations with formulas






June 2018 38

3.2 Tipp’s and Troubleshooting

3.2.1 Backend search RSOSM/RSOS_SEARCH After a fresh Installation of BW on HANA or BW/4HANA, the BW back-end search RSOSM or

RSOS_SEARCH does not return any result. This also applies for System copies as well.

The first step is to adjust the authorization settings for the users, otherwise the activation of the

MetaData and Where-Used Search will fail.

- Technical User (SAP<SID)

- Role User (≠ SAP<SID>

- Actual User (can be activated via “Assign General Privileges”)

See the following SAP Notes:

Note 2362807 - SAP HANA authorizations for BW metadata search/no results in search/input help for

BW modeling tools

Note 2396002 - Unable to open sub InfoAreas in BW eclipse Modelling tools perspective in HANA Studio

after BW support package update or upgrade

Note 2510781 - 740SP18: Queries in Metadata Repository not shown correctly

Note 2537784 - Supplement to SAP Note 2459861 - "BW objects are not displayed in the project explorer"

To make sure that the Metadata search works correctly you must enhance the authorization for the

technical user SAP<SID> (within the SYSTEM schema) and the _SYS_REPO user (within the SAP<SID>

schema.

Check the Metadata search after you recreated the search views with tx. RSOSM

And for SAP BW 7.50 on HANA

Note 2152359 - BW search/value help/search/open object in SAP BW modeling tools returns no result









June 2018 39

Switch to

Click on or , this will re/create the missing search view’s

Sometimes it is necessary after applying SAP Note corrections to regenerate certain of the SAP HANA

Views, e.g. InfoObjects or aDSO Views

Regenerate the search views for the t-logo object IOBJ. To do this, proceed as follows:

1. Open transaction RSOSM.

2. Choose "Configure TLOGO Object" and choose the value "IOBJ" as the t-logo object.

3. Choose the "Configure SAP HANA Views" button.

4. In the "Maintain Metadata View" section, choose the "Deploy" button.

+++++++


June 2018 40

3.2.2 Repair F4 help for BW-MT and AO

3.2.2.1 Report RSDDB_LOGINDEX_CREATE

Can be used for InfoObjects (IOBJ) and CompositeProvider (HCPR)

3.2.2.2 Report RSDG_ADSO_ACTIVATE

Can be used for advanced DataStore objects (ADSO)


June 2018 41

3.2.2.3 External HANA View for Hierarchy

Regenerate the help view HIEID_F4:

Regenerate Input Help HANA View for BW Hierarchies:

1. call transaction SE24

2. go to class CL_RS2HANA_VIEW_CALC_HIER_F4

3. execute method CREATE_VIEW with param i_regenerate_view set to true ('X')


June 2018 42

3.2.3 SICF Services need SSL connection Note 2427646 - MT: Service cannot be reached on BW reporting Preview

Note 2624606 - BWMT preview: This page can’t be displayed

Activate the Web Service FPM_BICS_OVP and WEBGUI with Transaction SICF

Make sure you switched from Standard to SSL in the SICF Service Details

Apply the following Parameters to the Instance Profile as well

icm/HTTPS/verify_client = 1

is/HTTP/show_detailed_errors = TRUE

Additional Tipp’s & Tricks can also be found here - http://scn.sap.com/docs/DOC-69522




www.sap.com/contactsap

https://blogs.sap.com/2016/10/11/soft

ware-application-lifecycle-management-

sap-bw/

http://www.sap.com/contactsap

sap first guidance - bw-mt and adso v1a248.g.akamai.net/n/248/420835/60396f1a4fa9b54dbc2... · this...

Documents