Dso Activation Failure

[#1]

Hi Mates,

I am facing one failure though even it is quite simple & may be many threads available in this forum

but still i need your suggestion in fixing my issue please excuse me in this regard.

here is my issue:

Their is data flow like in our BW system source-system(not ECC)--- > BW(PSA)----- > DSO -----> Cube(reporting layer)

data staging in BW happening through process chain once DTP loads from PSA to DSO during DSO activation we are facing below failure.

and I've attached the screenshot of the same please go through it, as per message it is showing sid is not generated for those materails due to this activation step is getting failure but when i checked in the 0MATERIAL master data SID are generated for those materials.

One thing i would like to stress here is recently our system has upgraded from 7.0 to 7.31 so due to upgradation their is some inconsistency has happened in the master data, even i did RSRV for 0MATERIAL i found many materials have inconsistent.

so to fix the issue I've 2 options to delete inconsistent 0MATERIAL data from BW and reload again to BW as it is tedious & quite risky one i am not opting for this, so I've chosen other option i.e. to change the DSO settings like "Sid generation upon activation" i am planning to deactivate this mode so that their is no SID are created and activation will goes fine as DSO is just staging layer hence it will not cause any issue anyhow from DSO again data is pulling to cube as per start schema architecture sid's will be created in the cube level..!!!

Can you please suggest can i make this settings in the DSO level and please tell me it will not impact on query performance.!!!!

Thanks & Regards,

Harish

[Former Member]

This message was moderated.