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

SAP BW? – three things to know …

Last changed 4th of June, 2020

eim301.PNG


First:

You can upgrade in ONE STEP from SAP BW 7.0x to SAP BW 7.40 and higher (e.g. 7.50) including the SEM and other Add-On´s. SAP BW 7.50 requires a unicode based source system.

If you are upgrading from SAP BW 3.5, the highest Version in on Step you can go is SAP BW 7.31 with SEM 7.36.This is you last Stop, where the BEx 3.x and BEx Web 3.x Objects are supported.

Good News – Easier Modeling of the SEM Add-On in Solution Manager

Information for the Upgrade to SAP BW 7.50 and further:


Second:

What should everyone consider moving BW to HANA either on Premise or moving to the HANA enterprise cloud (HEC)


Third:

SAP BW/4HANA is available and brings significant new possibilities with it, despite the usage of HANA.
Ask our Customer´s, they recognize the (Business) Value it brings.


 

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

 

 

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

Assigned tags

      19 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Beat Honegger
      Beat Honegger

      Hello Roland

      Thanks for the Input.

      What about a Midmarket SAP customer which doen´t have BW today.

      Should he start with DWH on Sybase or Hana or stil starting with BW?

      Thanks for input

      Beat

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

      Hello Beat,

      Every Customer should start with a BW (on HANA), which answers the Question of the underlying database platform.

      As our Reference Customers in the german region D-A-CH are midsize customers, I rather think these type of Customers are less afraid what BW on HANA brings for them.

      Choosing BW on SAP Sybase ASE is a wise decission from the (SAP) Vendor perspective, as ASE is part of the SAP Family.

      Furthermore the usage od SAP-NLS for BW based on SAP Sybase IQ can be directly enabled on ASE, as they share the same LibDBSL.

      Best Regards Roland Kramer

      PM BW/In-Memory

      Author's profile photo Former Member
      Former Member

      Hi Roland,

      I believe that, above web link are very useful for SAP BW/HANA people. I will share this web link in our community and it will be very useful for SAP BW consultant for update more in this. Thank you so muuch for consolidating information. All the best.

      Regards,

      Hari Suseelan

      Author's profile photo abilash n
      abilash n

      Thanks Roland for nice blog...

      Author's profile photo Marian Canciu
      Marian Canciu

      Hi Roland

      With NW 7.4 SP6 on HANA it's not possible to change the queries using the Query Designer. Is this a new "feature"?

      Cheers

      Marian

      Author's profile photo Former Member
      Former Member

      Hi Marian,

               Where did you see this fetaure " it's not possible to change the queries using the Query Designer"

      User will be able to edit the query in QD in 7.40 SP6 on HANA.Can you be more presice on your question.

      Thanks & Regards

        A.Dinesh

      Author's profile photo Marian Canciu
      Marian Canciu

      Hi Dinesh

      When trying to change a query in QD in 7.4 SP6 on HANA we are getting an error message:

      - error when creating catalog entry for R3TR ELEM ...

      I've searched for SAP Notes and KB but couldn't find a solution.

      What I find peculiar is that it's actually possible to change the query and save it with a different name (and not using the original query name).

      Does this ring a bell?

      Cheers

      Marian

      Author's profile photo Former Member
      Former Member

      Hi Marian,

            Yes definetly it rings a bell 🙂 ........

      I have few questions to you

      1) Is it 3.x  or 7.x queries ?

      2) Are you getting this issue for the all the queries or only for specific queries?

      meanwhile I will also check out is there any correction for simlar issue

      Thanks & Regards

        A.Dinesh

      Author's profile photo Marian Canciu
      Marian Canciu

      Hi Dinesh

      1. 7.x Queries

      2. All queries are impacted; it's a general issue

      If a correction is available please do let me know.

      Thank you

      Marian

      Author's profile photo Former Member
      Former Member

      Hi Marian,

               I have never faced this issue and also when I checked in SAP notes I couldnt find any

      solution. Looks like this issue is something specific at your landscape,Can you please raise a ticket to SAP.

      Thanks & Regards

         A.Dinesh

      Author's profile photo Former Member
      Former Member

      You need to have a Open BEx transport request to make query changes. Try out with an open TR.

      Author's profile photo Marian Canciu
      Marian Canciu

      It was a kernel bug and SAP helped and it's solved.

      Author's profile photo Krish K
      Krish K

      Hi,

      The second link

      Three things to know when migrating NetWeaver BW on HANA

      is not working !! 🙁 it is deleted ??

      Regards,

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

      Hi,

      The Links are working again.
      There was a Name Change from SAP NetWeaver BW to SAP BW which was not incoperated in the individual Blogs.

      Sorry for any inconvinience and Best Regards Roland

      Author's profile photo Daniel Ray
      Daniel Ray

      Hi,

      I have a doubt on the delta jobs after migration. When we say BW is migrated to HANA. Does that mean the source system for example ECC will still have the old DB like oracle or DB2. Only the data extracted from the source system ECC will be moved to HANA DB where BW is on the application server , is that a right statement ?

      If we complete our BW migration to HANA DB successfully, then still the delta jobs , update queue, extraction queue are all running on the same old ECC DB ( oracle ) . is it right ? then the currently running delta in production will not get effected after the HANA DB migration ? Please advise.

      Thanks for reading.

      DR

      Author's profile photo Harish Allachervu
      Harish Allachervu

      Hi Ray,

      Hey first you should know ECC & BW are 2 different systems which have there own underlying DBs(it may be Oracle or HANA).

      when comes to your first query yes you're understanding is right with HANA as underlying DB for BW nothing will change like extraction and loading will remain as usual only thing is data load performance will get improves.

      2nd question there is no impact on delta queues(extraction, update) at ECC side they will work normal.

      Thanks & Regards,

      Harish

      Author's profile photo Former Member
      Former Member

      Hello Roland,

      Just to clarify your First point- a SAP BW upgrade is technically feasible from SAP BW7.0 to SAP BW 7.4 version without going from BW7.0 to BW7.3 first, then to BW 7.4?

      Customer can upgrade straight from SAP BW7.0 SP22 to SAP BW7.4 version SP...?

      I appreciate your reply.

      -Altin Ceka

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

      Hi,

      Please have a look to the comments in the following SCN Document - Update to SAP BW 7.50

      The Main influence for a straight Upgrade from 7.x to 7.50 is the unicode availability in teh source system.

      Best Regards Roland

      Author's profile photo Former Member
      Former Member

      Hi Roland,

      Could you please provide the pre-processing, migration, post-processing tasks with the recent updated tools developed by SAP. it is highly appreciated if you provide in steps in detail.

      Thanks

      Navakanth