Technical Articles

Roland Kramer

November 13, 2013 1 minute read

Three things to know when migrating to SAP BW on HANA

to ensure a smooth migration of the existing SAP BW System from Release 7.0 (including SEM, BPC and IP) and onwards the following three topics must be considered.

shrink the data which will be moved to the row store of the SAP HANA database with the SAP BW housekeeping task lists
shrink the data which will be moved to the column store of the SAP HANA database with the SAP-NLS Solution
use the database migration option (DMO) as part of the SUM tool for the in-place migration including upgrade/migration/unicode* steps, see the Blog from the DMO Product Management.
please note that all nZx technologies available for SUM natively only, so they are not available with the DMO option for SAP BW due to the difference between an Upgrade and a Migration.

The on Premise use case – minimized production downtime with the combination BW-PCA and DMO

The HEC use case – moving BW on Premise to the HANA enterprise cloud with the combination BW-PCA and DMO

further Information can also bve found in the following Documents (each of them is an own blog itself)

SAP First Guidance Collection – BW on HANA

Also the new SEM Add-On modeling on top of the NetWeaver BW System allows a much quicker creation of the needed stack.xml for the DMO procedure.

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

ℹ See the Article in the German DSAG Magazine Blaupause – http://blaupause.dsag.de/sites/default/files/Database%20Migration%20Option.pdf

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

20 Comments

You must be Logged on to comment or reply to a post.

Daniel Rothmund

January 22, 2014 at 2:37 pm

Hi ,

we use the dmo tool to upgrade our bw (7.31) to bw(7.40 SPS5) HANA.
Now we have some trouble with transaction : RSMIGRHANADB

we receive the same error for different cubes .
column store error: [2575] flatten scenario failed;keyfigure not found in dest fact table: KEY_DMPPFC019

What can be the problem ?

Regards

Roland Kramer

Blog Post Author

January 22, 2014 at 2:47 pm

Hi,

Did you applied the SAP Note crrections after SP05?

See the Document - https://scn.sap.com/docs/DOC-41588 => Chapter 2.4

Please be aware that the program RSDU_TABLE_CONSISTENCY cannot be corrected via SAP Note corrections in SP05. You have to wait for the next SP.

For the overall DMO procedure see - http://scn.sap.com/docs/DOC-46824

Best Regards Roland

Daniel Rothmund

January 22, 2014 at 3:15 pm

thx with help of note 1957634 solved.

Daniel Rothmund

January 23, 2014 at 2:46 pm

Hi Roland ,

after implementation of all the notes from the excel sheet "SAP Notes for BW on HANA 7.40". I have now an error in CL_SHDBPARTSPEC rv_num is a Integer and the <lv_arg> is a String ....

I doesn't found any new note for this problem for 7.40 SPS5

Roland Kramer

Blog Post Author

January 23, 2014 at 3:56 pm

Hi,

As already started in the Document - https://scn.sap.com/docs/DOC-41588 you cannot apply the SAP Notes related to the program RDSU_TABLE_CONSISTENCY like Notes 1953984, 1892492, 1888511 on NetWeaver 7.40 SP05.

The affected class is CL_SHDB_PARTSPEC.

I recommend to Reset the affected SAP Notes Implementation.

❗ UPDATE:

In the Meantime (since 28th of January) it should be possible now to apply Notes 1888511 and 1953493.

Best Regards Roland

Former Member

May 13, 2014 at 9:16 am

Hi Roland,

why the housekeeping task lists are useful only for row store and SAP-NLS only for column store?

SAP-NLS involve "less accessed" data, I don't understand why, if I migrate to Hana, this "less accessed" data are only in column store.

Thank you in advance

Regards,

Walter

Former Member

May 23, 2014 at 8:24 am

Hi All ,

Can you please let me know the steps for migrating Process chains , BW queries and System copy for BW on HANA .

Roland Kramer

Blog Post Author

June 3, 2014 at 10:14 pm

Hi,

nothing to do for Process Chains and Queries.

