Thanks for your respone. Was waiting for some input very eagerly .
Wel i m stuck with a very challenging scenario.
Scenario:-
In short user want to perform some kind of "what - if" analysis.
Details:-
I have developed a report for HR, customized report. Calculation is complex and we are using end routine to achieve the same.
This report values will change for every business. Example below is for ITS business and in that business there are 5734 employees. So in case of RND the number of employee might reduce or increase and then on total employee population logic will be applied to get ideal and actual numbers.
Report contains the following fields:-
Performance Category ideal% Ideal Num Actual% Actual Num Variance
Low 3 172 2.9 167 -5
Mid 45 2580 45 2581 1
Good 32 1835 31.3 1796 39
High 15 860 15.7 903 43
Stellar 5 287 5 287 0
Overall Result 100 5734 99.9 5734 --
Now here in the above report ideal % is fixed and based on this we are calculating ideal num and accordingly actual num and actual %.
But user now wants to play around with Ideal %. Accroding to them this ideal % might change depeding upon how people in different business(ITS or RND) performs.
They want to change the ideal % for every business and see how the report looks like.
How can i achive this? My calcuations are happeing in end rouinte. Can i use input variable values in end routine?
But if I have understood your requirement correctly, you can have the ideal % entered by the user in the selection screen and calculate the other KPIs at the query level.
Our calcuation for calculating ideal % ideal Num Actual % Actual Num is quite complex. With lot of internal tables in end routine we are able to find the numbers.
I dont think that much feasibility is there in Bex.
These are my assumptions, may be ur written end routine , i do not know eactly ur requirment.
1) take the count of all employes who are active by employee stsus by using exception aggrigation of 0employee, here you are getting total number of employess.
2) This RND, ITS these are departments or organization , you can create the variable seletcion screen for thata characterstic.
3) for idela number take that 1 CKF and restrict with your idela(may be performance characterstic) , now you can get the total of Ideal employess as per your performance catgory.
4) then use 3 CKF for getting the Ideal % as shown 3ckf5%Asumgt3CKF
5)like that for actual also you can do the same.
6) when ever he selcts the data in varaible screen as per that it will be changed.
7) but one thing is true input varaible screen will not read the end routine.
I am confused with 3rd and 4th point. It will be great if you can explain those points once again in liltle bit of details.
You have almost got the requirement.
Just to inform these peformance category are not fixed. I mean there is no number range defining the peformance category.
As when people gets their rating from their manager it will keep changing.
For example:-
If in 1st review employee A gets 2 out 5 then he might fall in low category but after 2nd review is done and same employee A gets 4 then he will now come in good category.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.