Migrate from SAP BPC7.5 to SAP BPC10

[Former Member]

Hello Experts, In this document I am trying to explains you following points according to the migration of an Appset “Sales_Plan” I have done:

1. What part of Appset you can migrate from SAP BPC7.5 to SAP BPC10
2. How you can perform migration
3. Issues during migration

1. What part of Appset you can migrate from SAP BPC7.5 to SAP BPC10

1. All Administration settings are migrated
2. All data and comments are migrated
3. All content is migrated except :

• Live Reports
• Custom Web Pages in Content Library
• Published Books
• Insight Settings
• Highly customized EVDRE Reports
• Use of Internal API will break    

2. How you can perform migration

2.1 System Configuration

• SAP BPC 7.5 Version with SAP NW 7.1 Version
• SAP BPC 10 Version with SAP NW 7.3 with SP02 or Higher

2.2 Procedure

1. Login to SAP NW System for BPC7.5, then Execute UJBR transaction code to take Backup of the Appset.

           

Enter details according to your requirement.                              

Note: If want to migrate with Master data then, please take care of the Spaces, Blanks and Dots of the  Dimension_ID’s in SAP BPC version 7.5 for Net Weaver. If your master data contains spaces or dots then your migration will not be successful .

2. Log in to SAP NW System for SAP BPC Version 10 and execute a Transaction Code UJBR to restore the Application Set .

Enter details according to your requirement.

3.After restoring of the Environment, go to se38 transaction code and execute a program UJT_MIGRATE_75_TO_10 . This program is needed to migrate content of SAP BPC7.5 for NW to BPC10 for NW.

Enter SE38 transaction code then click on execute.

Enter Program name “UJT_MIGRATE_75_TO_10”then click on Execute or Press f8.

Check all Check box and click on execute.

Note: User mapping file should be created as follows in order to map the Users in BPC Version 7.5 for NW to SAP BPC Version 10 for NW, User Mapping file should be saved as a .CSV format

In that way you can perform migration of Admin settings of BPC 7.5 to BPC10.

3. Issues during migration

    Many issues you can face during migration or after completion of migration. Some of them are as follows:

3.1 Unable to delete Environment

When you are trying to do migration but it is not successful and you want  to delete that  Environment from BPC 10, but it is showing error message like: “Unable to delete because dimension category not found “ or due to some other reason.

  Resolution:

• Go to SAP BW with credential
• Go to RSA1
• Delete Environment from Info Object
• Delete Environment from Info Provider
• Type se38 transaction code
• Execute UJS_ACTIVATE_CONTENT Program
• Select Environment which you want to delete
• Check only “Clear” Environment check box.
• Uncheck all other option.
• Execute it.

In that way you can delete environment from back end without any error.

3.2 Unable to Connect with Excel Add-in

If in migrated environment, any model contain secure dimension then it will not available in Model list, when you will try to connect with Excel Add-in.

Resolution:

1. In BPC 10, if a dimension is secured you need to go to the

Admin tab> Security folder> Data Access Profiles tab.

2. Click on a Model listed, Then you will see Access to Model: [Model name] on the right.

When you secured the dimension, it automatically gave no access to it so there wasn't a security breach. You need to set the dimension you locked so that users can have read/write/R&W access.

3. Go to the Team, Select team to whom you want to assign that Data Access Profile

Like here, we click on Team Admin

4. Click on Data Access Profile

Add whatever data access profile you want to assign to that Team.

Like here, we are assigning Admin access profile to admin team.

After doing this, admin user can access this model in Excel Add-in Model list

Regards

Sonam Gupta