Cube load modes- (Insert, Add, Delete, Update, Create)
In my numerous Jedox projects career, I was constantly getting questions related to cube load modes. Although is very well explained in the knowledge base, users frequently asked for clarification. When is a great moment for the update, where for add, and where for delete + insert combination?
It is important to start with the type of load modes for the cube:
Add - Values from the data source are aggregated and added to the existing values in the cube.
Insert - Existing values in the cube are overwritten with the values from the data source.
Create - The existing cube is deleted and created anew with the dimension order as defined in the source.
Delete- Values from the data source are deleted in the cube.
Update - The existing cube is emptied; values from the data source are aggregated and written to the cube.
How it practically looks is something which is in the best way explained in the below EXCEL screenshot:
Based on this image you...