Aug 4, 2016

Master Data is not Updated in Database (SAP BPC)

Problem:
When processing the Dimensions, it is not updating into the Database. But in front end it is showing the process has been completed successfully.
In backend, don’t get any Runtime Errors.
Version: BPC 753.02 NW and service pack version is 12.


Solution:
  1. Try to run UJA_MIGRATE_MBR_SEQ from se38 to migrate all your dimension to add the new attribute. Note for your reference 1569986 - How to add the MBR_SEQ attribute to a dimension - BPC
  2. Could you please perform refresh of your dimension list through UJA_REFRESH_DIM_CACHE
  3. Take a back-up of your dimension member list and go to UJFS and delete XML of the dimension member.

Then perform the following steps...
  1. Logon to SAP Netweaver backend BW system.
  2. Execute transaction UJFS.
  3. Go to Root > Webfolders > Application set > adminapp.
  4. Rename the <dimension name>.xml and <dimension name>.xlt files.
  5. Also, rename the above 2 files in dimcache folder.
  6. There will be a folder called PC_NW in your "My Documents" folder.
  7. Try to take a back up of PC_NW folder in different location and then delete it,
  8. then login to Admin through connection wizard and then try again.

***As a best practice, try to maintain the same service pack levels on Client
side, Server side and ABAP side (i.e., same service pack on all the
components)

If this did not solve try to uninstall BPC AdminClient and Microsoft Office and install MS office and then BPC AdminClient.