Highlighted
Absent Member.. Absent Member..
Absent Member..
195 views

Capacity of Resourcepools

Hello Community,

 

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:

 

total_fte___rollup_fte_RPool_name_start_date______end_date________long_name


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?

 

Regards,

Ramazan 

 

0 Likes
3 Replies
Highlighted
Contributor.
Contributor.

Hi Ramazan,

 

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.

-Mike

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
0 Likes
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Ramazan...you have to divide total_fte by 100 to get the real FTE value.

 

So 186 really is 1.86 FTE

0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

Hello Erik,

 

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?

 

Regards,

Ramazan

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.