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.

How to search for the data in PSA

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

In my previous post I showed how to search for the date in PSA via standard transparent table in dictationary which underlay behind the PSA. There is another possibility more convenient in BW manner. The idea is to create DataSource of PSA and then check the data with standard BW tool: Extractor checker (TA RSA3).

At first we create DataSource for particular node in PSA tree. Navigate yourself in the PSA tree and choose item “Generate Export DataSource” from right click menu. In this way SAP BW does generates a DataSource for your PSA object.

Once this operation is has successfully finished you should be able to see similar message like following:

Click on the icon of DataSource to explore your newly created DataSource:

On the next screen take a look on the name of your DataSource in field DataSource.

As a next step you can perform PSA searching in Extractor checker. Start up TA: RSA3 and choose your Datasource technical name form previous screen as a DataSource name.

Now just run extraction. Please feel free to filter out entries based on Selection section of RSA3 selection screen.