cancel
Showing results for 
Search instead for 
Did you mean: 

2 to 1: Possibilities to move a SEM-BCS into a BW ?

Former Member
0 Kudos

Hi,


What's best for  2 to 1 solution ... or what are obstacles against it ?


I have got 2 physical separate systems:

1 BW and 1 SEM-BCS


I want to have 1 physical and logical system with:
BW AND SEM-BCS (on HANA)


What possibilities exist  ?

( persumeing the releases are adequatley maintained)


Export / Import of BW into (same database user of ) SEM-BCS ?

->Metadata and objects foe SEM BCS and BW are completly disjunct ?

->Feasible ?


Transport of BW Objects into SEM-BCS (on HANA)?

-> How to solve if objects are symanitcall the same (0COMP_CODE) and syntactically diffrent ( Char 10 ./. Char 20) ?

-> Lot of work ...? how to do quicker than manually ?


Use a MDC-, MCOS-, MCOD-, Multitenancy- concept ?

->Two users, Transparance for reporting via union or other views , SAP BW 7.4 hybride objects

->http://scn.sap.com/docs/DOC-59771


Others ?


ThanXs  !


Martin

Accepted Solutions (1)

Accepted Solutions (1)

Thomas_G
Advisor
Advisor
0 Kudos

Hi Martin,

we did it this way:

1. Migrate SEM-BCS to HANA

2. Import objects from BW into new BCS@HANA (this is a little bit challenging because of name spaces) - you have to use new name spaces for old BW to be sure that all BCS data are untouched

3. Impport and convert transactional data into new BW objects

4. Migrate and convert BW queries into new BW objects

At SAP we have a special group for such activities, not sure is you (or your customer) have similiar opportunities.

best regards

Thomas

Former Member
0 Kudos

Hello Thomas,

sounds not to bad to get Your group into the boat.


Please let me understand Your suggestion more:

Your term "name space" is according to  "Using a Namespace for the Development of BW Objects - Customer and Partner Content - SAP Library"

"2.... new name spaces for old BW to..."

The basic suggestion is consider the old BW to be an customer content in the new BW

and to set up a new namespace for all the old BW objects, for ex.

InfoCube SALES, Facttable /BIC/FSALES ->

InfoCube SALES, Facttable /XYZ/FSALES ?

In consequence any ABAP codeing must be changed manually ?

"2. Import objects..:" 

from BW refers to the /RSA1/Transport Connection/XML Export / XML Import/  and manually changeing in the XML File the namespace / Table Prefix
or

refers to the SAP migration Ex-/Import

or

to what ?

What happens to the metadata  in the RDS tables - How is it kept consistent
- with the XML Import ?

"3. Import and convert transactional.."

refers to the SAP migration Ex-/Import and changeing in the Export / Import the table prefix  ?

It means to exclude Metadata table from the SAP Migration Ex-/Import ?

"4. Migrate and convert BW queries into new BW objects",

Tool / Assistant based ?

ThanXs a lot

Best

Martin

Thomas_G
Advisor
Advisor
0 Kudos

Hi Martin,

please send me a mail, we should discuss this on the phone.

But this week I'm in a customer workshop so let's have a call next week.

regards

Thomas

Answers (0)