Skip to Content
Technical Articles
Author's profile photo Roland Kramer

SAP BW Installation/Configuration on/for HANA

Last Changed: 9th of January 2023

For the detailed steps of the Installation/Migration, I have created the “SAP First Guidance Collection to answer questions, issues and shows workarounds, in addition to the standard guides and SAP Notes. These Guidance documents has no claim of completeness and it is the most complete starting point for a successful BW implementation.


The SAP BW(/4) Basis customizing tasks which can be found here:
Customizing SAP BW 7.x and BW/4

and in the online Help – Performing Wizard-Based Basic Configuration for BW ABAP
SAP NetWeaver Business Warehouse 7.4 – End to End Use Case Data Warehousing


Implement Digitally Signed SAP Notes

Blog – BI-JAVA, BEx Web and EP: the real connection …
Blog – demystifying TLS/SSL Settings for NetWeaver

SAP First Guidance – SAP First Guidance Collection for SAP BW(/4)

These SAP First Guidance Document put´s is emphasize to the complete functional scope (CFS) to ensure the full functionality right from the start of the Implementation of SAP BW 7.50 SP04 and higher. It is now possible to install also the ABAP CI of the BW system on the HANA appliance

It is possible to install the ABAP and BI-JAVA CI as well on the HANA Appliance!

Note 1953429 – SAP HANA and SAP NetWeaver AS ABAP on one Server
You have now also a new option to install the HANA client as described here
Note 1943235 – SAP HANA client installation

Blog – HANA 1.0 vs. 2.0
(contains Information about the combined usage of Mixed Scenarios together with SAP BW)

Important! – apply the manual steps of the Notes before applying BC 7.57 SP15 or higher!
Note 2450481 – Issue with column and characteristic sorting
Note 2458246 – WD Column Width Changed after upgrade


BlogSAP Note Analyzer – Revamp 2021
BlogPerformance killer SAP BW Open ODS view?
Blog – Delta Extraction and Real Time Streaming ODP-CDS to BW
Question – Create an ODP – SAP Source System – BW 7.4 on Hana SP09

WDEBU7 Workshop – Chapter 05 – Installation NetWeaver BI 7.0 JAVA
WDEBU7 Workshop – Chapter 06 – SAP NetWeaver 7.0 – Setting up BEx Web – Short
SAP Wiki –
Automated Initial Setup of ABAP-Based Systems
SAP Help – ABAP Post-Copy Automation Installation Guide
Content Notes – 
Note 1614266 – System Copy: Post-Copy Automation (PCA) / SAP Landscape Management (LaMa)
Note 1707321 – BW System Copy: Post Copy Automation (BW-PCA)

Note 3264789 – Manual Approval Task is finalizing task list without execution of further scoped tasks at the end
Note 3202353 – Task Manager for Technical Configuration TCI 3.0 (Including 12. Improvements)
Note 3155509 – System Copy: Task Content TCI 6.0 including TC15
Note 3209907 – Re-add import Batchjobs and other changes for TC15
Note 2819473 – System Copy: Task Content TCI 4.0 including TC13
Note 2738426 – Automated Configuration of new Support Backbone Communication
Note 2636449 – System Copy: Task Content TCI 3.0 including TC12
Note 2681701 – System Copy: Task Content (12.1 Improvements)


Note 2000003 – FAQ: SAP HANA
Note 2186744 – FAQ: SAP HANA Parameters
Note 2000000 – FAQ: SAP HANA Performance Optimization


Note 1918603 – ST02 – Swaps in various buffers
Note 2103827 – Profile parameters for table buffer as of SAP Kernel Release 7.40
Note 2468124 – Too many swaps on program buffer (ST02)


Note 2056106 – InfoObject 0IOBJNM not active after installation of NW 7.40 SR2 or BW 7.40 SP08
Note 2140419 – P14; BATCH: Max. 293 WPs, no BTC jobs started
Note 2173569 – Error when opening an RFC connection
Note 2046334 – Distribution of TMS configuration ends with an error
Note 2149920 – Error EA444 when Create Source System Connection
Note 2166107 – Piece list for objects ‘SHI3’ or ‘SHI6’ is incomplete
Note 2251716 – Database Triggers on tables in BW-on-HANA
Note 2146098 – RSAR671 or CALL_FUNCTION_NOT_REMOTE dump when Checking or Creating Source System in T-Code RSA1
Note 2150536 – BEx Web 7.x: New Java based User Interface for Broadcaster
Note 2509498 – Dumps or memory errors during data load
Note 2769672 – Changing delivery class of tables AT30 and AT31 from “S” to “E”
Note 2393255 – ODP-BW: Subscriber name is already in use / RODPS_REPL 524
Note 3220820 – Terminations during generation of privileges for generated view of characteristic

Note 2149786 – Customizing help settings in transaction SR13
Note 2567883 – SFW5: No documentation appears for info button
Note 2652009 – Connecting the help to the SAP Help Portal

 


 

Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics, SAP SE
@SAPFirstGuidance

 

“I have no special talent, I am only passionately curious.”

