When data is loaded to a cube and its DrillThrough table using the Cube Load in an Integrator project, the records that aren't loaded to cube caused by warning are loaded only to its DrillThrough table.
To keep the consistency, data in the cube and its DrillThrough table should be always same.
Following my previous comments, is there a possibility of this idea will be adopted as a new feature? If not so, all we can do is choose your workaround, right?
You are correct - it does not finish with "Completed with Warnings" but when using createUnderDefault you do get messages for every single newly created element in the log, which makes the process transparent. You need to look for these Info messages. You could add another Integrator Job for post-processing, which fetches all new elements and does whatever he wants with them e.g. generate some Warnings.
Please contact Support / Knowledge Base if you require further information.
If that option is set, the job status does not finish running as a "Completed with Warning".
We would like to realize and consistency of Cube and DrillThrough tables along with "Completed with Warning" status.
Is this Already exists?
This Behaviour is documented: https://knowledgebase.jedox.com/knowledgebase/load-cube-drillthrough/ If a dimension element is not found, by default a warning is raised and the cube data won’t be loaded, although the drillthrough data will be persisted. To avoid this, the option “Handling of missing elements” could be set to “createUnderDefault” or “createUnderDefaultParent”. If it's another warning please let us know which one.