Home
1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario .
2. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario
3. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.
4. when u creating infoobject it shows reference and template what is it
5. what is meant by compounding attribute tell me the scenario?
6. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?
7. I have 10 cubes I created multiprovider I want only 1 cube data what u do?
8. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?
9. I have 80 queries which query is taking so much time how can you solve it
10. In compression level all requests are becoming zero which data is compressing tell me detail
11. what is meant by flat aggregate?explain in detail
12. I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
13. how can u know the cube size? in detail show me u have screen shots
14. where can we find transport return codes
15. I have a report it taking so much time how can I rectify
16. what is offset? Without offset we create queries?
17. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is
18. how client access the reports
19. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one
20. what is structure in reporting?
21. which object based you created extended star schema?
22. what is line item dimension tell me brief
23. what is high cardinality tell me brief
24. process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations
25. what is direct schedule and what is meta chain
26. which patch u used presently? How can I know which patch that one?
27. how can we increase data packet size
28. hierarchies are not there in bi?why
29. remodeling is applied only on info cube? why not dso/ods?
30. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
31. why ODS activation fail? What types of fails are there? What are the steps to handle 32. I have a process chain is running the info package get error don’t process the error of that info package and then you can run the dependent variants is it possible? Give me any performance and loading issues or support issues Reporting errors, Loading errors, process chain errors? Please explain in detail or create a screenshots for all the questions and explain in detail If u have any screen shots or text data can u give me the link.
is their any difference between bex 3.5 and bex 7.0?
R/3 extraction failed – recovery procedure?
R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?
what are the pre requisites for BI content installation?R/3 extraction failed – recovery procedure?
what r the diff types of conditions in reporting??when do we use infocube and ODS??? (scenario).how many types of infocubes are there?
32.What is exception Aggregation? give Example? 2.what Cell formating? and Advantages?
33.What is I_step1,I_step2,I_step3 in customer exit What is occurrence.what are the common errors occur during data loading and perfornance level?
34.what are types of update rules and transfer rules? and what are the routines to be used in bw 3.5?what is a dimension table and types? explain about line item dimension and high cardinality and uses, in which case suppose to be use?
35.We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario
36. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario
37. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.
38. when u creating infoobject it shows reference and template what is it
39. what is meant by compounding attribute tell me the scenario?
40. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?
41. I have 10 cubes I created multiprovider I want only 1 cube data what u do?
42. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?
43. I have 80 queries which query is taking so much time how can you solve it
44. In compression level all requests are becoming zero which data is compressing tell me detail
45. what is meant by flat aggregate?explain in detail
46. I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
46. how can u know the cube size? in detail show me u have screen shots
47. where can we find transport return codes
48. I have a report it taking so much time how can I rectify
49. what is offset? Without offset we create queries?
50. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is
51. how client access the reports
52. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one
53. what is structure in reporting?
54. which object based you created extended star schema?
55. what is line item dimension tell me brief
56. what is high cardinality tell me brief
57. process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? In multiprovider can I use aggregations
58. what is direct schedule and what is meta chain
59. which patch u used presently? How can I know which patch that one?
60. how can we increase data packet size
61. hierarchies are not there in bi?why
62. remodeling is applied only on info cube? why not dso/ods?
64. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
64. why ods activation fail? What types of fails are there? What are the steps to handle
65. I have a process chain is running the infopackage get error don’t process the error of that info package and then you can run the dependent variants is it possible?
66.Give me any performance and loading issues or support issues,Reporting errors, Loading errors, process chain errors?
=================================================================
Interview Questions with Answers:
1. What is table partition?
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 Developments, Give an analytical .
SAP BW Questions – Some Real Question
1. Differences b/w 3.0 and 3.5
2. Differences b/w 3.5 and BI 7.0
3. Can you explain a life cycle in brief
4. Difference b/w table & structure
5. Steps of LO
6. Steps of LIS
7. Steps of generic
8. What is index and how do you increase performance using them
9. How do you load deltas into ODS and cube
10. Example of errors while loading data and how do u resolve them
11. How do you maintain work history until a ticket is closed
12. What is reconciliation
13. What is the methodology u use before implementation
14. What are the role & responsibilities when you are in implementation and while in support also.
New features in BI 7 compared to earlier versions:
New data flow capabilities such as Data Transfer Process (DTP), Real time data Acquisition (RDA).
Enhanced and Graphical transformation capabilities such as Drag and Relate options.
One level of Transformation. This replaces the Transfer Rules and Update Rules
Performance optimization includes new BI Accelerator feature.
User management (includes new concept for analysis authorizations) for more flexible BI end user authorizations.
Business scenarios in BW
Complete life-cycle implementation of SAP BW, which includes data modeling, data extraction, data loading, reporting and support.
When they refer to the full life cycle its the ASAP methodology which SAP recommends to follow for all its projects.
1.Project peparation.
2.Business Blueprint.
3.Realization.
4.Fit-Gap Analysis
5.Go-Live Phase.
Normally in the first phase all the management guys will sit with in a discussion . In the second phase u will get a functional spec n basing on that u will have a technical spec. In the third phase u will actually inplement the project and finally u after testing u will deploy it for production i.e. Go-live .
You might fall under and get involved in the realization phase . If its a supporting project u will come into picture only after successful deployment.
LO extraction is one stop shop for all the logistics extarctions .
LO dataosuurces come as a part of the business content in BW .
We need to transfer them from the BCT and then activate them from D version to the active Version A .
Go to the tcode — RSA5 —- Transfer the desired datasource and then LBWE to maintain the extract structure LBWG — to delete the setup tables —- why … ? OLI*bw — Statistcal initialization . LBWQ — To delete the extractor queue SM13 — to delete the update queue . LBWf — to get the log .
Its always recommended to have the Queued delta as an update method , since it uses the collective run to schedule all the changed records.
Once the initial run is over set the delta method Queued to periodic for further delta load Why ..?
We need to delete the setup tables since we need to delete the data that is already in them and also because we will change the ES by adding the required fields from the R/3 communuication structure.we can also select and hide the fields here . all the fields in blue are mandatory ..
If the required fields are not available we will go for the DS enhancements .
=================================
6A. LIS uses information structures to extract the data .it comes under the application specific customer generated extractions.
The range is 000 to 999.
0-499 is for SAP structures n 500 to 999 are for customer defined .
We need to consider the two cases if its the SAP defined r the customer defined .
Lets see the SAP defined first :
Tcode — LBW0
give the information structure and select the option display settings to know the status .if u select the generate datasource option it will throw an error saying that u cannot create in the SAp name range .
You select the option the setup environment settings it will create the two tables n one structure with the naming convention .. 2LIS_application no _BIW1 ,2LIS_appl No _BIW2 and 2LIS _appl no_BIWS
These two structures are used to enable the delta records interchangebaly — we will come to know this in the table TMCBIW .
Then go to LBW1 to change the version..
LBW2 to setup the no update update method .. now you do the full load and after that go LBW1 change the version and then go to LBW2 to setup the delta update n the periodic job .
Now you can load the delta updates .
If its in the case of the user defined :
You need to create the IS
MC18 — create the IS
MC19– change
MC20 — dispaly
MC21–MC22,,MC23,MC24,MC25,MC26 folwing to craete the update rules .
Then Tcode LBW0 give the IS name and
sel setup lis environment it will craete the the two tables n the structure ..
You can use OMO1 to fill the tables n u do the full upload then u need to setup the delta by sel the steup delta ..
You can set whether the delta is enabled are not using the option activate /deactivate deelta
Both in cases you need while migrating the data you need to lock the setup tables to prevent users from entreing the transactions SE14 … and after completion u need to unlock .
But LO is preffered to LIS in all aspects .. LO provdes the IS upto the level of detail .
Enhanced performance and also deletion of setup tables after updation which we never do in LIS .
============================
7A. We opt for generic extraction whenever the desired datasource is not available in business content or if it is already used and we need to regenerate it . when u want to extract the data from table, view, infoset, function module we use generic extraction. In generic we create our own datasource and activate it .
Steps :
1.Tcode is RSO2
2.Give the datasource name and designate it to a particular application component.
3. Give the short medium and long desc mandatory.
4. Give the table / Fm /view /infoset.
5. and continue which leads to a detail screen in which you can always hide, select ,inversion , field only options are available.
HIDE is used to hide the fields .. it will not transfer the data from r/3 to BW SELECT — the fields are available in the selection screen of the info package while u schedule it . INVERSION is for key figs which will operate with ‘-1’ and nullify the value .
Once the datasource is generated you can extract the data using it .
And now to speak abt the delta … we have .. 0calday , Numeric pointer , time stamp.
0calday — is to be run only once a day that to at the end of the day and with a range of 5 min. Numeric Pointer — is to be used for the tables where it allows only appending of records ana no change .. eg: CATSDB HRtime managent table .
Timestamp: using this you can always delta as many times as possible with a upeprlimit .
Whenever there 1:1 relation you use the view and 1:m you use FM.
============================
8A. INDEX: They are used to improve the performance of data retrival while executing the queries or work books the moment when we execute and once we place the valiues in Selection criteria at that time the indexes will act as retrival point of data .. and it will fetch the data in a faster mannner ..
Just common example if you can obeserve any book which has indexes .. This indexes will give a exact location of each topic based on this v can easily go to that particulur page and we will continue our thingz. Similar mannner in the data level the indexes are act in BW side…
=============================
9A. Time stamp error.
sol: activate the data source and replicate the data source and load.
2. Data error in PSA.
sol: Modify the in PSA error data and load.
3. RFC connection failed.
sol: raise the ticket to BASIS team to provide the connection.
4. Short dump error.
sol: delete the request and load once again.
a) Loads can be failed due to the invalid characters
b) Can be because of the deadlock in the system
c) Can be becuase of previuos load failure , if the load is dependant on other loads
d) Can be because of erreneous records
e) Can be because of RFC connections…..(sol: raise the ticket to BASIS team to provide the connection)
f) Can be because of missing master data.
g) Can be because of no data found in the source system
h) Invalid characters while loading. When you are loading data then you may get some special characters like @#$%…e.t.c..then BW will throw an error like Invalid characters..then you need to go through this RSKC transaction and enter all the Invalid chars and execute..it will store this data in RSALLOWEDCHAR table..Then reload the data..You won’t get any error because now these are eligible chars..done by RSKC.
i) ALEREMOTE user is locked Normally, ALEREMOTE gets locked due to a sm59 RFC destination entry having the incorrect password. You should be about to get a list of all sm59 RFC destinations using ALEREMOTE by using transaction se16 to search field RFCOPTIONS for a value of “*U=ALEREMOTE”. You will need to look for this information in any external R/3 instances that call the instance in which ALEREMOTE is getting locked as well.
j) Lower case letters not allowed. look at your infoobject description: Lowercase Letters allowed
k)extraction job aborted in r3 It might have got cancelled due to running for more than the expected time, or may be cancelled by R/3 users if it is hampering the performance.
l)datasource not replicated If the new DataSource is created in the source system, you should replicate this DataSource in ‘dialog’ mode. During the replication, you can decide whether this DataSource should be replicated as the 3.x DataSource or as the new DataSource. If you do not run the replication in ‘dialog’ mode, the DataSource is not replicated.
m)ODS Activation Error ODS activation errors can occur mainly due to following reasons
1. Invalid characters (# like characters)
2. Invalid data values for units/currencies etc
3. Invalid values for data types of char & key figures.
4. Error in generating SID values for some data
===================================
10A Ticket is nothing but an issue or a process error which need to be addressed.
There are two types of tickets.
* ito tickets – which are usually generated by the system automatically when a process fails.for example, when a process chain fails toi run it wil generate an ito ticket which we need to address and find the fault.
* non-ito tickets – which are the issues which the client face and which are forwarded for correction or alternative action.
If you’re using Remedy for tickets, Unfortunately it’s not possible. But this depends on the software you are using, ask your admin.
===========================
11A Reconciliation is nothing but the comaprision of the values between BW target data with the Source system data like R/3, JD edwards,Oracle,ECC or SCM or SRM.
In general this process is taken @ 3 places one is comparing the info provider data with R/3 data,Compare the Query display data with R/3 or ODS data and
Checking the data available in info provider kefigure with PSA key figure values
====================
12A ASAP Methodology
1. Project Preparation, in which the project team is identified and mobilized, the project standards are defined, and the project work environment is set up;
2. Blueprint, in which the business processes are defined and the business blueprint document is designed;
3. Realization, in which the system is configured, knowledge transfer occurs, extensive unit testing is completed, and data mappings and data requirements for migration are defined;
4. Final Preparation, in which final integration testing, stress testing, and conversion testing are conducted, and all end users are trained; and
5. Go-Live and Support, in which the data is migrated from the legacy systems, the new system is activated, and post-implementation support is provided
========================
13A Responsibilities of an implementation project… For ex, Lets say If its a fresh implementation of BI or for that matter you are implementing SAP…
First and foremost will be your requirements gathering from the client. Depending upon the requirements you will creat a business blueprint of the project which is the entire process from the start to the end of an implementation…
After the blue print phase sign off we start off with the realization phase where the actual development happens… In our example after installing the necessary softwares, patches for BI we need to discuss with the end users who are going to use the system for inputs like how they want a report to look like and what are the Key Performance Indicators(KPI) for the reports etc., basically its a question and answer session with the business users… After collecting those informations the development happens in the development servers…
After the development comes to an end the same objects are tested in quality servers for any bugs, errors etc., When all the tests are done we move all the objects to the production environment and test it again whether everything works fine…
The Go-Live of the project happens where the actually postings happen from the users and reports are generated based on those inputs which will be available as an analytical report for the management to take decisions…
The responsibilites vary depending on the requirement… Initially the business analyst will interact with the end users/managers etc., then on the requirements the software consultants do the development, testers do the testing and finally the go-live happens…
What are the objects that we peform in a production Support project?
In production Suport Generally most of the project they will work on monitoring area for their loads(R3/ NON SAP to Data Taggets (BW)) and depending up the project to project it varies because some of them using the PC’s and Some of them using Event Chains. So its Depends up on the Project to project varies.
What are the different transactions that we use frequently in Production support project? Plz explain them in detial.. Generally In Production Support Project , we will use the check the loads by using RSMO for Monitoring the loads and we will rectify the errors in that by using step by step analysis.
The consultant is required to have access to the following transactions in R3.
1. ST22
2. SM37
3. SM58
4. SM51
5. RSA7
6. SM13
Authorizations for the following transactions are required in BW
1. RSA1
2. SM37
3. ST22
4. ST04
5. SE38
6. SE37
7. SM12
8. RSKC
9. SM51
10. RSRV
The Process Chain Maintenance (transaction RSPC) is used to define, change and view process chains.
Upload Monitor (transaction RSMO or RSRQ (if the request is known)
The Workload Monitor (transaction ST03) shows important overall key performance indicators (KPIs) for the system performance
The OS Monitor (transaction ST06) gives you an overview on the current CPU, memory, I/O and network load on an application server instance.
The database monitor (transaction ST04) checks important performance indicators in the database, such as database size, database buffer quality and database indices.
The SQL trace (transaction ST05) records all activities on the database and enables you to check long runtimes on a DB table or several similar accesses to the same data.
The ABAP runtime analysis (transaction SE30)
The Cache Monitor (accessible with transaction RSRCACHE or from RSRT) shows among other things the cache size and the currently cached queries. The Export/Import Shared buffer determines the cache size; it should be at least 40MB.
FAQ SAP BI/BW
1. Where do we used number range buffering? Codes SE27 and SNRO
2. what are the different cases in which update rules can be copied?
3. what are the different types of queries?
4. what is query view and query definition?
5. what is query template?
6. what is the difference between drill down and slice n dice?
7. what is result set query and infoset query?
8. what are jump queries?
9. what is drill up and drill across and how is drill across done?
10. what is an infoset and what the difference to it in BI 7?
11. what are the three scenarios for ods reporting?
12. what is an info catalog?
13. what are free characteristics and filters?
14. what are the difference between restricted key figures and filters?
15. what is the use of formula in BW?
16. what are advance query techniques in BW?
17. what is exception reporting?
18. what is reporting agent?
19. what is a variable and different types of variables and what is the use of variables?
20. at what times will currencies be translated?
21. what is the use of user exists?
22. what is query management?
23. what are the techniques to improve query performance?
24. what is query monitor? Is it useful for aggregates, if so how?
25. what are the query modes available in BW?
26. what is an aggregate and what is the use of it?
27. how are aggregated updated and when is it recommended to use aggregates?
28. what are the conditions and factors to be taken into account while creating aggregates?
29. what are the different strategies for creating an aggregate?
30. how aggregates can be optimized?
31. what is a profile generator and what is the use of it?
32. what is the difference between authorization and authorization objects?
33. what is Bex map?
34. what is web reporting and what are the benefits of using it?
35. what are the differences of bex and web reporting?
36. what is bex web application designer?
37. what type of servers are required to allow web reporting in SAP BW?
38. what is web reporting template?
39. what does data changes aggregates update program do?
40. what is the aim of aggregates and in what case can you not create aggregates?
41. where can data be filtered in SAP BW?
42. What are the variables used in Bex reporting?
43. What are the different Processing Types?
44. What is the replacing path Process Type? What is the input for Replacing path process type?
45. How do you create a Generic data source?
46. What are the function modules?
47. Types of Deltas?
48. what are the Generic delta types?
49. Explain V3 Update?
50. What is Cell definition?
51. How do you Transport objects from Development to Quality? IMP
52. What is Navigation Attribute? What are the tables will create while creating Navigational attribute?
53. What are the tables for Master data in BW?
54. What are the tables will create while creating Info Object?
55. What are the tables will create while creating Info Cube?
56. Explain your Landscape? Examples?
57. Explain Implementation Methodologies?
58. ABAP reports?
59. What are the tables for SD in R/3?
60. how many Process Chains you are used?
61. What are the issues Faced while loading data?
62. What are the custom cubes you used?
63. How many users your company have?
64. What are the queries you have created?
65. What are the characteristics, key figures involved in query?
66. On what basis you assign Characteristics to Dimensions?
67. What is Plan data and where it will sit?
68.HOw to creat a report on one column where we stored both sales Report ?
69.How to strat & STOP PROCESS CHAIN
70: LOWER CASE & UPPER CASE ?
71: WHY WE GO FOR GENERIC EXTRACTION ? WHICH CASE ? IF THE DATA WILL BE IN 3 TABLES & WE HAVE TO EXRTACT THE DATA FROM TWO FIELDS THEN WHAT TO DO ?
72: ENHNACEMENT CASE WHICH LOGIC APPLY BY YOU ?
73: HOW MANY REPORTS /INFOCUBE /INFOSOURSE / DSO CREATED BY YOU ?
74: BASED OPEN 2LIS_11_VAHDR WHAT ARE THE REPORT U ARE CREATED ?
75: WHY WE GO FOR CEREATING INDEX ? HOW TO KNOW THAT IT’S THE TIME TO CREAT THE INDEX ? why index not other Compress/ ?
76: HOW TO ROLE AUTHORIZEID SAP BI ?
77:WHAT IS EARLY INITIALZE DELTA ?
78: Wht is best for reporting Infocube or Dso ? why ?
79: How many tables are in dso ? standard dso / direct dso / write optimized dso ?
80: Selective Deletion /Repair full request / Repet delta /Reverse Posting /?
81: if the data is loaded in sapbw /sap bi & i want to serach the pericular year data ? where to search ?
82 : Data is loading from sap bi/bw if in extraction stage it fails / How to rectify ? whr to searchh ?
1. We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario .
2. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario
3. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.
4. when u creating infoobject it shows reference and template what is it
5. what is meant by compounding attribute tell me the scenario?
6. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?
7. I have 10 cubes I created multiprovider I want only 1 cube data what u do?
8. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?
9. I have 80 queries which query is taking so much time how can you solve it
10. In compression level all requests are becoming zero which data is compressing tell me detail
11. what is meant by flat aggregate?explain in detail
12. I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
13. how can u know the cube size? in detail show me u have screen shots
14. where can we find transport return codes
15. I have a report it taking so much time how can I rectify
16. what is offset? Without offset we create queries?
17. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is
18. how client access the reports
19. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one
20. what is structure in reporting?
21. which object based you created extended star schema?
22. what is line item dimension tell me brief
23. what is high cardinality tell me brief
24. process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations
25. what is direct schedule and what is meta chain
26. which patch u used presently? How can I know which patch that one?
27. how can we increase data packet size
28. hierarchies are not there in bi?why
29. remodeling is applied only on info cube? why not dso/ods?
30. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
31. why ODS activation fail? What types of fails are there? What are the steps to handle 32. I have a process chain is running the info package get error don’t process the error of that info package and then you can run the dependent variants is it possible? Give me any performance and loading issues or support issues Reporting errors, Loading errors, process chain errors? Please explain in detail or create a screenshots for all the questions and explain in detail If u have any screen shots or text data can u give me the link.
is their any difference between bex 3.5 and bex 7.0?
R/3 extraction failed – recovery procedure?
R/3 extraction is running from past 2 years. Suddenly it failed since 5 days and again today it is running fine. But how i do get data loaded to cube for failed loads? What are the procedures that can be followed?
what are the pre requisites for BI content installation?R/3 extraction failed – recovery procedure?
what r the diff types of conditions in reporting??when do we use infocube and ODS??? (scenario).how many types of infocubes are there?
32.What is exception Aggregation? give Example? 2.what Cell formating? and Advantages?
33.What is I_step1,I_step2,I_step3 in customer exit What is occurrence.what are the common errors occur during data loading and perfornance level?
34.what are types of update rules and transfer rules? and what are the routines to be used in bw 3.5?what is a dimension table and types? explain about line item dimension and high cardinality and uses, in which case suppose to be use?
35.We have standard info objects given in sap why you created zinfo objects can u tell me the business scenario
36. We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario
37. In keyfigure what is meant by cumulative value, non cumulative value change and non cumulative value in and out flow.
38. when u creating infoobject it shows reference and template what is it
39. what is meant by compounding attribute tell me the scenario?
40. I have 3 cubes for that I created multiprovider and I created a report for that but I didn’t get data in that report what happen?
41. I have 10 cubes I created multiprovider I want only 1 cube data what u do?
42. what is meant by safety upper limit and safety lower limit in all the deltas tell me one by one for time stamp, calender day and numberic pointer?
43. I have 80 queries which query is taking so much time how can you solve it
44. In compression level all requests are becoming zero which data is compressing tell me detail
45. what is meant by flat aggregate?explain in detail
46. I created process chain 1st day it taking 10 min after that 1st week it taking 1 hour after that next time it taking 1 day with a same loads what happen how can u reduce the time of loading
46. how can u know the cube size? in detail show me u have screen shots
47. where can we find transport return codes
48. I have a report it taking so much time how can I rectify
49. what is offset? Without offset we create queries?
50. I told my process chains nearly 600 are there he asked me how can u monitor I told him I will see in rspcm and bwccms he asked is there any third party tools is there to see? Any tools are there to see tell me what it is
51. how client access the reports
52. I don’t have master data it will possible to load transaction data? it is possible is there any other steps to do that one
53. what is structure in reporting?
54. which object based you created extended star schema?
55. what is line item dimension tell me brief
56. what is high cardinality tell me brief
57. process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? In multiprovider can I use aggregations
58. what is direct schedule and what is meta chain
59. which patch u used presently? How can I know which patch that one?
60. how can we increase data packet size
61. hierarchies are not there in bi?why
62. remodeling is applied only on info cube? why not dso/ods?
64. In jump queries we can jump any transactions just like rsa1, sm37 etc it is possible or not?
64. why ods activation fail? What types of fails are there? What are the steps to handle
65. I have a process chain is running the infopackage get error don’t process the error of that info package and then you can run the dependent variants is it possible?
66.Give me any performance and loading issues or support issues,Reporting errors, Loading errors, process chain errors?
=================================================================
Interview Questions with Answers:
1. What is table partition?
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 Developments, Give an analytical .
SAP BW Questions – Some Real Question
1. Differences b/w 3.0 and 3.5
2. Differences b/w 3.5 and BI 7.0
3. Can you explain a life cycle in brief
4. Difference b/w table & structure
5. Steps of LO
6. Steps of LIS
7. Steps of generic
8. What is index and how do you increase performance using them
9. How do you load deltas into ODS and cube
10. Example of errors while loading data and how do u resolve them
11. How do you maintain work history until a ticket is closed
12. What is reconciliation
13. What is the methodology u use before implementation
14. What are the role & responsibilities when you are in implementation and while in support also.
New features in BI 7 compared to earlier versions:
New data flow capabilities such as Data Transfer Process (DTP), Real time data Acquisition (RDA).
Enhanced and Graphical transformation capabilities such as Drag and Relate options.
One level of Transformation. This replaces the Transfer Rules and Update Rules
Performance optimization includes new BI Accelerator feature.
User management (includes new concept for analysis authorizations) for more flexible BI end user authorizations.
Business scenarios in BW
Complete life-cycle implementation of SAP BW, which includes data modeling, data extraction, data loading, reporting and support.
When they refer to the full life cycle its the ASAP methodology which SAP recommends to follow for all its projects.
1.Project peparation.
2.Business Blueprint.
3.Realization.
4.Fit-Gap Analysis
5.Go-Live Phase.
Normally in the first phase all the management guys will sit with in a discussion . In the second phase u will get a functional spec n basing on that u will have a technical spec. In the third phase u will actually inplement the project and finally u after testing u will deploy it for production i.e. Go-live .
You might fall under and get involved in the realization phase . If its a supporting project u will come into picture only after successful deployment.
LO extraction is one stop shop for all the logistics extarctions .
LO dataosuurces come as a part of the business content in BW .
We need to transfer them from the BCT and then activate them from D version to the active Version A .
Go to the tcode — RSA5 —- Transfer the desired datasource and then LBWE to maintain the extract structure LBWG — to delete the setup tables —- why … ? OLI*bw — Statistcal initialization . LBWQ — To delete the extractor queue SM13 — to delete the update queue . LBWf — to get the log .
Its always recommended to have the Queued delta as an update method , since it uses the collective run to schedule all the changed records.
Once the initial run is over set the delta method Queued to periodic for further delta load Why ..?
We need to delete the setup tables since we need to delete the data that is already in them and also because we will change the ES by adding the required fields from the R/3 communuication structure.we can also select and hide the fields here . all the fields in blue are mandatory ..
If the required fields are not available we will go for the DS enhancements .
=================================
6A. LIS uses information structures to extract the data .it comes under the application specific customer generated extractions.
The range is 000 to 999.
0-499 is for SAP structures n 500 to 999 are for customer defined .
We need to consider the two cases if its the SAP defined r the customer defined .
Lets see the SAP defined first :
Tcode — LBW0
give the information structure and select the option display settings to know the status .if u select the generate datasource option it will throw an error saying that u cannot create in the SAp name range .
You select the option the setup environment settings it will create the two tables n one structure with the naming convention .. 2LIS_application no _BIW1 ,2LIS_appl No _BIW2 and 2LIS _appl no_BIWS
These two structures are used to enable the delta records interchangebaly — we will come to know this in the table TMCBIW .
Then go to LBW1 to change the version..
LBW2 to setup the no update update method .. now you do the full load and after that go LBW1 change the version and then go to LBW2 to setup the delta update n the periodic job .
Now you can load the delta updates .
If its in the case of the user defined :
You need to create the IS
MC18 — create the IS
MC19– change
MC20 — dispaly
MC21–MC22,,MC23,MC24,MC25,MC26 folwing to craete the update rules .
Then Tcode LBW0 give the IS name and
sel setup lis environment it will craete the the two tables n the structure ..
You can use OMO1 to fill the tables n u do the full upload then u need to setup the delta by sel the steup delta ..
You can set whether the delta is enabled are not using the option activate /deactivate deelta
Both in cases you need while migrating the data you need to lock the setup tables to prevent users from entreing the transactions SE14 … and after completion u need to unlock .
But LO is preffered to LIS in all aspects .. LO provdes the IS upto the level of detail .
Enhanced performance and also deletion of setup tables after updation which we never do in LIS .
============================
7A. We opt for generic extraction whenever the desired datasource is not available in business content or if it is already used and we need to regenerate it . when u want to extract the data from table, view, infoset, function module we use generic extraction. In generic we create our own datasource and activate it .
Steps :
1.Tcode is RSO2
2.Give the datasource name and designate it to a particular application component.
3. Give the short medium and long desc mandatory.
4. Give the table / Fm /view /infoset.
5. and continue which leads to a detail screen in which you can always hide, select ,inversion , field only options are available.
HIDE is used to hide the fields .. it will not transfer the data from r/3 to BW SELECT — the fields are available in the selection screen of the info package while u schedule it . INVERSION is for key figs which will operate with ‘-1’ and nullify the value .
Once the datasource is generated you can extract the data using it .
And now to speak abt the delta … we have .. 0calday , Numeric pointer , time stamp.
0calday — is to be run only once a day that to at the end of the day and with a range of 5 min. Numeric Pointer — is to be used for the tables where it allows only appending of records ana no change .. eg: CATSDB HRtime managent table .
Timestamp: using this you can always delta as many times as possible with a upeprlimit .
Whenever there 1:1 relation you use the view and 1:m you use FM.
============================
8A. INDEX: They are used to improve the performance of data retrival while executing the queries or work books the moment when we execute and once we place the valiues in Selection criteria at that time the indexes will act as retrival point of data .. and it will fetch the data in a faster mannner ..
Just common example if you can obeserve any book which has indexes .. This indexes will give a exact location of each topic based on this v can easily go to that particulur page and we will continue our thingz. Similar mannner in the data level the indexes are act in BW side…
=============================
9A. Time stamp error.
sol: activate the data source and replicate the data source and load.
2. Data error in PSA.
sol: Modify the in PSA error data and load.
3. RFC connection failed.
sol: raise the ticket to BASIS team to provide the connection.
4. Short dump error.
sol: delete the request and load once again.
a) Loads can be failed due to the invalid characters
b) Can be because of the deadlock in the system
c) Can be becuase of previuos load failure , if the load is dependant on other loads
d) Can be because of erreneous records
e) Can be because of RFC connections…..(sol: raise the ticket to BASIS team to provide the connection)
f) Can be because of missing master data.
g) Can be because of no data found in the source system
h) Invalid characters while loading. When you are loading data then you may get some special characters like @#$%…e.t.c..then BW will throw an error like Invalid characters..then you need to go through this RSKC transaction and enter all the Invalid chars and execute..it will store this data in RSALLOWEDCHAR table..Then reload the data..You won’t get any error because now these are eligible chars..done by RSKC.
i) ALEREMOTE user is locked Normally, ALEREMOTE gets locked due to a sm59 RFC destination entry having the incorrect password. You should be about to get a list of all sm59 RFC destinations using ALEREMOTE by using transaction se16 to search field RFCOPTIONS for a value of “*U=ALEREMOTE”. You will need to look for this information in any external R/3 instances that call the instance in which ALEREMOTE is getting locked as well.
j) Lower case letters not allowed. look at your infoobject description: Lowercase Letters allowed
k)extraction job aborted in r3 It might have got cancelled due to running for more than the expected time, or may be cancelled by R/3 users if it is hampering the performance.
l)datasource not replicated If the new DataSource is created in the source system, you should replicate this DataSource in ‘dialog’ mode. During the replication, you can decide whether this DataSource should be replicated as the 3.x DataSource or as the new DataSource. If you do not run the replication in ‘dialog’ mode, the DataSource is not replicated.
m)ODS Activation Error ODS activation errors can occur mainly due to following reasons
1. Invalid characters (# like characters)
2. Invalid data values for units/currencies etc
3. Invalid values for data types of char & key figures.
4. Error in generating SID values for some data
===================================
10A Ticket is nothing but an issue or a process error which need to be addressed.
There are two types of tickets.
* ito tickets – which are usually generated by the system automatically when a process fails.for example, when a process chain fails toi run it wil generate an ito ticket which we need to address and find the fault.
* non-ito tickets – which are the issues which the client face and which are forwarded for correction or alternative action.
If you’re using Remedy for tickets, Unfortunately it’s not possible. But this depends on the software you are using, ask your admin.
===========================
11A Reconciliation is nothing but the comaprision of the values between BW target data with the Source system data like R/3, JD edwards,Oracle,ECC or SCM or SRM.
In general this process is taken @ 3 places one is comparing the info provider data with R/3 data,Compare the Query display data with R/3 or ODS data and
Checking the data available in info provider kefigure with PSA key figure values
====================
12A ASAP Methodology
1. Project Preparation, in which the project team is identified and mobilized, the project standards are defined, and the project work environment is set up;
2. Blueprint, in which the business processes are defined and the business blueprint document is designed;
3. Realization, in which the system is configured, knowledge transfer occurs, extensive unit testing is completed, and data mappings and data requirements for migration are defined;
4. Final Preparation, in which final integration testing, stress testing, and conversion testing are conducted, and all end users are trained; and
5. Go-Live and Support, in which the data is migrated from the legacy systems, the new system is activated, and post-implementation support is provided
========================
13A Responsibilities of an implementation project… For ex, Lets say If its a fresh implementation of BI or for that matter you are implementing SAP…
First and foremost will be your requirements gathering from the client. Depending upon the requirements you will creat a business blueprint of the project which is the entire process from the start to the end of an implementation…
After the blue print phase sign off we start off with the realization phase where the actual development happens… In our example after installing the necessary softwares, patches for BI we need to discuss with the end users who are going to use the system for inputs like how they want a report to look like and what are the Key Performance Indicators(KPI) for the reports etc., basically its a question and answer session with the business users… After collecting those informations the development happens in the development servers…
After the development comes to an end the same objects are tested in quality servers for any bugs, errors etc., When all the tests are done we move all the objects to the production environment and test it again whether everything works fine…
The Go-Live of the project happens where the actually postings happen from the users and reports are generated based on those inputs which will be available as an analytical report for the management to take decisions…
The responsibilites vary depending on the requirement… Initially the business analyst will interact with the end users/managers etc., then on the requirements the software consultants do the development, testers do the testing and finally the go-live happens…
What are the objects that we peform in a production Support project?
In production Suport Generally most of the project they will work on monitoring area for their loads(R3/ NON SAP to Data Taggets (BW)) and depending up the project to project it varies because some of them using the PC’s and Some of them using Event Chains. So its Depends up on the Project to project varies.
What are the different transactions that we use frequently in Production support project? Plz explain them in detial.. Generally In Production Support Project , we will use the check the loads by using RSMO for Monitoring the loads and we will rectify the errors in that by using step by step analysis.
The consultant is required to have access to the following transactions in R3.
1. ST22
2. SM37
3. SM58
4. SM51
5. RSA7
6. SM13
Authorizations for the following transactions are required in BW
1. RSA1
2. SM37
3. ST22
4. ST04
5. SE38
6. SE37
7. SM12
8. RSKC
9. SM51
10. RSRV
The Process Chain Maintenance (transaction RSPC) is used to define, change and view process chains.
Upload Monitor (transaction RSMO or RSRQ (if the request is known)
The Workload Monitor (transaction ST03) shows important overall key performance indicators (KPIs) for the system performance
The OS Monitor (transaction ST06) gives you an overview on the current CPU, memory, I/O and network load on an application server instance.
The database monitor (transaction ST04) checks important performance indicators in the database, such as database size, database buffer quality and database indices.
The SQL trace (transaction ST05) records all activities on the database and enables you to check long runtimes on a DB table or several similar accesses to the same data.
The ABAP runtime analysis (transaction SE30)
The Cache Monitor (accessible with transaction RSRCACHE or from RSRT) shows among other things the cache size and the currently cached queries. The Export/Import Shared buffer determines the cache size; it should be at least 40MB.
FAQ SAP BI/BW
1. Where do we used number range buffering? Codes SE27 and SNRO
2. what are the different cases in which update rules can be copied?
3. what are the different types of queries?
4. what is query view and query definition?
5. what is query template?
6. what is the difference between drill down and slice n dice?
7. what is result set query and infoset query?
8. what are jump queries?
9. what is drill up and drill across and how is drill across done?
10. what is an infoset and what the difference to it in BI 7?
11. what are the three scenarios for ods reporting?
12. what is an info catalog?
13. what are free characteristics and filters?
14. what are the difference between restricted key figures and filters?
15. what is the use of formula in BW?
16. what are advance query techniques in BW?
17. what is exception reporting?
18. what is reporting agent?
19. what is a variable and different types of variables and what is the use of variables?
20. at what times will currencies be translated?
21. what is the use of user exists?
22. what is query management?
23. what are the techniques to improve query performance?
24. what is query monitor? Is it useful for aggregates, if so how?
25. what are the query modes available in BW?
26. what is an aggregate and what is the use of it?
27. how are aggregated updated and when is it recommended to use aggregates?
28. what are the conditions and factors to be taken into account while creating aggregates?
29. what are the different strategies for creating an aggregate?
30. how aggregates can be optimized?
31. what is a profile generator and what is the use of it?
32. what is the difference between authorization and authorization objects?
33. what is Bex map?
34. what is web reporting and what are the benefits of using it?
35. what are the differences of bex and web reporting?
36. what is bex web application designer?
37. what type of servers are required to allow web reporting in SAP BW?
38. what is web reporting template?
39. what does data changes aggregates update program do?
40. what is the aim of aggregates and in what case can you not create aggregates?
41. where can data be filtered in SAP BW?
42. What are the variables used in Bex reporting?
43. What are the different Processing Types?
44. What is the replacing path Process Type? What is the input for Replacing path process type?
45. How do you create a Generic data source?
46. What are the function modules?
47. Types of Deltas?
48. what are the Generic delta types?
49. Explain V3 Update?
50. What is Cell definition?
51. How do you Transport objects from Development to Quality? IMP
52. What is Navigation Attribute? What are the tables will create while creating Navigational attribute?
53. What are the tables for Master data in BW?
54. What are the tables will create while creating Info Object?
55. What are the tables will create while creating Info Cube?
56. Explain your Landscape? Examples?
57. Explain Implementation Methodologies?
58. ABAP reports?
59. What are the tables for SD in R/3?
60. how many Process Chains you are used?
61. What are the issues Faced while loading data?
62. What are the custom cubes you used?
63. How many users your company have?
64. What are the queries you have created?
65. What are the characteristics, key figures involved in query?
66. On what basis you assign Characteristics to Dimensions?
67. What is Plan data and where it will sit?
68.HOw to creat a report on one column where we stored both sales Report ?
69.How to strat & STOP PROCESS CHAIN
70: LOWER CASE & UPPER CASE ?
71: WHY WE GO FOR GENERIC EXTRACTION ? WHICH CASE ? IF THE DATA WILL BE IN 3 TABLES & WE HAVE TO EXRTACT THE DATA FROM TWO FIELDS THEN WHAT TO DO ?
72: ENHNACEMENT CASE WHICH LOGIC APPLY BY YOU ?
73: HOW MANY REPORTS /INFOCUBE /INFOSOURSE / DSO CREATED BY YOU ?
74: BASED OPEN 2LIS_11_VAHDR WHAT ARE THE REPORT U ARE CREATED ?
75: WHY WE GO FOR CEREATING INDEX ? HOW TO KNOW THAT IT’S THE TIME TO CREAT THE INDEX ? why index not other Compress/ ?
76: HOW TO ROLE AUTHORIZEID SAP BI ?
77:WHAT IS EARLY INITIALZE DELTA ?
78: Wht is best for reporting Infocube or Dso ? why ?
79: How many tables are in dso ? standard dso / direct dso / write optimized dso ?
80: Selective Deletion /Repair full request / Repet delta /Reverse Posting /?
81: if the data is loaded in sapbw /sap bi & i want to serach the pericular year data ? where to search ?
82 : Data is loading from sap bi/bw if in extraction stage it fails / How to rectify ? whr to searchh ?
No comments:
Post a Comment