Technical Articles
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:
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
Blog – SAP Note Analyzer – Revamp 2021
Blog – Performance killer SAP BW Open ODS view?
Blog – Delta Extraction and Real Time Streaming ODP-CDS to BW
Question –
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.”
Nice document
n
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.
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
Hi,
Welcome.
It matters in suse for Hana, because while resolving "hostname -f" is does not resolve to FQDN. It resolves to shortname.
Thanks.
This explains it, thank you for the Tipp.
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
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
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
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
However I found this Blog - https://blogs.sap.com/2016/08/20/converting-inventory-infocubes-with-uncompressed-requests-to-hana-optimized/
Great Document Roland 🙂
Thanks and best regards
Adem
Thanks
Roland,
Great work, thank you !!!
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 ?
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
Do you have similar doc for BW7.31 installtion on HANA SP4? or is it almost same? Thanks
Nice document!
Realy helpful!
Regards,
Sourabh deo
Very good Document.
Thanks for your help.
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
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
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
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