Please follow the below steps to create a local program at backend in order to clean up the dirty data.
Step 1. Open t-code SE80 and select 'Local Objects' in tab 'Repository Browser'.
Step 2. Use mouse to rigth click on the root folder and select 'Create' then 'Program', input an program name such as 'ZCLEAN_DIRTY_DATA', leave the check box of 'Create with TOP Include' unchecked, then click ok.
Step 3. Copy the following line into the program delete from rsbpc_web_up where user_id = '{USER_ID}' and category = '{CATEGORY}'.
Step 4. Replace the place holder {USER_ID} with the user name that met the column missing issue, for instance, USERA.
Step 5. Find the correct value for the place holder {CATEGORY} following below steps 5.1 - 5.4.
Step 5.1 Open t-code SE16 in a new session and open table RSBPC_WEB_UP.
Step 5.2 Set USER_ID with the user that met the column missing issue, for instance, USERA. Set NAME with the value colSeq. The value for NAME is case-sensitive. Then excute or press F8.
Step 5.3 In the column 'CATEGORY', find the correct value for {CATEGORY}. The format of CATEGORY value should be 'members_{ENVIRONMENT_NAME}_{DIMENSION_NAME}'. For instance, if the missing column issue happens in the dimension 'ENTITY' of the environment 'ENVIRONMENT_TEST', the value of CATEGORY should be 'members_ENVIRONMENT_TEST_ENTITY'. If you find this value in the column 'CATEGORY', please double click on it to open it. Please note that if there is no such value for the dimension that has the error, this note may not work.
Step 5.4 Copy the value of CATEGORY, for instance, 'members_ENVIRONMENT_TEST_ENTITY', and replace the place holder '{CATEGORY}' in the local program. After doing it, the program should be like following:
delete from rsbpc_web_up where user_id = 'USERA' and category = 'members_ENVIRONMENT_TEST_ENTITY'.
Step 6. Activate the program and excute, then re-log on web client to verify if the missing column appears again.
After implementing the above steps you are able to edit the members of the Dimension which are previously locked.
Note:- If the above steps are not able to resolve the issue please go through the SAP Note: -2216722 .
And also check with the BPC & BW support packages as per the SAP Note.
Regards,
Aravind
