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.
Retrieving data ...