Assigned Tags

      22 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Nice document

      n

      Author's profile photo MadhuSudhan Rao Gongati
      MadhuSudhan Rao Gongati

      Hi,

      In the doc. 1.2.4 FQDN must be provided:

      <ip>     <hostname>     <fqdn>

      But according to the SAP Note 1496410, For RHEL I see the format as below:

      <ip>     <fqdn>     <hostname>

      192.168.0.1 sapserver1.example.com sapserver1

      Kindly advice.

      Thanks.

      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      Hi,

      I don't think this really matters, the key message is to have an entry to ensure the correct behaviour.

      I changed the oder of the entries in the document and added the Note for Red Hat.

      Thanks and Best Regards Roland

      Author's profile photo MadhuSudhan Rao Gongati
      MadhuSudhan Rao Gongati

      Hi,

      Welcome.

      It matters in suse for Hana,  because while resolving "hostname -f" is does not resolve to FQDN. It resolves to shortname.

      Thanks.

      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      This explains it, thank you for the Tipp.

      Author's profile photo VENU GOPAL BODDAPATI
      VENU GOPAL BODDAPATI

      HI Roland,

       

      Do you think, you can help me out with this one ?

       

      Right now we are on a SAP BI 7.02 SP10 System and we are upgrading and migrating to ​BW 7.5 on latest SPS, the new development system about to come in a week.

      Hence We need a post migration check list for BW activities, can someone please share that and it would be helpful.

      Thanks,
      Venu

       

      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      Hi,

      Check the Upgrade to 7.50 Presentation at the Blog -

      https://blogs.sap.com/2016/10/11/software-application-lifecycle-management-sap-bw/#bwupgrade

      Best Regards Roland

      Author's profile photo VENU GOPAL BODDAPATI
      VENU GOPAL BODDAPATI

       

      Hi Roland,

      Do you know, is there any separate process for converting BW Non Cumulative (Inventory) Info Cubes into HANA Optimized Info cubes? I know the Standard cubes conversion process, which is very straight forward.

      Thanks,

      Venu

       

       

      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      Hi,
      No, there is no special consideration.
      You should rather think about converting to Inventory based aDSO instead to be better for the future with BW/4

      Best Regards Roland

      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      However I found this Blog - https://blogs.sap.com/2016/08/20/converting-inventory-infocubes-with-uncompressed-requests-to-hana-optimized/

       

      Author's profile photo Adem Baykal
      Adem Baykal

      Great Document Roland 🙂

      Thanks and best regards

      Adem

      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      Thanks

      Author's profile photo Former Member
      Former Member

      Roland,

      Great work, thank you !!!

      Author's profile photo Jason Su
      Jason Su

      Hi Roland,

      we are trying to install the NW7.3 BW ON HANA.we got a error "

      FSL-03003  Unable to determine parameter "DNS domain name". DNS domain name is not configured in resolv.conf (UNIX) or the registry (Windows) and neither getaddrinfo nor gethostbyname could retrieve it

      "

      i guess we did not set 'Set FQDN for SAP system' checked cause this error.

      In the doc. 1.2.4 FQDN must be provided.

      do the bw server and hana server should have the same domian name ?

      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      Hi,

      not in particular, as long there is no latency or filewall in between

      Of course it is suitable that both server's in the same domain.

      Best Regards Roland

      Author's profile photo Former Member
      Former Member

      Do you have similar doc for BW7.31 installtion on HANA SP4? or is it almost same? Thanks

      Author's profile photo Sourabh Deo
      Sourabh Deo

      Nice document!

      Realy helpful!

      Regards,

      Sourabh deo

      Author's profile photo Former Member
      Former Member

      Very good Document.

      Thanks for your help.

      Author's profile photo Former Member
      Former Member

      Hi Roland,

      nice to see that you still work for SAP in this area (BW).

      very nice document! (as you already did 15 years ago -> spengler)

      I'm in the process of setting up a BW 7.5 SP2 on HANA

      Is there any specific document for the latest?

      (Initial setup after install)

      Can we use some task list (STC01) for basic configurations steps?

      Kind Regards,

      Pierre Vonesch

      Author's profile photo Kabeer Ahmed
      Kabeer Ahmed

      Hello All,

      I have installed the BW 7.5 on HANA and updated the SP to the latest available. Now I would like to run the configuration Wizard for ABAP stack. Can you please guide me how to do it?

      Regards,

      Kabeer Ahmed

      Author's profile photo Henning Schulz
      Henning Schulz

      Hi Roland,

       

      we plan to install a complete new BW 7.50. Actually we have a very old SAP BW installation running with SAP BW Integrated Planning for planning applications.

       

      Is it possible to install BW 7.50 with only the ABAP stack? We want to run BW with BEx Analyzer and BW Integrated Planning? Or is it necessary to install the JAVA BI stack additionally.

       

      Regards

      Henning

       

      Author's profile photo Roland Kramer
      Roland Kramer
      Blog Post Author

      Hello Henning

      Of course you can install SAP BW 7.50 without the BI-JAVA Instance

      Without BI-JAVA the BEx Web will not work, for BEx Analyzer it is not needed

      Best Regards Roland