Deleting Personalization

[Former Member]

Hi All,

We have a problem with personalization in reports.

Once user has personalized some values we are not able to delete it.

We got few programs and function module to delete the personalization data but further analysing this I found that this programs are only deleting data from table RSWR_PERS. But the personalization data in our system is actually getting added to the table RSPERS_VAR and we could not find any program that would delete this personalization.

We are only SAP BW 7.3 and SP Level 8.

Any help on this front will be highly appreciated.

Thanks & Regards,

Nayan Joshi

[Former Member · Accepted solution]

We've gain the following experiences.

Environment SAP BW 7.3 SP14.

When you switch on Variables Personalization (Report RS_PERS_ACTIVATE) and you don't have activate content DSO 0PERS_VAR, the personalization entries of the users are stored in table RSPERS_VAR. In this case the user can't deactivate the personalization values.

We've solved the problem in the following way. We've activate/transport the personalization DSO 0PERS_VAR in the target system. After that we've deactivate and activate again the Variables Personalization. Now the personalization entries were stored in active table of 0PERS_VAR (/BI0/APERS_VAR00). When a user deactivate an entry, the value will be deleted in the table and the personalization is deleted. All (old) entries in table RSPERS_VAR will be ignored.

Regards,

Konrad

[former_member186696 · Accepted solution]

This thread has one year old. Please, consider has solved.

[Former Member · Accepted solution]

very helpful steps as I was struggling with same issue. Thanks!!!

[former_member188743]

Hi Nayan,

You can enable and disable personalization for each user by

running the query with command

&USE_PERSONALIZATION=X or &USE_PERSONALIZATION="".

Example:

http://abc.dwh.uion:
52600/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!
2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.
bi.bex?
QUERY=ZTEST&VARIABLE_SCREEN=X&USE_PERSONALIZATION=

http://abc.dwh.uion:
52600/irj/servlet/prt/portal/prtroot/pcd!3aportal_content!
2fcom.sap.pct!2fplatform_add_ons!2fcom.sap.ip.bi!2fiViews!2fcom.sap.ip.
bi.bex?
QUERY=ZTEST&VARIABLE_SCREEN=X&USE_PERSONALIZATION=X

Thanks,

Diego Seben.

[Former Member]

Thanks Diego!!!

You mean we should be doing this while creating I-Views?

Regards,

Nayan

[anshu_lilhori]

Personalization data of web template is stored in DSO 0PERS_WTE.

Please check the same if you have data in this or not.

Regards,

AL

[Former Member]

Hi Anshu,

The personaliztion data to for Web template is stored in above DSO.

But the personalization I am talking about is personalization of Variables which would ideally get stored in DSO 0PERS_VAR . But somehow this data is not getting stored in this DSO and is only available in table RSPER_VAR.

[anshu_lilhori]

It seems this table is not available in my system so this is added in the systems which are above 7.3.

Might be some note will be there which addresses your issue.Did you try searching any?

Regards,

AL

[former_member182470]

You have to delete data from this DSO : 0PERS_VAR in BW system. You can selectively delete for the Users.

[Former Member]

There is no data in this DSO.

[former_member182470]

You have to delete from the active table of this DSO: /BI0/APERS_VAR00

[Former Member]

Suman,

As I Mentioned earlier.

There is nothing stored in this DSO to delete.

The data is only stored in the table I have mentioned above (RSPER_VAR).

[former_member182470]

Hope you know that we can update DSO active table directly without having to load through request. Have you checked the active table of it? This is a standard DSO which can store BEx personalization data. For any reason if you don't have that, you can delete the data from RSPER_VAR in debug mode. There are no standard programs.