cancel
Showing results for 
Search instead for 
Did you mean: 

Why bother with Corporate Memory w-o DSOs, when you have PSA?

glen_spalding
Participant
0 Kudos

this is a bit of a point i have been trying to understand, over the past few months or so, only today, i found an interesting SAP reference.

i supports a notion of pointing the Corporate Memory (CM) to the PSA. in other words, use the PSA as the CM.

here is a link to BI Content

SAP HANA-Optimized BI Content - SAP Library

half way down the page is says this

Three-layer approach to the enterprise data warehouse

  • The data is acquired in the open operational data store layer. The PSA serves as the historical data foundation. No transformations or aggregations are defined in this layer.

i wish to point out this bit PSA serves as the historical data foundation  

we all come to learn that the CM serves as the untainted source for history and reloading, so, why dont we just use the PSA these days as the CM. after all, technically, the difference between a w-o DSO and a PSA are nearly the same.

i am aware that you cannot query over the PSA, so would the be the sole reason for separating out the CM in it's own w-oDSOs ?

thanks

g

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

HI,

PSA tables are generated, and there is no defined rule naming of the table (a PSA table can have different names in dev and in prod).

With DSO, you have rules, that could allow you to use it in routines or programs.

Regards.

sander_vanwilligen
Active Contributor
0 Kudos

Hi Glen,

PSA is only meant for short-term inbound data staging, not long-term staging. A w/o DSO is much more suitable (i.e. safer) for this purpose. PSA data can easily get corrupted.

Best regards,

Sander

glen_spalding
Participant
0 Kudos

hi sander, when you say


PSA data can easily get corrupted

i would like to understand how, if you dont mind elaborating

thanks

glen_spalding
Participant
0 Kudos

hi sander

would you then also perform a DTP into the EDW from the PSA, or into the EDW from the Corp Mem ?

glen_spalding
Participant
0 Kudos

hi sander, can i nudge you on your comment about PSAs getting easily corrupted. i guess you mean, more so than DSOs, hence i wish to understand, as i had not heard this before.

thanks

g