Loading data using Data Management with Complex Mapping

Hi All, we have a complex mapping requirement for a data load whereby we need to load the data into the correct product (Custom1 dimension) based on the parent (or in some cases ancestor) of the account to be loaded. I don't think this is possible using the current data management load mapping functionality in EPM unless we include additional columns in the load file to reflect the dimensional structure of the accounts. An option would be to load the data into "No Product" and then run a rule to move the value to the correct member in the product