Skip to Content
0
Former Member
Apr 08, 2014 at 06:56 AM

Appraisal templates Reports OR BI REPORTS?

38 Views

Dear Experts,


Few customized reports were created for appraisal templates, and they were working fine previously .

Reports were like for : First semi annual Rating, KPI, Goals etc etc .

Now there is heavy data in system, and reports are not working at all. Its taking too much time .

As Per little analysis , there are 2000 templates and loop is on HRHAP_T table , so its taking too much time( till now m not able to execute that).

And as the data will increase , timings will increase , so totally confused how to resolve it .


Is there any other table in appraisals which we can use to retreive appraisal id, name and personal number of employee ?


OR

Is there any Standard BI reports which we can use instead of them, if not is it possible to create Customized BI reports for Appraisal documents ??


Please advise.


Regards,

Pran