Capacity of Resourcepools
I need a query which calculates me the capacity of a resourcepool. I found a table "krsc_rsc_pool_period_sum" but it shows me the FTE's , e.g. the query
SELECT rp.total_fte, rp.rollup_fte, resp.resource_pool_name, per.start_date, per.end_date, per.long_name
FROM krsc_rsc_pool_period_sum RP, ppm_fiscal_periods_nls PER, rsc_resource_pools RESP
WHERE rp.period_id = PER.fiscal_period_id
AND resp.resource_pool_id = rp.resource_pool_id
AND RP.resource_pool_id = 30180
AND substr(per.start_date,7,2) = '13';
gives me the result:
286_______ 0_______ ITSS_______ 01.03.13_______ 31.03.13_______ March 2013
190_______ 0_______ ITSS_______ 01.04.13_______ 30.04.13_______ April 2013
168_______ 0_______ ITSS_______ 01.05.13_______ 31.05.13_______ May 2013
185_______ 0_______ ITSS_______ 01.06.13_______ 30.06.13_______ June 2013
174_______ 0_______ ITSS_______ 01.07.13_______ 31.07.13_______ July 2013
171_______ 0_______ ITSS_______ 01.08.13_______ 31.08.13_______ August 2013
186_______ 0_______ ITSS_______ 01.09.13_______ 30.09.13_______ September 2013
191_______ 0_______ ITSS_______ 01.10.13_______ 31.10.13_______ October 2013
195_______ 0_______ ITSS_______ 01.11.13_______ 30.11.13_______ November 2013
178_______ 0_______ ITSS_______ 01.12.13_______ 31.12.13_______ December 2013
But when I look into the resourcepool I get the following numbers (in persondays) -> see attached screenshot.
The issue is, that in the resourcepool ITSS two persons with each ~18 working days are available. why do I get so curious numbers in the row total_fte?
I am not familiar with custom backend queries, though if there is a front end Page in PPM that displays the numbers you are looking for, then I would know how to get the sql PPM uses.
See the "Enabling Debugging On a Per-User Basis" directions in the 9.14 Release Notes or the 9.2 Installation and Administration Guide. By using this section, console will be enabled in the Dashboard that will show the exact sql PPM uses to get the data on a page.
Hopefully this can help you get the query you need.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
this is a good hint and how can I calculate the person days? e.g. I have a resource pool where only 5 persons are there.
for May 2013 I get as total FTE 421(?) divide by 100 = 4,21 FTE
but there are 5 persons where each of them has 19 working days = 80 PD (4,21 * 19 = 80) in May 2013.
Now: How can I get the working days? In kdrv_working_days I can calculate the working days per month but cannot join the table with krsc_rsc_pool_period_sum?