Tuesday, January 16, 2007

How to search for the data in PSA – choice 1.

Once you are working with SAP Business Warehouse (BW) your job is about data analysis most likely. You need to find check the data in data targets (info cubes/ODSs) explore how data got into these objects, what is the transformation logic and when the bug is somewhere here to compare the data in source or in the PSA area with the data in targets.

One of the ways how to search for the data in PSA is described in following material. First navigate to your DataSource in PSA tree within Modeling section in Administrator section in TA RSA1 and choose “Delete PSA data” item from right click menu:

On next screen that appears scroll to right first section of screen and try to find field called “DDIC table of the PSA”. The content of this field is dictationary table of the PDA data.

You can browse it in SE 11 for instance:

Here you can choose “Contents” icon or use keyboard shortcut CTRL+SHIFT+F10.

No comments: