Error when saving data : Dimension is missing the code

Summary:

Planning error when saving data.

Symptoms:

When saving data back in the Planning Module, the user receives an error message along the lines of:

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 user also notices that the company he 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 the dimension codes you are trying to store are missing.

Resolution:

You need to check you settings to make sure everything is storing back properly.

1. Check your default connection to make sure that you are connected to the write database.
   
2. Check to make sure that the codes your are storing back do exist.
3. Check to make sure that leading zeros have not been dropped.

Properties:

Applies to:

• BI360 Planning 4.x