Interview Questions.

Q1. What Is The Channel?

A channel is a Web web page that makes use of "push" era, also known as Webcasting, to preserve subscribers abreast of up to date facts.

Each BUSINESSOBJECTS channel is associated with a BROADCAST AGENT, itself related to a person organization in the Business Objects repository. One BROADCAST AGENT can have numerous channels.

Q2. What Is A Prompt?

A Prompt is an end customers item, which allows the users to go into the fee or pick the values to restrict the information in the report.

Q3. What Is Designer?

Designer is a Business Objects IS module used by universe designers to create and maintain universes.

Universes are the semantic layer that isolates give up customers from the technical troubles of the database structure.

Universe designers can distribute universes to cease-users through shifting them as documents via the report device, or by exporting them to the repository.

Q4. Where Will You Find The Address Of Repository In Bo?

BO Main.Key, File that incorporates the deal with of the repository's safety area.

Q5. What Are The Various Business Objects Products?

User Module

Designer

Supervisor

Auditor

Set Analyzer

Info View (Web Intelligence)

Business Objects Software Development Kit (SDK)

Broadcast Agent etc.

Q6. What Is Business Intelligence 80 / 20 Concept?

In a commercial enterprise Intelligence surroundings 80% of improvement time is allotted to OLAP interface designing, 20% of time allocated to Report development.

Q7. What Is Data Mining?

Data Mining is the analysis of records and use of software strategies for extracting hidden, comprehensible, and beneficial records from databases.

Q8. What Is The Technique Used In The Bca?

BROADCAST AGENT is a collection of server additives that may be deployed over a allotted CORBA community.

The disbursed structure allows scalability, load balancing and failover.

Q9. What Is Business Intelligence?

Business Intelligence is a era used for getting ready the reports for multidimensional analyses.

Q10. What Are The Different Multidimensional Analysis Methods Available In Business Objects?

There are 2 Multidimensional analysis techniques available in BO, they are:

Slice and Dice.

Drill Down.

Q11. What Is Drill Up/down/by/through?

Drill mode permits you to analyze facts from exceptional angles and on exclusive ranges of detail.

Drill down displays subsequent stage of detail in hierarchy.

Drill up goes lower back up via the hierarchy to show statistics on less targeted degrees.

By using Drill by using choice you may flow to some other hierarchy to investigate different statistics that belongs to a distinctive hierarchy.

Drill Through if the lowest degree of element you want isn't presently available inside the document, you can drill via to the database directly from drill mode and get the information you want. You do not must edit the query in the Query Panel.

Q12. What Is Join?Exceptional Types Of Joins?

Join is the relation that takes place between the two tables that enables to mix into one desk.

The cause of be part of is that to restriction the Cartesian product.

The join is specified within the Where clause of the sq. Declaration.

The extraordinary forms of joins are:

Equi be part of - is based totally on the equality between the values inside the column. Because the equal column is present in each tables, the join synchronizes the two tables.

Outer be a part of - An outer join hyperlinks  tables, one among which has rows that don't match those in the common column of the other desk.

Theta join - A theta join links tables based on a relationship aside from equality among two columns.

Shortcut be part of - Shortcut joins may be utilized in schemas containing redundant be a part of paths main to the identical result, irrespective of route.

Q13. What Is Slice And Dice?

Slice and cube mode allows you to interchange the position of facts in a report (for instance, move facts from columns to rows).

Q14. What Do You Mean By Object Qualification?

The qualification of an object famous how it may be used in multidimensional evaluation.

An item can be qualified as a dimension, a element, or a measure.

In the Universe pane, the symbol beside every item indicates its qualification.

Q15. What Are The Tasks Of The Universe Designer?

The obligations that universe clothier has: 

Designing, Creating and maintaining the Universe. 

Distributing the Created Universes.

Q16. Did You Do Metadata Reporting In Bo?

Metadata reporting of BO is feasible. BO affords a separate universe which sincerely consists of repository tables, gadgets etc.Using this Universe one could do metadata reporting in BO.

