Can we do reporting on PSA
As is a temporary staging area and there are no SID's generated.
Even then can we do reporting on PSA ? If so do we need to give PSA table name in Bex while creating a report?
Can you please help me with the answer.
Umashankar Poojar replied
Answer is NO to report on PSA using BEx query. Instead a quick solution would be create a write optimized DSO and load data from PSA to this, anyway it has only one table. Data will load quickly (based on the volume) and report on it.
But if records is in millions then not suggested to use W-DSO for reporting. I assume your requirement is to report on PSA (hope it is less records) to just to use in BEx report for different purpose. Then you can define a semantic in order to ensure the uniqueness of the data.
Read through the links before take a decision on W-DSO,