Clarity

Expand all | Collapse all

Rate Matrix Data in JS Data Warehouse

  • 1.  Rate Matrix Data in JS Data Warehouse

    Posted 11-23-2016 02:13 PM

    Is anyone familiar with how to get the rate matrix data into the DWH for reporting?



  • 2.  Re: Rate Matrix Data in JS Data Warehouse

    Posted 12-02-2016 06:07 PM

    Hi Doug,

     

     

    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



  • 3.  Re: Rate Matrix Data in JS Data Warehouse

    Posted 12-05-2016 08:45 AM

    Unfortunately we need actual rates by resource, for the FACTS table wont quite work.  We may have to go that route though. 



  • 4.  Re: Rate Matrix Data in JS Data Warehouse

    Posted 05-10-2019 03:40 PM

    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.