Migration of ECC BI Content to BW 2004s

[former_member205400]

I extracted Asset Mgt Data from the ECC to BW and now I am finding out that the extraction to BW resulted in version 3.5 objects.

I looked at the Datasources and right-clicking them had them "migrated", however then is not an option on the transformations.

So I'm working with this Asset Mget Cube: 0FIAA_C12,

tell me if this is correct:

a) Cubes and DSO's and other higher forms of data storeage object will not need to be maintenanced,

b) Transformations will have to be manually changed

c) Any queries have to be manually changed,

Is there a std op procedure or best practice to follow for re-doing the transformations?

[Former Member · Accepted solution]

<b>a) Cubes and DSO's and other higher forms of data storeage object will not need to be maintenanced,</b>

Didnt follow this question

<b>b) Transformations will have to be manually changed</b>

YES

<b>c) Any queries have to be manually changed,</b>

3.x queries can be opened in nw2004s but in order to add new functionalities has to stay in nw2004s.

Queries once edited in nw2004s cannot be opened back in 3.x they had to be restored.

OSS Note 962530 - How to Restrict access to the new 2004s Query Designer

OSS Note 949330 - Backup and Restore of queries

BI FAQ at: https://websmp101.sap-ag.de/~sapidb/011000358700006960162005E#7

<b>Is there a std op procedure or best practice to follow for re-doing the transformations?</b>

No std procedure ;however some tricks below

Hope it Helps

Chetan

@CP..

[Former Member · Accepted solution]

Front end migration strategy -

Here's the migration strategy:

Hope it Helps

Chetan

@CP..

[former_member205400]

Very good answers to this question I had.

At the link below I had another question particularly about Asset Mgt Data. I described the process I used.

<a href="https://www.sdn.sap.com/irj/sdn/thread?threadID=374293&tstart=0">https://www.sdn.sap.com/irj/sdn/thread?threadID=374293&tstart=0</a>

[Former Member]

Michael,

Just to add to the thread, that's a good strategy you've invoked, i.e start off with a 3.x emulated flow and then migrate.

Cheers,

Pom

[Former Member]

Thanks for the update.

Hope it Helps

Chetan

@CP..

[Former Member]

just to add to what chetan has already outlined:

Cubes and DSO's and other higher forms of data storeage object will not need to be maintenanced,

No, there would be no further maintenance needed during or after migration. the structures remain intact, only the flow is gonna change.

Any queries have to be manually changed,

No need to change any queries with the dataflow migration. If you want to migrate even the queries to 7.0, than again unfortunately it has to be manually. No mass migration tool available yet.