Lookup between list formatted line item value in one module and list property in another module
This is around a Top-Down allocation functionality being built for Demand adjustment. Based on the available capacity & resources the demand needs to be adjusted but instead of adjusting at the lowest level (Devices) the idea is to adjustment at another higher level(Packages) and the % adjustment flown down to the devices. Please note that the devices and packages are not part of a single hierarchy but the Package name is defined as a property of the Device list.
Now due to space constraints of having all the dimensions in a single module, I have created a numbered list based module to capture the demand adjustments by Package. The user needs to create new entry and select the package & other relavant device attributes (list formatted line items) which needs to be looked up in another module at device level and reporting back the current Demand volumes. The user can then input in the adjusted demand volumes and the %adjustment needs to be applied back to the Devices based on some pre defined priorities.
Issue: The 2 modules are not built with common dimensions and the levels of selection (Package & Device) are not part of the model hierarchy. Is there a way to pick up the user selected device attributes (Package, site etc) in the adjustment module and look up on the Device list properties in another module and report the current aggregated demand numbers? The answer to this lookup issue should also solve the % adjustment at package level flowing back to the devices and adjusting the demand volumes.
It's quite a complex lookup, so I have attached a document outlining all of the steps
The best way is to have a calculation module to cross Devices by the Adjustments and match the criteria there.
It would be possible to create a combined "attribute" list but that would get quite complex to set up and would required actions to update thus losing flexibility, so I have not documented that approach