Interview Questions.

Question 1. What Is Business Object?

Answer :

A Business Object is an entity inner a commercial enterprise layer in n-tier structure of OOP.
A BO holds a set of instance variables of a category, referred to as attributes and institutions with other commercial enterprise objects.
BO maps gadgets representing commercial enterprise relationships.
BO treats state and behavior as exceptional additives as they talk across numerous layers in multi-layered architecture.
For example:

A “Principal” may be a BO in which its attributes like Id, Name, and Area should hold 1-Many association along with his sub-ordinates.
A area BO that doesn't have conduct is referred as Anemic Domain Model.
Question 2. What Is Bo Main Key?

Answer :

BO Main key carries address of the repository of the domain.

RDBMS Interview Questions
Question three. What Is A Domain And What Are They?

Answer :

Logical grouping of device tables is called Domain.

A simple BO setup comprise 3 simple domain names, specifically Secure, Universe, Document domain names.

Security Domain: User names and passwords are available in security area. 
Universal Domain: It carries the Universe Information in which the universes are exported via customers to the repository.
Document area: It consists of the documents which can be shared with the aid of various customers.
Question 4. What Are Linked Universes?

Answer :

Linked Universes are used to link information provided from  one of a kind facts carriers.

SAP BI Tutorial
Question five. What Are Alerter, Filter, Breaks And Conditions?

Answer :

Alters are used to pay attention to a statistics block.
Filters are used to reap only required information.
Breaks are grouping facts without converting the layout of the records.
Condition is applied to retrieve statistics that meet a few standards.
SAP BI Interview Questions
Question 6. What Is The Drill Up, Drill Down, Drill By, Drill Through?

Answer :

Selection of one hierarchy to every other hierarchy is known as drilling.

Drill Up: One degree closer to up is known as Drill UP.

Ex: Month-Quarter-Year

Drill Down: One degree closer to down is known as Drill Down.

Ex: Year-Quarter-Month

Drill By: Selection of 1 stage at once is known as Drill By.

Drill Through: Drilling of facts from one hierarchy to any other hierarchy is called Drill Through.

Question 7. How To Analyze The Database To Improve The Performance Of Reports?

Answer :

Execute the SQL from SQL Navigator (A reporting device) / Toad after passing all of the required parameters.
Identify the performance of SQL, whether or not it takes less time or greater time than the file. If the time is less than the file time then the problem is with the Universe. Otherwise the problem is with the report.
Execute an ‘give an explanation for plan’ on the SQL. 
Verify if indexes are constructed and used. Verify if combination tables may be utilized.
Use materialized perspectives which allow the pre-execution of complicated joins and shops the data.
Outer joins need to be checked well.
Remove useless outer joins.
Delete pointless or extra filters on the report.
SAP BO Tutorial SAP BO Interview Questions
Question 8. Explain About Sql Queries Execution That Is Activated By Data Provider In Bo?

Answer :

SQL queries are routinely generated at the time of objects are decided on .
Upon going for walks, the query is processed relating a database.
Ex: Local Machine Full Client runs query immediately.

It connects to the appropriate database with the aid of a middleware.
The internet server will system the question, whilst the question is administered using Webi browser.
Question 9. What Is The Difference Between Following?

Answer :

Filters and Condition
Formula and Variable
Filters and Condition:

Filters are designed at Universe Level .
Conditions are defined at Report Level.
Formula and Variable:

A named system is known as variable.
Conversion of method into variables is needed while they're used for extra than once in a record.
SAP BW Interview Questions
Question 10. How Data Is Restricted Based On User Profiles?

Answer :

Data is restricted by implementing Row Level Security in Supervisor.

SAP BW Tutorial
Question eleven. What Are The Functions Business Object Designer?

Answer :

One of the Business Object Components to create Universes.
BO Designer is used for outlining measures / metrics.
Semantic layer among database and business is hooked up by way of BO Designer.
Semantic layers permit operating on reviews.
Data cubes can be created with the aid of hiding the complexity of the Database.
Provides OLAP analysis with reporting.
SAP Crystal Reports Interview Questions
Question 12. What Is Called Strategy?

Answer :

A simple script to extract structural statistics from a database.
A BO Designer gives techniques.
The techniques will.
Extracts join.
Detects cardinalities.
Creates default lessons and gadgets.
Default techniques may be indicated via selecting certain options located inside the ‘Database’ tab of the Options Dialog Box.
RDBMS Interview Questions
Question thirteen. What Are The Steps To Be Taken Care To Improve The Report Performance?

Answer :

The file overall performance can be stepped forward by way of the subsequent steps:

At Designer Level:

Remove needless joins.
Utilize condition as essential as viable, on the database level.
Supply the SQL question within the Query Panel as in keeping with the requirement.
At Reporter Level:

Eliminate the filters as many as feasible.
Reduce the consumer variables.
SAP Crystal Reports Tutorial
Question 14. What Are The Requirements Of Universe?

Answer :

