SAP BW Important Interview Questions Paper- Part - 2

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.