Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Already exists
Workspace Jedox Platform
Categories Jedox Web
Created by Guest
Created on Apr 9, 2020

Cube Load loads inconsistant data to the DrillThrough tables

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.

  • Guest
    Reply
    |
    Apr 30, 2020

    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?

  • Guest
    Reply
    |
    Apr 29, 2020

    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.

  • Guest
    Reply
    |
    Apr 28, 2020

    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?

  • Guest
    Reply
    |
    Apr 20, 2020

    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.