SAP BW Faqs part -III

What are the load process and post processing?A: Info packake, Read PSA and update data target, Save Hierarchy, Update ODS data object, Data export(open hub), delete overlapping requests.

What are the data target administration task
A: delete index, generate index, construct database statistics, initial fill of new aggregates, roll up of filled aggregates, compression of the infocube,activate ODS, complete deletion of data target.

What are the parallel process that could have locking problems
A: 1. heirachy attribute change run
2. loading master data from same infoobject; for ex: avoid master data from different source systems at the same time.
3. rolling up for the same info cube.
4. selecting deletion of info cube/ ODS and parallel loading.
5. activation or delection of ODS object when loading parallel.

How do you transoform Open Hub Data?
A: Using BADI

What are the data loading tuning one can do?
A: 1. watch the ABAP code in transfer and update rules;
2. load balance on different servers
3. indexes on source tables
4. use fixed length files if u load data from flat files and put the file on the application server.
5. use content extractor
6. use PSA and data target inparallel option in the info package
7. start several info packagers parallel with different selection options
8. buffer the SID number ranges if u load lot of data at once
9. load master data before loading transaction data.

What is ODS?
A: Operations data Source . u can overwrite the existing data in ODS.

What is the use of BW Statistics?
A: The sets of cubes delivered by SAP is used to measure performance for query, loading data etc., It also shoes the usage of aggregates and the cost associated with then.

What are the options when definging aggregates?
A: * – groups accotding to characterstics
H – Hierarchy
F – fixed value
Blank — none

How will you debug errors with SAP GUI (like Active X error etc)
A: Run Bex analyzer -> Business Explorer menu item -> Installation check; this shows an excel sheet with a start button; click on it; this verifies the GUI installation ;if u find any errors either reinstall or fix it.

How do you define exception reporting in the background?
A: Use the reporting agent for this from the AWB. Click on the exception icon on the left;give a name and description. Select the exception from query for reporting(drag and drop).