Business Content Activation Errors - Transformations

[william_grdovich]

When I try to activate data flow before business content activation for my cubes and DSOs why do I always get errors on the "activation of objects with type transformation"?

Is this due to the fact that the business content does not contain 7.0 data sources? And therfore just the update rules/infosources get activated?

Also what steps are required to get the 7.0 transformation concept loaded from BC? would it simply be to convert the data source to the new data source format and then do the data flow before business content installation?

Regards

Bill

[Former Member]

Hi,

In BI7 we don't have standard Transformation(BC) so we have to install transfer rules and update rules then try to migrate 3.x to 7.0 data source after that you can create transformation manually,

Always better to install BC with grouping only necessary object coz when you select grouping after r before it will search whether you have authorization to activate ds in source system r not then if you don't have authorization you may get errors.

Regards,

satya

[Former Member]

Hi

Try installing without Transformation in the Data Flow / Or try to include them while grouping separately with Transformations on left side panel.

All Transformations, with required Rule details may not be installed without errors.

Hope it helps

[Former Member]

Hi,

You can migrate the transfer rules and update rules into transformation based on the 3.x datasource.

In this scenario, the steps to migrate the datasource, update rules, infosource and Transfer rules.

The steps are as follows:

a.) Install 3.x datasource, transfer rules, update rules and 3.x infosource from BI content.

b) Go to infosource tab and right click on transfer rules and go to additional functions and create a transformation.

This transformation replaces the transfer rule and becomes a link between infosurce and datasource (still in 3.x). When it asks for a infosource, we say to use the existing one so that it gets copied to 7.

Check for routines and formulas. If there is a return table for any mapping, write it in the end routine.

c.) Similarly right click on update rules and go to additional functions and create a transformation which forms a link between data target and the infosource ( the new infosource which is created when create transformation from transfer rules). Some manual adjustments are needed for routines for which you can refer sapnote as mentioned below.

d.) Create infopackage and load data to PSA. Check data in PSA. Once the data load till PSA is consistent, Create a DTP and load data into data target.

e.) If the data load to data target is done successfully then use T-CODE RSDS

f.) Now you can migrate the 3.x data source to 7.

Put the source name and the data souce name and from context menu click on MIgrate data source with export option.

Refer sapnote_0001052648 for migration

I hope this helps.

Thanks,

Kartik