Resource availability weekly calculation in DWH

[Jeevana Battu]

Hi,

I want to calculate resource availability weekly from datawarehouse tables, for PowerBI report.

I found 2 tables (DWH_X_RES_AVAIL_PER_FACTS , DWH_RES_PERIOD_FACTS) having 'avail_hours' column in it, but not sure how to get the weekly availability of a resource.  

could you please help me with the calculation and the tables related to get weekly resource availability.

Thank you in advance!!

Thanks,
Jeevana.

[Liz Williamson]

In DWH you can use the view called
DWH_RES_PER_FACTS_W_V.  You can join this to DWH_CMN_PERIOD table to get the weekly dates.

There are also Monthly (%M_V) and Fiscal (%F_V) views.

Liz Williamson