The MRC Business Unit Dilemma

Yesterday, I had a discussion with someone from the travel department that wanted to get aggregate data for different segments of the entire corporation. The way we have the information is at too low of level and needs to "rolled up" to match up with the breakouts that they used in previous reporting, specifically for hotel spend locally and globally. The problem is there is no consistent way that these smaller companies are grouped. Nobody seems to possess a document that sums it all up neat and clean. You would think a multi-billion dollar a year company would have the resources to handle something this critical. Alas, another time that there are mixed signals and poor communication between departments. It is certainly something that needs to be resolved on our end... this will be critical for the upcoming transation of the domestic reporting tool into the globalized version of the system.