Q17. What Is Olap Interface?

A exact OLAP interface writes an efficient SQL and reads an aqua rate facts from database.

To design the interface and architect having good information on database below status the record necessities.

Q18. What Are The Roles Of Bo Administrator?

The following are the responsibility assigned to administrator:

Installations and configurations in a disbursed surroundings .

Creating the BO Enterprise Repository.

Performing returned up and recuperation of Metadata.

Tuning the servers.

Deployment of reports.

Q19. What Are Different Types Of Parsing?

There are two types of parsing:

Quick parsing

Through parsingents

Q20. What Is A Data Provider?

The information source (Query) is referred to as because the records company.

Q21. What Are The Types Of Filters Which Affects The Report?

There are two kinds of filter out:

A worldwide filter influences the entire document.

A blockspecific filter out only filters statistics for the required chart, table or crosstab.

Q22. What Are The Activities In Data Mining?

Modeling the relationships among items in the statistics mining to discover and use those relationships.

Q23. What Are The Data Mining Technologies?

Statistics

Cluster Analysis

Neural Network

Data visualization

Decision Trees

Q24. What Are The Formats Supported For Business Objects Documents?

You can view Business Objects documents in the following formats:

HTML

PDF

Enhanced Document Format

Business Objects Format

Q25. What Is An Application Developer Or Report Developer?

Design the Reports in line with the record requirement templates.

Testing the each document with following styles of tests:

Unit Testing

System Testing

Performance Testing

User Acceptance Test (UAT)

Q26. What Are The Advantages Of Business Objects Over Other Dss?

User Friendly

Familiar Business Terms

Graphical Interface

Drag and Drop

Powerful reports in less time

Enterprise extensive Deployment of files the use of WebI

Customized dashboards using Application foundation and Business Objects SDK

Q27. What Are The Types Of Query Filter That You Use In Web Intelligence?

There are 4 forms of Query Filter you operate in Web intelligence:

Predefined Filters

Single and Multi – price Filters

Prompted Filters

Complex Filters

Q28. What Functions Are Supported?

Designer offers four forms of capabilities:

Number

Character

Date and

@Functions.

Functions beginning with the @ man or woman are BusinessObject features that render the definition of items dynamic and database–unbiased.

Q29. What Is Join?

A Join is a courting that explains how the facts in a single table pertains to records in any other desk.

Q30. What Are Cardinalities?

Cardinality expresses the minimal and maximum range of instances of an entity B that may be associated with an instance of an entity A. The minimal and the most quantity of times may be equal to 0, 1, or N.

Because a be a part of represents a bi-directional relationship, it need to usually have  cardinalities.

There are  fundamental techniques for detecting or editing cardinalities:

The Detect Cardinalities command

The Edit Join conversation field

Q31. How Can You Check The Universe?

Using take a look at Integrity, u can take a look at the universe.

Go to Designer, Tools -> take a look at Integrity

Q32. What Is The Difference Between Built-in-techniques And External Strategies?

Built-In-Strategies:

Extracting the joins with tables

Detect cardinalities in joins

Create default training and items from the tables

Objects - In this we will set how the items to be displayed inside the universe pane

Joins - In this we can set how the joins between the tables must be retrieved like matching column names or matching names and so on.

Tables - In this it's going to reads the table structure from the database.

The other techniques:

Setting the wide variety of rows to be retrieved - default a hundred

The quantity of row retrieved from database

The execution time of the query primarily based at the variety of minutes particular.

The maximum size of the long text objects.

External Strategies: External techniques are declared in STG phase of .PRM report. We can create the external approach using both sq. Or flat record.

Q33. What Are New In Bo 5.1?

Save enterprise gadgets documents in Adobe Portable Document Format (PDF)

Add hyperlinks to reviews together with mail addresses and net web page addresses.

These hyperlinks are maintained when you store the file in HTML or PDF.

Zero Administration – Only the business items client software program established on the home windows pc; all middleware is stored and administered at the net intelligence net server and the server aspect processing is handled by way of the net intelligence system.

