SAP BW Master data SID issues

[former_member188080]

In one of our project we face issue in workbook execution and it thrown error of SID master data value is missing.

We got following error.

we have multiple suggestions on SCN.

We tried with following options

1. We tried to go to SE14 for master data and tried activating the master data.

2. We went to RSRV and run check for Infoobject and we corrected the master data SID issues.

Post this also issue persisted.

Such issue could occur if master data entries or table got deleted somehow.

We again did where used list and found that it is available in multiple DSOs and cubes.

we deleted one DSO data and Cube. Issue still persisted.

so we saw Infocube dimension table SIDs and Infoobject SID table values were not matching.

so finally we decided to run RSRV for Infocube dimension tables where the above Infoobject is present. we got same error.

so we decided to delete the data from Infocube that particular dimension table where the Infoobject is present.

we deleted the data via SE14 as shown below.

So once dimension data is deleted  just for the one dimension where the issue Infoobject is available.

Pl note - do not delete any data base table. Just delete data as shown above.

After this just deelete the Infocube data and reload it.

After this we could run our workbook.

I hope this will help resolving your issue.