BEx History not appearing in Query Designer Open dialog

Recently I observed that in my BEx Query Designer there is an empty list on History part of Open dialog pop up window. I knew that I opened many reports in the same BW system in past so it looked like that something doesn’t work. The dialog popup looked like this:

I checked and I found that personalization of BEx History is not active. To activate it is can be done in t-code RS_PERS_ACTIVATE which points to ABAP report of same name.

The t-code is also accessible via SPRO -> SAP NetWeaver -> Business Warehouse -> Settings for Reporting and Analysis -> General Settings for Reporting and Analysis -> Activate Personalization in BEx.

For me it looked like below:

After activating it it turned to this and I started to get a list of previously accessed reports in BEx QD:

The data of previously accessed reports is itself stored in DSO “Personalization Data for the BEx Open Dialog [0PERS_BOD]”. ABAP code which does the activation is encapsulated in ABAP class CL_RS_PERS_PHK and in particular in method ACTIVATE. Table RSPERSHEAD stores information whether BEx History is active or not.

Within the t-code among the BEx history if can also be activated values for BEx Variables that were selected and in case of Web applications report’s drilldowns are saved.

Further information:

Personalizing of BW reports running in JAVA web reporting environment

1849642 - New revision of the transaction RS_PERS_ACTIVATE

1638155 - Issues related to Inactive Personalization in BEx

Personalizing of BW reports running in JAVA web reporting environment

Recently one user ran into strange issue with standard report. He was able to run the report on one day with predefined layout and on another day the layout was gone and he was not able to get it to original report layout. For all other users report looked like before in its original layout. The issue was only occurring in web reporting on top of JAVA stack. In case the user ran in ABAP based web reporting or in BEX Analyzer the report was just fine.

There were other strange things popping up while making an attempt to run the report. In case user tried to make right click on the report he got errors like following:

Error: Variable Entry No variables available Cancel

Error: Incorrect Output Type on Rendering Context Menu Snippets (!= OUTPUT)

Issue is caused by the fact that user somehow managed to activate personalization on that particular report. He was perhaps clicking too much into the report (nervous finger problem) and he accidently clicked on context menu where he choose item “Personalize Web Application” and sub item “Personalize”. This caused that layout that was changed by him before was saved and every time he accessed the report he was getting different report that original report’s layout.

The issue was resolved by deactivating the personalization. It was very hard to manage to click on the context menu and to choose “Delete Personalization” but finally we have done that and it resolved the issue.

You can only face this issue in the system where personalization of web reports is active. You can check that by running program: RS_PERS_ACTIVATE. The program also enables switching the personalization on and off. Here’s how the program looks like when also all other personalization types are active: