What can be done to decrease the ad hoc report run time?

[Former Member]

We are processing a weekly ad hoc report in background to show the unmitigated users within our production systems.  Currently the report for our HCM production system runs for at least 3 days.  We have about 116,000 users in the HCM system.  We are running GRC AC 10.0 SP16.  Our Basis resource performed a trace on the job and saw that the background process performs a full scan on the GRACMITUSER table and suggested that an index be placed on this table and that the query be updated to work with an index.  Is this a normal resolution? 

Any insight you can give into this issue is appreciated.

Thanks --

Sara B.

[alessandr0]

Dear Sara,

first of all google the SAP notes for "performance" as there are several notes in this regard. Second, not sure which program you run in background. Do you talk about the batch risk analysis?

You can define parallel processing so that the analyis runs in more background jobs: SPRO > GRC > AC > Distribute Jobs for Parallel Processing. Define the number of tasks for the application type GRAC_SOD.

This should drastically decrease the runtime. I have a client who has 40'000 users and the risk analysis could be reduced from 39 hours to 1 hour.

Hope this helps.

Regards,

Alessandro

[Former Member]

Hi Alessandro,

I have researched all the material you mentioned.  The change to the GRC parallel processing did the trick in our QA environment.  Wide open User Level Risk Analysis against 138,00 users went from "runs forever" to just over 1 hour.

Thanks --

Sara