Tag Archives: modeling

Modify an existing SAP BW Source System connection

Technique for switching ECC source systems in SAP BW Environment without affecting the
data modeling objects in the BW environment. By data modeling objects, we mean transformations, update rules and transfer rules getting inactive or getting deleted. Once the source system is switched, data reload needs to happen to have the initializations and deltas to come from the new source system. Also we have to ensure that the data from old source system( both transactional and master ) needs to be deleted in the BW system before reloading from the data from new source system to ensure consistency in the data from new system.

The following  SCN Article describes the procedure

Step by Step on Changing ECC Source Systems without Affecting Data Modeling Objects in SAP BW

 

See also 110849 – “Error during insert in port table” (create source system) if the error occurs during the RSA1 / Source System / Restore step

RSCOMPCONS and Check Consistency Flag on Multiprovider

MPRO_COnsistencyFlag1

In BW 3.5 the identification of characteristics and navigation attributes in MultiProviders did not need to be consistent. This means that for compounded characteristics, the assignments for each underlying infoprovider must be consistent with regards of compounded characteristics and compunding objects.(See  Note 920416 – Checking compounding consistency in MultiProviders for details)

During activation this caused only a warning message up to BW 3.5.

As of BW 7.x this warning was changed to an error. This can cause problems to migrated Infoproviders.

Several notes were released to solve this. At some point the possibility to convert the error to a warning on the level of the individual Multiprovider has been added.

Yo can find the optional setting when editing/displaying the Multiprovider in RSA1, via the Extras menu entry.

MPRO_COnsistencyFlag2

 

Here is a list of notes to check in relation to this problem.

See also the following article in SDN.

Consistency Issues in MultiProviders – BI 7.0

Keywords:
BRAIN A152
R7I 135
RSCOMPCONS

SPO – Semantically Partitionned Objects

 

Blogs on the subject

http://scn.sap.com/people/alexander.hermann/blog/2010/10/11/bw-730-semantically-partitioned-objects

http://scn.sap.com/people/juergen.haupt/blog/2010/12/07/sap-netweaver-bw-730-semantically-partitioned-objects-spos-built-from-badi-consistent-rule-based-modeling-of-logical-partitions

http://scn.sap.com/docs/DOC-19451

http://scn.sap.com/community/data-warehousing/blog/2013/06/20/doing-a-transformation-look-up-on-a-spo