I was trying to get the OBS mapping for Resource_department_key and Investment_Department_key from DWH_FIN_TRANSACTION table. But instead of OBS_UNIT_ID Resource department key and Investment Department key is mapped with ID from the DEPARTMENT table from CA PPM database. Since the ID is not in the warehouse I am not able to map the department's parent OBS. Because of this issue I am not able to aggregate actuals at resource department level. Is there any other way to get department ID in the warehouse?