How to set deletion of Statistics Data.......

[Former Member]

Hello i have installed BI ADMIN COCKPIT.

Now i need to make a setting to parameter TCT_KEEP_OLAP_DM_DATA_N_DAYS, so that i can change value for this parameter if i need to decide after how many days the data will be deleted.

For e.g. if the value is 10 it means all the Statistics Data collected in Statistics cubes will be deleted for 10 days before.......and will keep the data only for last 10 days.

Now this parameter is available in RSADMIN table which i can view in SE16 T code.

But the problem is I am not getting this parameter in RSADMIN table.

There is no such parameter visible in that table.

I tried to look for several notes but there is no help.

891740----

---

The best note is also useless as this note is for Support package 11 and we are on 13......

Please advice how to get this parameter...

If not in RSADMIN table, then is there any other way to get this parameter...

I s there any other way to change the setting, other than this parameter...

Please advice.....

[Former Member]

Found the solution

[Former Member]

Hi kartikey!

I have the same problem. I read so much forum posts ans SAP notes, but I couldn't solve it.

Can you post your solution?

Thanks,

Kathi

Could solve the problem

Go to transaction SE38 and execute the program SAP_RSADMIN_MAINTAIN and fill out

OBJECT: TCT_KEEP_OLAP_DM_DATA_N_DAYS

VALUE: whatever you want... e.g.: 30

then you execute it with the checked option INSERT!

Edited by: Katharina Ploderer on Oct 21, 2011 10:50 AM