database migration option is explained here - SAP First Guidance - Migration BW on HANA using the DMO option in SUM

for ABAP coding you can use the Migration cockpit -

Note 1909597 - SAP NetWeaver BW Migration Cockpit for SAP HANA

Best Regards Roland

Former Member

June 13, 2014 at 6:25 pm

Hi Roland:

In your SAP Presentation "Migration to SAP NetWeaver Business Warehouse on SAP HANA – Best Practice Update 2014" I saw that DMO can be used to:

1) Upgrade BW

2) Migrate BW from Any Database to HANA

3) Move BW on Premise to HANA Enterprise Cloud

in a single step (slide 14 of the file).

For this option the process is move the CI from the On premise data center to the cloud and then run DMO from that instance.

We are interested on that option but I have not been able to see more information on it.

Do you know where I can get more information on this option?, Do you have any comments/suggestions on it?

Thanks

Luis Carranza

Roland Kramer

Blog Post Author

December 3, 2014 at 12:03 pm

Hi,

Simply do it. it is a manual task

Best Regards Roland

Former Member

December 15, 2014 at 8:14 pm

Hi Luis,

Have you got any information on this ? we are also looking for the same option "moving BW on Premise to the HANA Enterprise Cloud"

Can you advise what's the approach you have implemented and how we've handled the delta queues using BW PCA?

Thanks.

Regards,

Sakthi.

Former Member

November 9, 2015 at 7:19 am

Hello Roland,

I had a quick view into your NLS document, but it just looks like a technical installation guide?!

Currently, I'm looking for a solution of query performance issue when selecting really "big data" from NLS and using navigational attributes...

I don't know if you've seen my recent post?

http://scn.sap.com/thread/3821998

I'm quite frustrated about the note and I'm really in doubt if NLS is a good concept, at all?

Of course, if the plans are only to shrinkt the DB size, then it matches the requirements, but if you plan to use it for reporting... then I only can say "forget about it" 🙁

(It's clear that it can't compete with BIA, but in my case the report is literally dead!)

Any feedback appreciated (especially in my posting).

Thanks for reading,

Martin

Roland Kramer

Blog Post Author

November 9, 2015 at 4:30 pm

Hi,

See the Comments in your Post - Re: Multi-Temperature Data Management = a bad joke for BW!. Feel free to come back to me with further questions.

Best Regards Roland

PM BW/In-Memory and SAP-NLS

Former Member

November 10, 2015 at 7:10 am

Hello Roland,

thanks a lot for answering my posting and the honest words!

I'll check all the links and will come back there...

Kind regards,

Martin

Former Member

January 30, 2016 at 3:18 am

Hi Roland,

I do Understand the use of PCA and so far have use DMO of SUM for SoH migrations but yet to perform a BW on HANA migration with DMO

Is it "mandatory" to use PCA when using DMO of SUM for BW on HANA migrations ?

The whole point is to save cost on LVM license of course with added risk/effort.

Please Advice.

Regards,

Jayesh

Roland Kramer

Blog Post Author

February 24, 2016 at 4:16 pm

Hi,

for the DMO usage, the BW-PCA functionality is not needed at all.

Best Regards Roland

Former Member

February 24, 2016 at 4:22 pm

Thanks Roland. That was my understanding as well.

Just got a little confused after reading the below comment in HA200 training material -

• For SAP NetWeaver BW, DMO can be applied when PCA (Post Copy

Automation) is used.

Thanks for the confirmation and this amazing blog.

Regards,

Jayesh

Ashok Babu Kumili

August 10, 2016 at 12:52 pm

Very useful info and well documented. Very easy to understand. Tons of thanks

Kuldeep Jain

January 25, 2018 at 10:33 am

It a quite old but seems still valid. One of the hit list before start migration project.

Roland Kramer

Blog Post Author

January 25, 2018 at 11:35 am

Thanks for letting me know. The Information is "timeless" ...

best regards Roland

Technical Articles

Three things to know when migrating to SAP BW on HANA