How to speed up the display of Domain list when creating an Ad Hoc View

Requirement:
How to speed up the display of Domain list when creating an Ad Hoc View. Currently, the Domain list is slow to show up when creating a new Ad Hoc View.

Solution:
There is a server configuration (XML) to Ad Hoc settings which can be configured to help in improving the display performance of the Domain list when creating a new Ad Hoc View.

This configuration is present in the applicationContext-pro-settings.xml file (<jasperserver-pro>/WEB-INF/) under the adhocSettings map id,

<util:map id="adhocSettings">
<entry key="commonTypes">
<util:list>
<value>topic</value>
<value>domainTopic</value>
<value>semanticLayerDataSource</value>
</util:list>
</entry>
<entry key="olapTypes">
<util:list>
<value>mondrianConnection</value>
<value>secureMondrianConnection</value>
<value>xmlaConnection</value>
</util:list>
</entry>
</util:map>

When creating a new Ad Hoc View, JasperReports Server looks for ALL of the above resource types (commonTypes and olapTypes) when displaying the 'Choose Data' window.

With the above configuration the idea is to allow users to modify the configuration so that the unnecessary types can be removed. In order to improve performance, the applicationContext-pro-settings.xml configuration can be changed to remove unnecessary commonTypes and olapTypes but you need to know what types you are using. For example, many clients do not use Topics, and would benefit from removing Topics from the Ad Hoc start page scope, because it could be a performance bottleneck for big repositories.

After making the required configuration changes under the adhocSettings map id of the applicationContext-pro-settings.xml file, please save the file and restart the application server for the changes to reflect.
_____________________________________________________________________________________________________________________________________________________________
Ref. Case #02129473