Pulling data from PSA

[Former Member]

Hello gurus

Is there any way in BI where I can pull data from PSA table directly instead of staging it to a dso or infocube.

The situation is that I want to perform a look up on the psa table data.

I hope my statement is clear.

can any one please let me know with a specific example?

regards

krishna

[former_member188080]

Hi,

You need to stage the data from PSA to some data target..say DSO..

If it is standard DSO you can do look up from say active table data and change log table as well..

I have hardly used direct look up from PSA but normally you should have say write optimised DSO ,so we should not change the data when u are loading write optimised DSO..so from this DSO you can do look up instead of PSA?

also once PSA is deleted it is difficult to track what value you looked up and you have to go to source system all the way..

Thanks and regards

Kiran

[Former Member]

Hi

Pls refer to my initial question. I do not want to stage the data even to a write optimized dso.

Can I still perform a lookup or write some kind of select query/

regards

krishna

[former_member188080]

Hi Krishna,

you can select the data from PSA directly,

there should not be any issue..I never tried..it is PSA table only so /BIC/...YOU can try selecting table..(I never tried this,but think all the points I mentioned above)

Thanks and regards

Kiran

[former_member186445]

yes you can. as the name of the psa table can change, you need to have a dynamic selection statement. i assume you know how to do this, else search on the net. Now you just need an entry in table TVARV where you create a variable holding the name of the psa table.

in the start routine select then this table name and use it in the dynamic selection

you can change the parameter (psa table name) in every system

M.

[former_member186445]

you really need to be more specific if you want an answer...

where do you want to do the lookup? in a query, in a transformation, from another system?

[Former Member]

Hello

I want to do a lookup at the transformation level i.e in the start routine.

regards

krishna

[former_member186445]

search the net...there a million examples available...

eg http://scn.sap.com/thread/2076011