Unbalanced Hierarchy broken?

Wolfgang Dödlinger
Wolfgang Dödlinger Customer
Name Dropper First Comment
in Platform

Good Morning :)

I have an entity which is an unbalanced hierarchy. The entity seems fine. Here are the settings:

image.png

I also have a SQL Data Reader which loads the Entity and the Relationship which also seems fine:

image.png

The Data Reader runs just fine. No error logs, no cancellation. However, the relationships are not built.

I have already checked the hierarchy in our DWH and it seems to be fine.

Does anybody have an Idea what the problem could be?

Thank you :)

KR

Wolfgang

Answers

  • Fabian Thoma
    Fabian Thoma Employee
    Fourth Anniversary 10 Comments 25 Up Votes Level 300: Expanding Board in Your Organization

    Hi Wolfgang,

    as also written in the other post.

    Is it a new created entity? If yes, did you Unload/Reload the Database before running the DataReader?

    Maybe that allready helps.

    Best regards,

    Fabian

  • Wolfgang Dödlinger
    Wolfgang Dödlinger Customer
    Name Dropper First Comment

    Hello Fabian,

    thank you for your responste. I have cleared the Entity and reloaded again. This yields the same results:

    • The Entity is loaded with the correct elements
    • The Relationship is not build

    So the problem unfortunately still exists.

    Thank you

    KR

    Wolfgang

  • Philipp Schumacher
    Philipp Schumacher Employee
    Fourth Anniversary 25 Likes 5 Answers 10 Comments
    edited August 2023

    Hi Wolfgang, you can try to do the following.

    First a regular datareader, where you load ALL elements flat into the entity and then a second data reader to create the relationships (as shown in your picture)

    Breaking it down into two DRs seems to work more reliable for me.

    Kind regards Philipp

  • Fabian Thoma
    Fabian Thoma Employee
    Fourth Anniversary 10 Comments 25 Up Votes Level 300: Expanding Board in Your Organization
    edited August 2023

    Hi Wolfgang,

    you need two DataReader for the unbalanced hierarchies:

    1. One for creating Master Data
    2. and another one for the Relationships

    Did you set it up like that?

    You can also find useful information regarding the Unbalanced hierarchies in the Board Manual:
    https://www.boardmanual.com/2021/summer/data-modeling/2_Database_design_functions/1_Entities/Unbalanced_hierarchies.htm?rhsearch=unbalanced

    For your point check out the section: "Creating the parent-child relationship" in the above mentioned link.

    I hope this helps.

    Best Regards,

    Fabian

  • Bart Scott
    Bart Scott Active Partner, Community Captain
    Fourth Anniversary 5 Answers 10 Comments 5 Likes

    You have confirmed all your ProductParent_bkey are also included within the file as DimProduce_bkeys? Every member of the entity (including all parents) have to be loaded within the Code and Desc part first, then load the relationship's second.

    Bart Scott

    CFO Solutions LLC

Categories