This content has been marked as final. Show 2 replies
my requirement is that the hierarchy is multi-leveland joined on all of the six live accounting segments.
Level 1 - 101.10222.8554.0444.000.00000 (accounting segments) joins to; AAAAA - My analysis code level 1
Level 2 - AAAAA (parent) joins to BBBBB - My analysis code level 2
Note it is the total combination of all the segments which is the requirement, so just because the first segment is 101, this does not mean that all entries with first segment 101 will be this parent, only when in combination with the rest of the segments exactly as above (so one code combination id effectively)