AnsweredAssumed Answered

Issue in DWH_FIN_TRANSACTION

Question asked by srijp on Dec 12, 2017
Latest reply on Dec 13, 2017 by srijp

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?

Outcomes