Creating hierarchies in SQL (Oracle HFM & Essbase models)

At first (in ACCOUNT table), from those Table columns, remove the FACT, _FACT_NEW etc. columns to avoid the confusion in the future steps. (Don't remove ACCOUNT_PARENT(ID) column)

You can expand the Table column (I think in your case it'll be ACCOUNT_PARENT(ID) column).

You may need to expand the expanded column again since you have a middle table.

And then, in each row you'll be seeing a parent and one of its children. (There will probably be a lot of rows now).

Expand the inner(expanded, the one belongs to the child) Fact table, with only choosing dData column.

Now, in each row you should be seeing a parent ID, a child ID and the child's dData value (like your last screenshot)

And then, Group by the parent account ID (right click on the column name, "Group By"), choose "All Rows" operation.