Question : PSA Table Data Deletion

[Former Member]

Hi,

I have deleted PSA data request of 0GENDER_TEXT. But data for that request is still in PSA Table /BIC/B0000509000. This Data is daily Uploaded through Process Chain in the Every nihgt.My point is that it is blocking memory and not required at all.

An other the example of 0PA_C01 it is full update , in the cube we are deleting before uploading ,but in PSA it is appending by every update. If we are deleting from PSA Request still data for that request is in PSA Table /BIC/B0000521000 & /BIC/B0000522000.

Regards,

Anand Mehrotra.

[Former Member · Accepted solution]

Hi

1.Y dont you delete those PSA table & check whether data is deleted or not??.Actually those are PSA tables..but still now I am wondering what is the purpose of requests deletion.

2. You are deleting the data in the cube & so ofcourse you see data in PSA as you mean in 2nd Q...

hope this helps

thanks

BI Learner

[Former Member]

Hi,

PSA stands for Persistent Staging Area ... you can read that as "Temporary Storage". Meaning you can hold data in the form of the transfer for some time.

If you load data and the infopackage indicates load to the PSA, then you will be storing data in the PSA on every run. If you check Data Targets only, then you will bypass the PSA and no longer store data in it. For me, on Full Loads for Master Data, I always bypass the PSA since I am getting the full dataset on every run.

If I am loading deltas, or it is important to retain a snapshot of a full load on a specific date (month end for example), I will store the data in the PSA for a time until I feel comfortable that I do not need to go back to it for any reason (bad deltas, reloads, etc...). In the case of PA, you may need a headcount snapshot at the end of the month, so you may want to keep that data.

Cubes vs. PSA's: you can delete the data from a cube and the PSA data will still be available. This is evidenced in the "reconstruct" tab where you can reload a request from the PSA.

The best way to delete PSA data for good is to go into the PSA tab under Modeling and do a deletion from those screens.

Good Luck,

Brian

[Former Member]

Hi,

You can also try going to manage tab of the Datasource and delete the PSA requests from there.

[mr_v]

In BW system, run this program RSAR_PSA_CLEANUP_DIRECTORY with

Persistent Staging Area Radio Button and Repair check box 'ON' (checked) and

enter u r PSA table name in Technical ODS Name box.

Then schedule data loads

-

---

If that doesn't work, try to delete PSA table data from SE14...and retry the loads

https://forums.sdn.sap.com/post!reply.jspa?threadID=1062342

https://forums.sdn.sap.com/post!reply.jspa?threadID=984263