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?
You can try DWH to CA PPM Database link to access CA PPM Tables, we have used this in some of our jasper reports, see if that works for you.
Regards,
Prashank Singh