Slow Performance when Department tree columns are included

Content

We have built a simple report using ‘Goal Alignments Real Time’ subject area. The report runs in few seconds if we do not include Department tree columns. However, if we try to include Department Level 2, 3 and 4, the report takes almost 5 minutes to run. (Report xml attached)

Any pointers on how we can improve the performance?

Version

20A