Hi BI Gurus,
Our requirement is to load PS and internal orders data in one Cube and do reporting on plan, actual,and commitments costs. We are using a copy of Cube 0PS_C04.
We are using 0CO_OM_NWA_1 extractor for PS which brings, plan, actual and commitments. This also brings, Project definition, WBS Element and Network and we can represent it in a hierarchy in the report.
Now we want to bring Internal orders. We tried 0CO_OM_OPA_3 extractor for plan data. We included Network header in external order to relate with PS data. We also included Project definition, WBS element and enhanced the extractor to populate these fields. We are using views COAS, and CAUFV.
In RSA3 we saw the correct values being extracted but while pulling it into BW, WBS Element and Project Definition values got converted in PSA as well as Cube.
Values coming to Infocubes are from fields PSPNR and PSPHI from PRPS table and PSPNR from PROJ. Looks like I am not using the right extractor or right fields.
Can you share your experience with this kind of problem. Any suggestion is appreciated.