Best Of

Hi

You can use context selectors .

otherwise

if you have system module then You should create a Boolean line item.And write a formula (Source Selection module Entity = system modle line-item entity same for Dept. Apply this in the target moduel)

Or

In the targe module crete two list formated as Entity and Dept Applies to also same dimesion to reduce cell count) and You should create a Boolean line item.And write a formula (Source Selection module Entity = Target module lineitem entity same for Dept. Apply this in the target moduel)

Hope its helps

Set up a module in the spoke that is dimensioned by your target list and that has a boolean you can use to delete from. We can set that to true before importing from the hub, and we import in a setting of false from the changed list on the hub. This means anything left set to true doesn't exist on the hub, so we can use this boolean to run a delete.

Create a process in the spoke that will…

- Set that boolean to true
- Import your list
- import into your 'delete' module from a saved view in the hub with a boolean set to false
- run a delete action

@PauloM

You can have the 3 lists as they are and use them elsewhere, but you can absolutely have a hierarchical/composite list where you have:

Countries
Customers
Products

And, I imagine this could be true in that you sell a lot of the same products to different customers, have the hierarchy stop at Customers (Countries and Customers are the hierarchy) and then have products by itself.