cancel
Showing results for 
Search instead for 
Did you mean: 

Transformation and DTP for upgraded 3.5 objects in BI 7.0

Former Member
0 Kudos

Dear Experts,

When I do a upgrade from bw 3.5 to BI 7.0, How do I create transformation and DTP for the upgraded objects. Do I need to create new transformation and DTP for these objects?.

Thanks,

Varun

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

If you wish to adopt the new data flow of Bi 7.0, you have to convert the old update rules to transformations manually.

Ravi Thothadri

Answers (4)

Answers (4)

Former Member
0 Kudos

If only needed nw2004s data flow(DTP,Transformation..) then migration required else you can stay with old 3.x dataflow.

Follow below links patiently it has wealth of information embedded.

For nw2004s data flow

Pre-requisite - 3.x datasource to be replicated as 7.0

and migrate datasource with "export datasource option" so that you can later revert back to OLD if needed.

nw2004s Concepts

new NW2004s Data flow

R/3---->PSA only (using Infopackage) for all the Loads -Mandatory

PSA -


>ODS/Cube -->load using DTP ,create transformation first

no Datamart architecture in NW2004s

so ODS -


>Cube load using DTP ,creating transformation first

Once loaded to PSA in DTP you have the option of FULL or DELTA ,full loads all the data from PSA and DELTA loads only the last load of PSA.

Go through the links for Lucid explainations

Infopackage -

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/03808225cf5167e10000000a1553f6/content.htm

DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm

Creating DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fa50e40f501a77e10000000a422035/content.htm

Pre-requisite-

You have used transformations to define the data flow between the source and target object.

Creating transformations-

http://help.sap.com/saphelp_nw2004s/helpdata/en/f8/7913426e48db2ce10000000a1550b0/content.htm

ODS to Cube -

http://help.sap.com/saphelp_nw2004s/helpdata/en/ce/dc87c1d711f846b34e0e42ede5ebb7/content.htm

Migrating update rules/transfer rules routines to Transformations - Trick

On the InfoSource Tab (Note- Ensure DataSource and Infosource have not been migrated)

1. Right Click > Additional Functions > Create Transfer Rules

2. Activate Transfer Rules

3. Right Click > Additional Functions > Transformation erzeugen

On the DataSource Tab

4. Create Transformation (Map to DSO, should map automatically)

5. Migrate DataSource

6. Create InfoPackage

7. Create DTP

Hope it Helps

Chetan

@CP..

former_member186358
Active Contributor
0 Kudos

Hi Varun,

You will get the entire information in the link below:

https://websmp104.sap-ag.de/upgradeNW70

Assign points if this is helpful.

Regards,

Anil

Former Member
0 Kudos

Hi Varun,

If you just upgraded from 3.5 to BI 7.0 and still using the 3.5 objects then you don't need to create any DTP or transformation but if you migrated the 3.5 objects to BI 7.0 then you need the DTP and transformation objects.

Hope this helps,

bye...