Upgrade Bw3.5 to BI7.0

Former Member · ‎2009 Oct 10

Hi

We are about to upgrade bw3.5 to BI7.0,

can you please assit me on the this

1. What important things a should I know and do before start

2. what important things during upgration and after completion

how we should go about this being a BI consultant

any upgration doucment with steps ,

all useful ans will be highly appreciated.

thanks

Milli

Former Member · ‎2009 Nov 13

Hi,

Please follow bellow procedure steps:

A).Migrate Datasource:

To migrate an SAP BW 3.x DataSource (e.g., 0FI_GL_6) to SAP NetWeaver BI 7.0, you need to complete the following

steps:

1. Log on to the target SAP NetWeaver BI 7.0 system, and run transaction RSA1 (Data Warehousing Workbench).

2. In the SAP NetWeaver BI development system, select an SAP BW 3.x emulated DataSource.

3. Right-click the DataSource, and select the Migrate option from the context menu

4.If you choose the With Export button when you migrate an SAP BW 3.x DataSource, the system stores this DataSource in a local table on the target system with the technical name RSDEXPORT to enable a future recovery. Table RSDEXPORT

contains the SAP BW 3.x exported metadata, enabling you to recover the SAP BW 3.x DataSource if needed.

5.If you choose the W/O Export button, the system doesnu2019t save the metadata, so you canu2019t revert back to the SAP BW 3.x

DataSource.

B). Restoring Your Original DataSource

1.run transaction RSDS (DataSource Repository

2.Select Recovery 3.x DS from the DataSource drop-down menu,

3.Click the Yes button to recover the DataSource. You get a message indicating that the SAP BW 3.x DataSource was recovered.

C). Creating Transformations Between DataSources and InfoProviders:

1. Log on to your SAP NetWeaver BI 7.0 system and call transaction RSA1

2. Right-click the update rule and follow this menu path: Additional Functions > Create Transformation.

3. A dialog appears, as shown in Figure 14, that lets you choose whether you want to create a new InfoSource or

use an existing one. Select the Copy InfoSource 3.x to New InfoSource radio button, and click the execute icon.

4. Now, enter a technical name (the InfoSource field) and Long Description for the new InfoSource. Leave the rest of the fields (Application Component, Object Type, and Name) as they are.

5. A message prompts you with the progress of the copy process for the InfoSource and the update rules.

D). Creating Transformations at the Transfer Rule Level:

The final place in which you can create transformations is wherever transfer rules exist.

1. Log on to your SAP NetWeaver BI 7.0 system and run transaction RSA1. In the modeling functional area,select the transfer rule.

2. Right-click the transfer rule that you plan to migrate and follow the menu path: Additional Functions > Create Transformation.

3. A dialog prompts you to choose whether you want to create a new InfoSource or use an existing one, Select the Use Available InfoSource radio button, and click the execute icon. The system generates a log of the conversion.

4. Test the new data flow by creating a new DTP and loading some data.

Regards,

Suman