I have 77 data loads through 8 process chains.
2.How many Delta loads for SD, MM and FI daily?
Eg. Depends on the objects (cubes and ODS) on use.
3.How many process chains do u have in the project? (approximately)
In my project 8. in some that I know there are 50 to 60 also. Depends on the size and operations of the client. You choose a moderate number, say 15 to 20.
4.How many for master data and how many chains for transaction data?
In my project there are 2 MD chains. In some that I know there are around 5 to 8. You can say there are 4 or 5 chains (some may be daily, some weekly, some even fortnightly).
5.Can We access a process chain which is being accessed by the client at same time?
The client never accesses process chains. He is only concerned with the reports.
6.How many tickets we get on weekly basis? (Approximately)
Again this depends on the size and operations of the company. We get around 2 to 3 tickets per month. In some cases the frequency might be per week. Apart from tickets we may also get SRs (Service Requests). These are small developments (may be another report or may be the entire data flow). These normally come less frequently, say 4 to 8 SRs in a year.
7.Where do we see the Time stamp details of a job load?
Is it SM37 or any other............
Yes you can see the time details of a job in SM37. You can also see the details in RSPC.
8.Data is loaded into cube, Request is green, but the data is not available for Reporting Why?
1. Check whether the records came into the target successfully and the load is completed.
2. check whether any records are added into the cube at all.
3. check if you have aggregates for this cube which need to be updated with the data from the recently loaded request.
9. Tell me the ABAP code which is used to activate the Transfer structure automatically?
Program RS_TRANSTRU_ACTIVATE_ALL à activates all transfer structures for an infosource.
Goto SE38 run the program. You don’t need to write your own code for it.
10.Where do we repair the infoobjects in modeling?
You can do that in transaction RSRV – Analysis and repair of BW objects
There are some other transactions like RSD1 and RSD5 from where you can create, edit or delete infoobjects.