Paul-TM1 wrote: ↑
Mon Feb 25, 2019 7:47 pm
In 10.2.2, when ever I delete a chunk of elements from the "Approval hierarchy" dimension and apply manage Rights, it takes 4-5 hours to complete the process in multi threaded configuration.
Normal manage rights with 4 threads takes about an hour. What happens in this 4-5 hours is a mystery. Can someone please explain the long process? What is different?
In my experience, the longest part is usually the }tp_rights_update_RDCLS_static_rights process that does a really huge loop over the groups / approval nodes / control dimension intersections and copies the rule calculated rights value to a 'static' slice. Because it does it for every cube in your application and you maybe have a lot of groups / approval elements / elements in control dimension -- it will take ages to scan through it.
The parallel processing 'chunks' this process into parts, but doesn't really change the overall approach.
You can decrease the search space by pruning unnecessary groups / control elements.
You can also get hacky and optimise this process to look at only the applicable group / control dimension element subset for applications to reduce the time quite a bit. For example, looping through only the applicable 100 groups for an application instead of a 1000 in total would speed up the execution by a factor of 10
But this is a bit of an exercise in coding and you'd be changing the 'out of the box' process.