SAP Business Objects Designer Interview Questions and Answers

What is Designer?

The Universe designer uses DESIGNER to design, create and maintain universes for a particular group of users. A universe designer can distribute a universe as a file through the file system, or by exporting it to a repository.

DESIGNER is a Business Objects product intended specifically for you the Universe designer.

It is important to analyze the type of information that the end users at your site will require so that you can develop universes that meet the needs of the user community. This includes the actual reports, information, or results likely to be required by the end users.

FAQ about SAP BI4 WebIntelligence on HANA

What is SAP HANA?

SAP HANA is a super-fast in-memory database enabling new possibilities in terms of analytical reporting and real-time data acquisition and consumption.

Is SAP HANA really real-time?

The term “Real-time” can be ambiguous. Let’s say SAP HANA can be super-fast, depending on which context.

Analytical reporting: HANA is designed for on-line analysis. It can calculate and execute millions of data at sub-second speed. Of course it will depend on other factors like creating an optimal HANA model (Analytical Views) and the type of queries you’re sending to HANA. Also bear in mind that HANA will execute queries very quickly but it does not have the control over the amount of data it is fetching (see question on Bad Design).

Data acquisition: HANA is shipped with ETL and replication tools that can load data from operational systems to HANA in a matter of seconds.

Data consumption: HANA solves the issue of having to maintain aggregate tables for performance (data is fresh and live, no need to wait for the next ETL batch).

Stages in BW project

1 Project Preparation / Requirement Gathering
2 Business Blueprint
3 Realization
4 Final Preparation
5 GO Live & Support

1. Project Preparation / Requirement Gathering

Collect requirement thru interviews with Business teams /Core users / Information Leaders .

Study & analyze KPI 's (key figures) of Business process .

Identify the measurement criteria's (Characteristics).

Understand the Drill down requirements if any.

Understand the Business process data flow if any .

Identify the needs for data staging layers in BW – (i.e need for ODS if any)

Understand the system landscape .

Prepare Final Requirements Documents in the form of Functional Specifications containing :
Report Owners,
Data flow ,
KPI’s ,
measurement criteria’s,
Report format along with drilldown requirements .

BW Interview Q&A

1.   What are the extractor types?
• Application Specific
o BW Content FI, HR, CO, SAP CRM, LO Cockpit
o Customer-Generated Extractors
LIS, FI-SL, CO-PA
• Cross Application (Generic Extractors) 
o DB View, InfoSet, Function Module 

2. What are the steps involved in LO Extraction?
• The steps are:
o RSA5 Select the DataSources
o LBWE Maintain DataSources and Activate Extract Structures
o LBWG Delete Setup Tables
o 0LI*BW Setup tables 
o RSA3 Check extraction and the data in Setup tables
o LBWQ Check the extraction queue
o LBWF Log for LO Extract Structures
o RSA7 BW Delta Queue Monitor

3. How to create a connection with LIS InfoStructures? 
• LBW0 Connecting LIS InfoStructures to BW

Oracle Real time questions

1)      How can you see the Current SCN number of the database?

Select current_scn from v$database;

2)      How can you see the Current log sequence number the logwriter is writing in to?

Select * from v$log;

3)      If you are given a database, how will you know how many datafiles each tablespace contain?

Select distinct tablespace_name,file_name from dba_data_files;

4). How will you know which temporaray tablepsace is allocated to which user?

Select temporary_tablespace from dba_users where username=’SCOTT’;

5) If you are given a database,how will you know whether it is locally managed or      dictionary managed?

Select extent_management from dba_tablespaces where tablespace_name=’USERS’;

java interview questions for experienced

Why we preferred event-delegation model over earlier event-inheritance model?

The event-delegation model has two advantages over the event-inheritance model.

• Event-delegation helps in event handling by objects other than those who generate the events.
• Help in differentiating between component design and its use.
• Event-delegation performs much better in applications where generation of events takes place.
• Event-delegation model does not repeatedly process unhandled events, which cause improvement in the performance.

How is Java source code files named?

Java source code file takes the name of a public class or interface that is defined by the programmer while coding within the file. Source code file may contain maximum one public class or interface in the file. Two cases me occur while naming of the java source code file:

• When public class or interface is defined within a source code file then the java source code file must take the name of the public class or interface defined while coding.
• When no public class or interface is defined inside a source code file, then the java source code file take a name that is different than its classes and interfaces. Source code files use the .java extension.

java interview questions for freshers

What is Polymorphism?

The Polymorphism can be referred as one name many forms. It is the ability of methods to behave differently, depending upon the object who is calling it. The key features of Polymorphism are:

• Allows using one interface for multiple implementations.
• Supports Method Overloading: Multiple methods with same name, but different formal argument.
• Supports Method Overridden: Multiple methods have the same name, same return type, and same formal argument list.

Explain garbage collection.

The Java uses the garbage collection to free the memory. By cleaning those objects that is no longer reference by any of the program. Step involve in cleaning up the garbage collection:

• Garbage Object Collection: first step is to collection and group all those object which are no more reference with any of the program. We can use the different methods to collect the garbage object like using runtime.gc() or system.gc().
• Run Finalize method: To free up those object which is collected by the garbage collector java must execute the Finalize method to delete all those dynamically created object

What is an immutable object?

An immutable object is one that we cannot change once it is created. Steps involved in creation of an immutable object are:

• Make all of its data fields private.
• Methods which can perform changes in any of the data fields after the construction of object must be avoided.

How are this() and super() used with constructors?

this() Constructors: is used to pointing the current class instance.

• Can be used with variables or methods.
• Used to call constructer of same class.
• Private variable cannot be accessed using this().

super() Constructer: is used to call constructor of parent class.

• Must be the first statement in the body of constructor.
• Using this we can access private variables in the super class.