Q34. What Is The Repository?

The repository is the database wherein the facts about the customers and information is gift. It is created and maintained via the general supervisor. It is used to share resources of commercial enterprise items.

It incorporates of 3 domain names:

Universe domain – It holds all the exported universes and there may be more than one universe area inside the repository.

Document area – It holds all exported documents, templates, scripts, and lists of values.

Security domain - secured connections are saved in this.

Q35. What Are All The Data Providers Supported By Bo?

Queries on Universe

Stored procedure

Free hand SQL

Text documents or Spread sheets

VBA Procedures

OLAP servers

SAP

Q36. What Are The Main Components Of The Designer Interface?

The main additives that interact inside the designing of universe are :

Table browser - The desk browser is used to choose the tables and columns.

The Structure pane - The Structure pane refers the database shape of the universe.

The Universe pane - The Universe pane refers the components in which it's miles going to use in BO or WEBI documents.

Q37. What Are The Different Schemas Supported By Bo Designer?

Star Schema

Snowflake Schema

Multistar Schema

Normalized manufacturing Schema

Data warehouse with aggregates

Q38. What Is Strategy?

The approach is the script that robotically extracts the structural records from the database or flat report.

Built-in-techniques

External techniques

Q39. What Is Supervisor?

Supervisor is the product is used to set up and maintain a cozy environment for Business Objects products.

Q40. What Is A Report Bursting?

Report bursting permits you to preserve the model files based totally at the consumer profiles.

Q41. What Is Bca?

BCA is a software program product for the customers of WEBI and BO to process and distribute documents mechanically on the scheduled dates and time.

Q42. How Do You Create A Universe, Step-by means of-step Approach?

Designing, Creating and maintaining a universe The phased in this include:

Planning: Break down the statistics gadget into practical regions.

Analysis: Analyze the statistics desires of customers

Design: Design a conceptual schema

Design: The specification of a universe

Implementation: Create a universe with DESIGNER

Test the universe with BUSINESSOBJECTS/WEBINTELLIGENCE

Distribute the universe

Repeat the above steps for other universes

Maintenance: Update and keep the universe

Notify stop users of adjustments.

Q43. What Are The Ways By Which U Can Distribute The Universe?

There are two approaches to distribute a universe:

thru the repository 

thru the file system.

Q44. What Is Scope Of Analysis?

"Scope of evaluation" me a subset of records, lower back by means of a question that you'll use for evaluation for your report.

The information to your scope of evaluation does no longer appear inside the record until you make a decision which you want to use it in analysis.

Q45. What Are Linked Universes?

If the information provided is from  one of a kind information companies then we are able to link the ones  universes, such sort of universe is referred to as Linked Universe.

Q46. What Are The Types Of Hierarchy?

There are two forms of hierarchies:

Default hierarchy: It contains the measurement objects inside the order wherein they're provided within the magnificence.

Custom hierarchy: A custom hierarchy is made out of default hierarchy.

Q47. What Are The Features In Bca?

Automated report scheduling and publishing.

On the server aspect, CORBA-enabled capabilities which includes load balancing and server optimization the use of caches.

Tracing BROADCAST AGENT activity

Q48. What Is A Hierarchy?

A hierarchy is an ordered collection of associated dimensions grouped collectively to perform multidimensional hierarchy.

The dating between object in the hierarchy is one – to – many.

Q49. Can We Have A Report With Multiple Data Sources?

Yes.

Q50. How Do You Design A Universe?

The layout method includes two essential phases:

During the primary segment, you create the underlying database structure of your universe. This structure includes the tables and columns of a database and the joins with the aid of which they may be related. You might also want to solve loops which arise within the joins the usage of aliases or contexts. You can conclude this section by means of testing the integrity of the general structure.

During the second one phase, you could proceed to enhance the components of your universe. You also can put together certain objects for multidimensional evaluation. As with the first segment, you need to test the integrity of your universe structure. Finally, you can distribute your universes to customers with the aid of exporting them to the repository or thru your report device.