BPC10.1 - Failed to Edit Members

[Former Member]

Hi guys -

I used the Edit Structure to removed some of the Cost Center properties - successfully saved. Afterwards, when I tried to used the Edit Members to access the Cost Center looks like the link doesn't respond anymore.

But the Developer have no issue to access the Cost Center and, able to see the changes done by me. Apparently I am the only one have being blocked to Edit Members for all the dimensions. Also, Security team have confirmed that there's no recent changes had accurred with my access either in BW and BPC.

I am not sure what is causing me to edit the members of any dimensions. I will be grateful if you all can share a solution to fix my problem.

Thanks,

Hardip

[Former Member · Accepted solution]

Hi guys -

The problem is solved by the Developer seem they said it due to some unwanted data in the backend table that caused members editing failure. Please find the solution below share by the Developer:

Solution

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.

Thanks,

Hardip

[damovand · Accepted solution]

Hello,

Thank you for sharing the solution, very useful information.  It is also worth mentioning that the solution is documented in SAP note 2068917. Although the note maybe difficult to find because the symptoms are so varied. Thank you again

Best Regards,

Leila

[damovand]

Hello,

You can also refresh the master data on your client machine.  If you see the problem when working in EPM Add-in you can use Refresh Metadata Cache or you can just find PC_NW folder on your client machine and rename it.  That way everything will be loaded from the server again.

Regards,

Leila

[Former Member]

Hi Hardip,

Try refresh meta data from EPM.

goto BPC backend and run program UJA_REFRESH_DIM_CACHE from SE38.

Andy

[Former Member]

Hey Andy,

Thanks for the solution. I will consult with the Developer team if they are okay to run the program.

Thanks,

Hardip