OBIEE 11g - Change Default Behavior when editing a report

With the move from OBIEE 10 to OBIEE 11, the default behavior when editing a report changed. While earlier you would automatically be taken to the criteria view, with OBIEE 11 you are taken by default to the results view. This is can be a problem for 2 reasons:

1. It adds an additional step to edit the report (most of the time you are editing the report to change the criteria or the filters).
2. In cases where reports are large, the results view automatically triggers a query to get the results. You may not always want this and in heavy usage environments, you may not want to add this load to the system.

With 11.1.1.6.x onwards, there is a way to change this in the front end. When logged in, click on the My Account tab in the top right corner and make your selection in the Analysis Editor dropdown.

(Thanks to Ajay Sreedharan for showing me this)

The front end does not have any option to change this on a global basis. If you want to change this on a global basis, you will need to change this property in the dashboardeditor.js file found in /app/res/b_mozilla/dashboards folder.

The steps involved in doing this are:

1. Open dashboardeditor.js file.
2. Search for the function "DUIModifyReport".
3. Inside the function you will find that ***"&Action=results&Path="****
4. Change results to criteria. In other words, the changed code will look like
   ****"&Action=criteria&Path="*****
5. Re-deploy the code and bounce the services.

Do note, this will affect for entire dashboard, and for ALL users.

Also, if you don't want to re deploy the code and bounce the servers, you can also make these changes in the dashboardeditor.js file in the <MIDDLEWARE_HOME>/user_projects/domains/BIfoundation/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/<ONE_OF_THE_RANDOM_FOLDERS>/war/res/b_mozilla/dashboards and just restart the services. After restarting, do a clear cache and refresh on your browser.

As with any changes, I would recommend thorough regression testing after the JavaScript change.

With the move from OBIEE 10 to OBIEE 11, the default behavior when editing a report changed. While earlier you would automatically be taken to the criteria view, with OBIEE 11 you are taken by default to the results view. This is can be a problem for 2 reasons:

1. It adds an additional step to edit the report (most of the time you are editing the report to change the criteria or the filters).
2. In cases where reports are large, the results view automatically triggers a query to get the results. You may not always want this and in heavy usage environments, you may not want to add this load to the system.

With 11.1.1.6.0, there is a way to change this in the front end. When logged in, click on the My Account tab in the top right corner and make your selection in the Analysis Editor dropdown.

(Thanks to Ajay Sreedharan for showing me this)

As with any changes, I would recommend thorough regression testing after the JavaScript change.