A: SAP is using fact table partitioning to improve the performance. you can partition only on 0CALMONTH or 0FISCPER
2. What are the options available in transfer rule and
when ABAP code is recquired during the transfer rule what important variables
you can use?
A: Assign info object, Assign a Constant , ABAP routine
or a Formula
3. How would you optimize the dimensions?
A: Use as many as possible for performance improvement;
Ex: Assume that u have 100 products and 200 customers; if you make one
dimension for both ,the size of the dimension will be 20000; if you make
individual dimensions then the total number of rows will be 300. Even if
you put more than one characterstic per dimension, do the math considering
worst case senerio and decide which characterstics may be combined in a
dimension.
4. What are the conversion routines for units and currencies
in the update rule?
A: Time dimensions are automatically converted; Ex: if
the cube contains calender month and your transfer structure contains date,
the date to calender month is converted automatically.
5. Can you make an infoobject as info provider and why?
A. Yes, When you want to report on characterstics or
master data, you can make them as infoprovider. Ex: you can make 0CUSTMER
as infoprovider and do Bex reporting on 0 CUSTOMER;right click on
the infoarea and select 'Insert characterstic as data target'.
6. What are the steps to unload non cumulative cubes?
A: 1. Initialize openig balance in R/3(S278)
2. Activate extract structure
MC03BF0 for data source 2LIS_03_BF
3. setup historical material
docus in R/3.
4. load opening balance using
data source 2LIS_40_s278
5. load historical movements
and compress without marker update.
6. setup V3 Update
7. load deltas using 2LIS_03_BF
7. Give step to step approach to archiving cubex.
A: 1. double click on the cube (or right click and select
change)
2. Extras -> Select archival
3. Choose fields for selection(like
0CALDAY, 0CUSTOMER..etc)
4. Define the file structure(max
file size and max no of data objects)
5. Select the folder(logical
file name)
6. Select the delete options
(not scheduled, start automatically or after event)
7. activate the cube.
8. cube is ready for archival.
8. 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.
9. 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.
10. 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.
11. How would you convert a info package group into a
process chain?
A: Double Click on the info package grp, click
on the 'Process Chain Maint' button and type in the name and descrition
; the individual info packages are inserted automatically.
12. How do you transoform Open Hub Data?
A: Using BADI
13. 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.
14. What is ODS?
A: Operations data Source . u can overwrite the
existing data in ODS.
15. 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.
16. What are the options when definging aggregates?
A: * - groups accotding to characterstics
H - Hierarchy
F - fixed value
Blank --- none
17. 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.
18. When you write user exit for variables what does I_Step
do?
A: I_Step is used in ABAP code as a conditional
check.
19. How do you replace a query result from a master query
to a child query?
A: If you select characterstic value with replacement
path then it used the results from previuos query; for ex: let us assume
that u have query Q1 which displaysthe top 10 customers, we have query
Q2 which gets the top 10 customers for info object 0customer with as a
vairable with replacement path and display detailed report on the customers
list passed from Q1.
20. 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).
21. What kind of tools are available to monitor the overall Query Performance?
22. What can I do if the database proportion is high for all queries?
23. How to call a BW Query from an ABAP program?
24. What are the extractor types?
25. What are the steps to extract data from R/3?
26. What are the steps to configure third party (BAPI) tools?
27. What are the delta options available when you load from flat file?
28. What are the table filled when you select ABAP?
29. What are the steps to create classes in SAP-BW
30. How do you convert from LIS to LO extraction?
31. How do you keep your self-updated on major SAP Develppments, Give an analytical *-- Anil Bommu
