In OBIEE 11G if we look at Session logs, we will see a new status called ‘DXE Execution’ with amount of time its been executed. I did some research on this to answer my burning questions ‘ What this new alien will do? and How it is helpful for Performance tuning?.
Then I founded interesting news about this and actually the DXE Execution means “Data Transformation Engine which handles post-processing of the BIServer results within OBIPS”.
The post-processing can involve resorting, filtering, aggregating, and/or indexing the original BIServer result set so that the data can be consumed by a view’s renderer. And It can be automatically kicked off when the BIServer query finishes.
So if the DXE Execution is running long time, Then it’s time to open your arms to tune your report UI/Presentation Server.
Of course if the sql query is taking long time, We know how to tune DB(A)’s :).