Summary:
This article troubleshoots an error that occurs when saving back data in the Planning module for 4x.
Symptoms:
When saving data back in the Planning module, the user receives the following error message:
The Company dimension is missing the code .
Please ensure the code exists in the Company table and resave the data.
Missing Code(s) : Company : Solver INSERT statement conflicted with the FOREIGN KEY constraint "FK_GL_Entity". The conflict occurred in database "BI360DW", table "dbo.d_Entity", column 'MemberId'.
The company the user is trying to save back to does not match.
The company under the Admin Panel and Assignments tab are different and will not change even when trying to change the default connection.
Cause:
This is caused by trying to save where the dimension codes are missing.
Resolution:
Check the settings to make sure everything is storing back properly.
- Check your default connection to make sure that you are connected to the right database.
- Ensure the codes you are storing back to exist.
- Ensure that any leading zeros have not been dropped.
Properties:
BI360 Planning 4.x