Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Can we do reporting on PSA

Hi,

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.

Thank you.

Former Member
replied

Hi Sumalini,

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,

http://wiki.scn.sap.com/wiki/display/BI/Write+Optimized+DSO

Disadvantages of Write-Optimized DSO | SCN

OR even I suggest you to try suggestions fromĀ  Former MemberFormer Member

Thanks,

Umashankar

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question