The underneath mentioned are requirements of Universe:

Manually decided on Database Connections.
Classes and Objects to map the facts from tables and columns.
Joins – newly created / extracted automatically.
Setting Cardinalities.
Control – for restricting the dimensions of rows and execution time.
SQL Queries.
Parameters for Joins, clauses like wherein, institution by using.
Question 15. How To Optimize The Design Of Universe?

Answer :

The connection parameters ought to be set based at the underlying database.
Use joins in the Universe structure.
Use less SQL capabilities.
Obtain maximum of the parameters / attributes from the database itself or from ETL.
Remove useless gadgets from Universe earlier than shifting to manufacturing.
Ensure LAWs are ticked only for the gadgets that may be used for reviews.
Ensure the Data prompts are well defined.
Business Objects Web Intelligence XI 3 Interview Questions
Question sixteen. What Are The Bo Security Levels? Compare For Cognos Report Net And Crystal Reports?

Answer :

Windows Authentication.
Securities of RDBMS.
Security at Supervisor stage with the aid of the usage of Username and Password. 
Compare for Cognos Report net and Crystal reports:

Crystal Report is for low and mid range evaluation.
Report net is for high stop analysis.
Signing through internet and growing custom document via net is feasible in Report internet.
SAP Webi Tutorial
Question 17. How To Connect One To One Report?

Answer :

The Open Document feature is used to attach one to at least one document.

The characteristic can be utilized in numerous methods.

In ASP environment:

Universe Level: Create an object the use of Object Format with the aid of permitting HTML alternative
SELECT
Report Level: Use Hyperlink characteristic Hyperlink ("Server: PortNo/wiasp/scripts.........." , "Text Link")
In JSP Environment:

Replace opendocument.Asp with opendocument.Jsp.

Business Objects-Crystal Reports Interview Questions
Question 18. Describe The Functional Differences And Architectural Differences Between Bo And Wi Reports?

Answer :

Functional Differences:

Every PC have to be established with BO customer to construct or get right of entry to the reviews.
Every PC ought to have BOMAIN.Key record that makes use of the BO Client.
Architectural Differences:

BO Client:

BO Client device invokes the BOMAIN.Key file from its local disk drive.
It sends the information to BO Server’s BOMAIN.Key, validates it.
Checks the key in the repository.
Followed by means of repository validation, user can get entry to the BO services.
Webi:

Users log into Webi via Info View.
Web Server’s BOMAIN.Key is checked for privileges of the logged in consumer.
It sends the information to the BO Server’s BOMAIN.Key.
Then the statistics is validated and forwards to Repository.
If valid, then presents the get entry to to the Universe and underlying database.
SAP BI Interview Questions
Question 19. Explain The Process Of Creating Context?

Answer :

Contexts avoid loops in Universe Design:

Select Tools
Detect Loops.
Select the cautioned context candidate.
Click on Context.
The Context maps all the joins wished
Places the selected joins in a Named Context.
Context avoids the conflicts in locating paths.

SAP BW on HANA Tutorial
Question 20. What Are Aggregate Awareness And Index Awareness? Where Are They Used And How Can Be Used?

Answer :

Aggregate Awareness:

Information is continued in database as a precis shape.
The statistics warehouse stores the amount of records each hour / day / week.
Aggregations are used 

To store the gap of storage media.
To improve the performance of BI tool – Queries takes less time to method, therefore customers attain the statistics quick.
Index Awareness:

The ability to take the gain of the indexes of key columns for short information retrieval.
Set up the Index attention in BO Designer by specifying the database number one and overseas key columns.
SQL is generated via the BO Designer, for filtering the most green way, through the usage of Index Awareness.
SAP Webi Interview Questions
Question 21. Explain About Locking Universe?

Answer :

When a Universe is imported, the Universe desires to be locked
Upon clicking on File Import choice, select the Universe to import.
Once the Universe is double clicked, a lock image seems
Then only the Universe can be imported.
While the lock is in function, no person can adjust the universe.
Question 22. What Are Box Ir Tools?

Answer :

Business Objects Designer: Supports to create Universes.

Desktop Intelligence: Allows analyzing information, developing reports, and acting queries to fetch data. Publishing Wizard: Allows adding new documents to BOXIR2 Enterprise.

Business view manager: Tool to construct Business perspectives inclusive of reviews.

SDKs: Used for integrating BO merchandise into other applications.

Question 23. Mention Certain Best Practices For Report Design?

Answer :

General:

Make positive that the file tab names are self explanatory. 
For complicated reports, specify a top level view document tab declaring the rationale of the record.
Data Providers:

Every records provider call have to replicate the use of facts
Choose gadgets in order to reveal SQL in a hierarchical order of tables.
Report Structure:

Use report templates while extra reports need to apply with comparable structures.
Report Formats:

All reviews should have page layouts.
All reports have to have page numbers in the footer a part of the report.
All reports need to have Last Refresh Timestamp either in the header or within the footer.
Business intelligence Interview Questions