Unbalanced Hierarchy broken?

Wolfgang Dödlinger · 2023-08-03T06:56:35+00:00

There was an error rendering this rich post.

Wolfgang Dödlinger

Good Morning :)

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

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

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 :)

Wolfgang

Find more posts tagged with

Accepted answers

All comments

Fabian Thoma

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

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

Wolfgang

Philipp Schumacher

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

Hi Wolfgang,

you need two DataReader for the unbalanced hierarchies:

One for creating Master Data
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

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