I have data hub model that is comprised of flat lists and modules that build the hierarchy like in L2MB training. I have Module A dimensioned by 4 flat lists (all with hierarchy module builds) including PR3 Product Name. Previously when I had hierarchal lists, I could have a line item in Module B that references a specific list member's data from Module A with formula:
'D01 Slot Forecast'.Slots[Select: 'PR1 Product Lines'.Other]
But with using flat lists, I can't figure out how to get this functionality. I have Module C that maps PR3 to Parent PR2 Product Family and PR1 Product line. I want to have the functionality of Select but with flat lists.
Module A and B are dimensioned the same, Module C is just dimensioned by PR3 Product Name with Line items PR2 and PR1 that have the hierarchal mapping.
