Is anyone familiar with how to get the rate matrix data into the DWH for reporting?
do you need the actual rates as in PPA_MATRIX table? If so, this data does not get to Data Warehouse for now. If you need this, please go ahead and raise an Idea here in the Communities.
If you need actuals with costs (based on rates) on a specific resource, those are in Data Warehouse in the FACTS tables.
Hope this helps -Nika
Unfortunately we need actual rates by resource, for the FACTS table wont quite work. We may have to go that route though.
DK_Winmill - did you ever get a suitable response on this question?
We here at Emerson would like to understand how to get Clarity PPM Rate Matrix cost information into the Data Warehouse. We are specifically seeking the following attributes: From/To Date, Location, Role, Actual Cost. We have 100+ locations globally configured in our Rate Matrix so we need currency as well.