21. How do you transform Open Hub Data?
• Using BADI we can transform Open Hub Data according to the destination requirement.

22. What is ODS?
• Operational DataSource is used for detailed storage of data. We can overwrite data in the ODS. The data is stored in transparent tables.

23. What are BW Statistics and what is its use?
• They are group of Business Content InfoCubes which are used to measure performance for Query and Load Monitoring. It also shows the usage of aggregates, OLAP and Warehouse management.

24. What are the steps to extract data from R/3?
• Replicate DataSources
• Assign InfoSources
• Maintain Communication Structure and Transfer rules
• Create and InfoPackage
• Load Data

25. What are the delta options available when you load from flat file?
• The 3 options for Delta Management with Flat Files:
o Full Upload
o New Status for Changed records (ODS Object only)
o Additive Delta (ODS Object & InfoCube)
Q) Under which menu path is the Test Workbench to be found, including in earlier Releases?

The menu path is: Tools - ABAP Workbench - Test - Test Workbench.

Q) I want to delete a BEx query that is in Production system through request. Is anyone aware about it?

A) Have you tried the RSZDELETE transaction?

Q) Errors while monitoring process chains.

A) During data loading. Apart from them, in process chains you add so many process types, for example after loading data into Info Cube, you rollup data into aggregates, now this rolling up of data into aggregates is a process type which you keep after the process type for loading data into Cube. This rolling up into aggregates might fail.

Another one is after you load data into ODS, you activate ODS data (another process type) this might also fail.

Q) In Monitor----- Details (Header/Status/Details) à Under Processing (data packet): Everything OK à Context menu of Data Package 1 (1 Records): Everything OK ---- Simulate update. (Here we can debug update rules or transfer rules.)

SM50 à Program/Mode à Program à Debugging & debug this work process.


Q) PSA Cleansing.

A) You know how to edit PSA. I don't think you can delete single records. You have to delete entire PSA data for a request.

Q) Can we make a datasource to support delta.

A) If this is a custom (user-defined) datasource you can make the datasource delta enabled. While creating datasource from RSO2, after entering datasource name and pressing create, in the next screen there is one button at the top, which says generic delta. If you want more details about this there is a chapter in Extraction book, it's in last pages u find out.

Generic delta services: -


Supports delta extraction for generic extractors according to:

Time stamp

Calendar day

Numeric pointer, such as document number & counter

Only one of these attributes can be set as a delta attribute.


Delta extraction is supported for all generic extractors, such as tables/views, SAP Query and function modules

The delta queue (RSA7) allows you to monitor the current status of the delta attribute