The processing job for the Data Loss Prevention cubes is taking over 12+ hours to complete.
The processing of the Custom Attributes for the different Data Loss Prevention incidents is handled via SQL functions. This results in the results having to be manipulated in the TempDB's memory then transferred. This results in an additional overhead of 20%+.
The following steps capture the "SELECT..." portion of the function content and puts it directly into the view being called, rather than calling the function separately. This will have the same effect of the function call, without the SQL overhead. If the cube is being processed manually from SQL, you will be able to see row growth progress and know that the cube is processing.
Please perform a full backup of the IT Analytics Database before proceeding.