At one of my projects most of the end-users are still used to the old 3.x Bex Analyzer. Whereas the 3.x version works primarily with workbooks the new 7.x analyzer one is able to open queries as well. When a query is opened in the new 7.x Analyzer a standard template is being used to display the data. This template, supplied by SAP, contains alot of custom visual basic code to make interaction in the report possible (like showing a graph). This custom Visual Basic code raises a lot of performance issues, especially when users are working on a Citrix environment.
To gain performance I decided to create a new workbook template by using the Design Mode of the 7.x analyzer. By creating a whole new workbook without any Visual Basic and graph generation the performance improved by 35%. In order to set this new template as global template for all other users I created a short program which edits entries in the table rswbtemplate.
This program has three parameters: ‘Workbook ID’ (technical id of the template ), ‘SAP User’ and ‘All users’. If parameter ‘SAP User’ is left blank and the parameter ‘All users’ is set to a X then the new template will be set for all users. Once executed with a filled in user only that user will get the new template.