Tuesday, May 30, 2017

Possibilities of DataSource replication

Replication of DataSources is quite painful in BW systems. It usually takes time and there is high effort that needs to be put into it. Normally it is done in tcode RSA1 -> Modeling -> Source Systems -> right click on particular systems and choose Replicate DataSources. This brings up below dialog box where parameters for replication can be set up.

By starting this up it activates all DataSource available in respective source system. SAP delivered improvement to this functionality via below SAP Note that supports replication of specific DataSouce within a source system or an application component.
Despite there are some drawbacks like it replicates all DataSources in 7.x fashion it speeds up whole replication process.

In order to be used this enhancement you need to setup a parameter called REPL_DATASOURCE_UI_740 = X in table RSADMIN. Feature is available as of BW 7.3 SP11 and BW 7.4 SP05.

More information:
1885443 - Replication of Datasources
Export DataSource creation and replication

Thursday, May 25, 2017

Hierarchy activation syntax error

Recently I faced an error with regards to activate hierarchy related datasource. While trying to do that there was an error:

Syntax error in GP_ERR_RSAPTH3, row 30 (-> long text)

Issue is within data inconsistency for specific hierarchy in table ROOHIECAT. Luckily there are SAP Notes that can solve this issue. After implementing ABAP report ZROOHIECAT_REPAIR and running it for particular hierarchy issue is solved.

To get the ABAP report look for following SAP Notes:

484370 - Syntax error during activation of BW730 HIER data sources
2113639 - Activation of Hierarchy DataSource - GP_ERR_RSAPTH3