I'm attempting to perform a bill of materials explosion in QV using Hierarchy & HierarchyBelongsTo. My data looks something like this:
| Parent | Child | Type | Qty |
| A | B | Make | 2 |
| A | E | Buy | 1 |
| A | F | Buy | 1 |
| B | C | Make | 2 |
| C | D | Buy | 2 |
| D | G | Make | 1 |
| G | H | Buy | 1 |
My goal it to get a flat table depicting the total BOM structure for several hundred thousand parts (perhaps millions of parts). The resulting table would look something like this:
| Parent | Child | Type | Qty | Level |
| A | A | Make | 1 | 0 |
| A | B | Make | 2 | 1 |
| A | C | Make | 4 | 2 |
| A | D | Buy | 8 | 3 |
| A | E | Buy | 1 | 1 |
| A | F | Buy | 1 | 1 |
| B | B | Make | 1 | 0 |
| B | C | Make | 2 | 1 |
| B | D | Buy | 4 | 2 |
| D | D | Make | 1 | 0 |
| D | G | Make | 1 | 1 |
| D | H | Buy | 1 | 2 |
| G | G | Make | 1 | 0 |
| G | H | Buy | 1 | 1 |
Hierarchy seems to get me close, but, I'm missing top level parent ID and am not sure how to calculate the expanded quantities. Any ideas?
.png "Former Employee"){kind=icon}