sap bw bi latest interview questions with answers by garuda trainings
Post on 18-Oct-2014
865 views
DESCRIPTION
SAP BW BI Latest Interview Questions with Answers by Garuda Trainings We, Garuda Trainings are provide SAP BW BI Online Training over globe. For More: http://garudatrainings.com/ Mail: [email protected] Phone: +1(508)841-6144TRANSCRIPT
www.garudatrainings.com
SAP BW BI Interview Questions
1. What is data integrity?
www.garudatrainings.com
Data Integrity is about eliminating duplicate entries in the database. Data
integrity means no duplicate data.
2. What is the difference between SAP BW 3.0B and SAP BW 3.1C, 3.5?
www.garudatrainings.com
The best answer here is Business Content. There is additional Business Content
provided with BW 3.1C that wasn’t found in BW 3.0B. SAP has a pretty decent
reference library on their Web site that documents that additional objects found
with 3.1C.
3. What is index?
www.garudatrainings.com
Indices/Indexes are used to locate needed records in a database table quickly. BW
uses two types of indices, B-tree indices for regular database tables and bitmap
indices for fact tables and aggregate tables.
4. What is KPIs (Key Performance Indicators)?
www.garudatrainings.com
1) Predefined calculations that render summarized and/or aggregated
information, which is useful in making strategic decisions.
(2) Also known as Performance Measure, Performance Metric measures. KPIs
are put in place and visible to an organization to indicate the level of progress
and status of change efforts in an organization.
KPIs are industry-recognized measurements on which to base critical business
decisions.
In SAP BW, Business Content KPIs have been developed based upon input
from customers, partners, and industry experts to ensure that they reflect best
practices.
5. What is the use of process chain?
www.garudatrainings.com
The use of Process Chain is to automate the data load process.
Used to automate all the processes including Data load and all Administrative
Tasks like indices creation deletion, Cube compression etc.
Highly controlled data loading.
6. Difference between Display Attribute and Navigational Attribute?
www.garudatrainings.com
The basic difference between the two is that navigational attributes can be used
to drilldown in a Bex report whereas display attributes cannot be used so. A
navigational attribute would function more or less like a characteristic within a
cube.
To enable these features of a navigational attribute, the attribute needs to be
made navigational in the cube apart from the master data info-object.
The only difference is that navigation attributes can be used for navigation in
queries, like filtering, drill-down etc.
7. If there are duplicate data in Cubes, how would you fix it?
www.garudatrainings.com
Delete the request ID, Fix data in PSA or ODS and re-load again from PSA / ODS.
8. What are the differences between ODS and Info Cube?
www.garudatrainings.com
ODS holds transactional level data. It’s just as a flat table. It’s not based on
multidimensional model. ODS have three tables
1.Active Data table (A table containing the active data)
2.Change log Table (Contains the change history for delta updating from the
ODS Object into other data targets, such as ODS Objects or Info Cubes for
example.)
3.Activation Queue table (For saving ODS data records that are to be
updated but that have not yet been activated. The data is deleted after the
records have been activated)
9. What is the use of change log table?
www.garudatrainings.com
Change log is used for delta updates to the target; it stores all changes per request
and updates the target.
10. What is the T.Code for Data Archival and what is it’s advantage?
www.garudatrainings.com
SARA.
Advantage: To minimize space, Query performance and Load performance
11. What is OSS?
www.garudatrainings.com
OSS is Online support system runs by SAP to support the customers.
You can access this by entering OSS1 transaction or visit
Service.SAP.Com and access it by providing the user name and password.
12. How to unlock objects in Transport Organizer?
www.garudatrainings.com
To unlock a transport use Go to SE03 –> Request Task –> Unlock Objects
Enter your request and select unlock and execute. This will unlock the request.
13. What is InfoPackage Group?
www.garudatrainings.com
An InfoPackage group is a collection of InfoPackages.
14. What are the critical issues you faced and how did you solve it?
www.garudatrainings.com
Find your own answer based on your experience.
15. What is Conversion Routine?
www.garudatrainings.com
a) Conversion Routines are used to convert data types from internal format to
external/display format or vice versa.
b) These are function modules.
c) There are many function modules, they will be of type
CONVERSION_EXIT_XXXX_INPUT,
CONVERSION_EXIT_XXXX_OUTPUT.
example:
CONVERSION_EXIT_ALPHA_INPUT
CONVERSION_EXIT_ALPHA_OUTPUT
16. Difference between Start Routine and Conversion Routine?
www.garudatrainings.com
In the start routine you can modify data packages when data loading. Conversion
routine usually refers to routines bound to InfoObjects (or data elements) for
conversion of internal and display format.
17. What is the use of setup tables in LO extraction?
www.garudatrainings.com
The use of setup table is to store your historical data in them before updating to the
target system. Once you fill up the setup tables with the data, you need not to go to
the application tables again and again which in turn will increase your system
performance.
18. R/3 to ODS delta update is good but ODS to Cube delta is broken. How to fix it?
www.garudatrainings.com
i. Check the Monitor (RSMO) what’s the error explanation. Based on
explanation, we can check the reason
ii. Check the timings of delta load from R3 – ODS – CUBE if conflicting after
ODS load
iii. Check the mapping of Transfer/Update Rules
iv. Fails in RFC connection
v. BW is not set as source system
vi. Dump (for a lot of reasons, full table space, time out, sql errors…)
Do not receive an IDOC correctly.
vii. There is a error load before the last one and so on…
Contact us For More Stuff:
www.garudatrainings.com
www.garudatrainings.com Mail : [email protected],
Phone : +1(508)841-6144