I am required to give the full path of the department. This used to not be a problem in CA PPM (using the nbi_dim_obs table). But that is not available in the DWH. Any idea how to get the FULL path of the department? Or any OBS?
OK, found the solution myself.
In the DWH you can use the table : DWH_INV_OBS_MAPPING to get the path of an OBS