Associate set data for custom field

Use case is that roles are associated to particular locations, divisions and business units. We want to be able to add the role and Location and the system can associate the category, division and business unit. We want these additional fields to enable reporting/filtering by these. We have tried using the estimates and adding these as custom fields within the teams but based on our combinations we would end up with hundreds of teams.