BIP Report getting timed out and cancelled while extracting the AOR report
Summary
Hi, We have an report where we are verifying if there are any multiple assignment of same HRBP's (HR Representatives) to the same department / scope.Content
Hi, We have a report where we are verifying if there are any multiple assignments of the same HRBP's (HR Representatives) to the same department/scope. There have 16 HR roles and close to 8-10 data roles for each HR role. Recently we have added one more scope role "Department + Location" to the list. But when we run the report it is getting timed out / Cancelled.
We have tried changing the SQL joins to see if there is any possibility to execute the report without any issues but still we are facing the same issue again