Interview Questions.

Question 1. What Is Business Intelligence?

Answer :

Business Intelligence is a technology used for making ready the reports for multidimensional analyses.

Question 2. What Is Supervisor?

Answer :

Supervisor is the product is used to installation and maintain a relaxed surroundings for Business Objects products.

OLAP Interview Questions
Question 3. What Are The Various Business Objects Products?

Answer :

User Module
Designer
Supervisor
Auditor
Set Analyzer
Info View (Web Intelligence)
Business Objects Software Development Kit (SDK)
Broadcast Agent and so on.
Question 4. What Are The Different Multidimensional Analysis Methods Available In Business Objects?

Answer :

There are 2 Multidimensional analysis methods to be had in BO, they're:

Slice and Dice.
Drill Down.
OLAP Tutorial
Question five. What Is Slice And Dice?

Answer :

Slice and dice mode permits you to exchange the placement of facts in a document (for example, move statistics from columns to rows).

Data Warehousing Interview Questions
Question 6. What Are The Advantages Of Business Objects Over Other Dss?

Answer :

User Friendly
Familiar Business Terms
Graphical Interface
Drag and Drop
Powerful reports in much less time
Enterprise huge Deployment of documents the use of WebI
Customized dashboards the use of Application foundation and Business Objects SDK
Question 7. What Are The Different Schemas Supported By Bo Designer?

Answer :

Star Schema
Snowflake Schema
Multistar Schema
Normalized production Schema
Data warehouse with aggregates
Data Warehousing Tutorial SAP BW Interview Questions
Question eight. What Are All The Data Providers Supported By Bo?

Answer :

Queries on Universe
Stored procedure
Free hand SQL
Text files or Spread sheets
VBA Procedures
OLAP servers
SAP
Question 9. What Is A Hierarchy?

Answer :

A hierarchy is an ordered series of associated dimensions grouped collectively to carry out multidimensional hierarchy.
The relationship among object inside the hierarchy is one – to – many.
Business Ethics Interview Questions
Question 10. What Are The Types Of Hierarchy?

Answer :

There are  varieties of hierarchies:

Default hierarchy: It carries the dimension gadgets within the order wherein they may be supplied within the elegance.
Custom hierarchy: A custom hierarchy is made from default hierarchy.
SAP BW Tutorial
Question 11. How Do You Create A Universe, Step-via-step Approach?

Answer :

Designing, Creating and preserving a universe The phased in this consist of:

Planning: Break down the information machine into functional regions.
Analysis: Analyze the facts needs of users
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 different universes
Maintenance: Update and preserve the universe
Notify quit users of adjustments.
Business Development Interview Questions
Question 12. What Is Scope Of Analysis?

Answer :

"Scope of analysis" manner a subset of information, lower back with the aid of a query that you'll use for evaluation for your report.
The information in your scope of evaluation does now not seem within the document until you make a decision that you need to apply it in analysis.
OLAP Interview Questions
Question 13. What Is Join?Unique Types Of Joins?

Answer :

Join is the relation that takes place among the two tables that enables to combine into one desk.
The purpose of be part of is that to restrict the Cartesian product.
The join is particular in the Where clause of the sq. Statement.
The distinct styles of joins are:

Equi be part of - is based at the equality between the values in the column. Because the identical column is found in both tables, the be a part of synchronizes the 2 tables.
Outer be a part of - An outer be a part of hyperlinks two tables, one in every of which has rows that do not healthy the ones inside the not unusual column of the other table.
Theta be part of - A theta be a part of links tables primarily based on a relationship apart from equality between  columns.
Shortcut be a part of - Shortcut joins may be used in schemas containing redundant join paths leading to the same end result, no matter path.
Business Ethics Tutorial
Question 14. What Is A Data Provider?

Answer :

The data supply (Query) is called as the facts provider.

Question 15. Did You Do Metadata Reporting In Bo?

Answer :

Metadata reporting of BO is feasible. BO affords a separate universe which definitely carries repository tables, objects etc.Using this Universe you can still do metadata reporting in BO.

DWBI Interview Questions
Question 16. What Are The Ways By Which U Can Distribute The Universe?

Answer :

There are  ways to distribute a universe:

thru the repository 
via the file device.
Question 17. What Are The Main Components Of The Designer Interface?

Answer :

The fundamental components that have interaction in 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 structure of the universe.
The Universe pane - The Universe pane refers the components in which it's miles going to apply in BO or WEBI documents.
Business management Interview Questions
Question 18. What Are New In Bo five.1?

Answer :

Save enterprise objects documents in Adobe Portable Document Format (PDF)
Add hyperlinks to reports including mail addresses and net site addresses.
These links are maintained when you store the document in HTML or PDF.
Zero Administration – Only the enterprise objects client software mounted on the windows laptop; all middleware is saved and administered at the internet intelligence net server and the server side processing is dealt with by the internet intelligence device.
Data Warehousing Interview Questions
Question 19. What Is The Repository?

Answer :

The repository is the database wherein the information approximately the customers and facts is gift. It is created and maintained by means of the overall supervisor. It is used to proportion sources of enterprise gadgets.
It accommodates of three domain names:

Universe domain – It holds all of the exported universes and there can be a couple of universe area within the repository.
Document domain – It holds all exported files, templates, scripts, and lists of values.
Security domain - secured connections are saved in this.
Question 20. What Are The Tasks Of The Universe Designer?

Answer :

The responsibilities that universe clothier has: 

Designing, Creating and retaining the Universe. 
Distributing the Created Universes.
Oracle BPM Interview Questions
Question 21. What Is The Difference Between Built-in-techniques And External Strategies?

Answer :

Built-In-Strategies:

Extracting the joins with tables
Detect cardinalities in joins
Create default classes and items from the tables
Objects - In this we will set how the gadgets to be displayed in the universe pane
Joins - In this we will set how the joins among the tables must be retrieved like matching column names or matching names and so on.
Tables - In this it'll reads the table structure from the database.
The other techniques:

Setting the number of rows to be retrieved - default a hundred
The range of row retrieved from database
The execution time of the question primarily based on the number of mins specified.
The maximum length of the lengthy textual content gadgets.
External Strategies: External strategies are declared in STG segment of .PRM report. We can create the outside approach the usage of both square or flat file.

Question 22. What Is Strategy?

Answer :

The strategy is the script that robotically extracts the structural records from the database or flat record.

Built-in-techniques
External strategies
Question 23. Where Will You Find The Address Of Repository In Bo?

Answer :

BO Main.Key, File that carries the cope with of the repository's protection area.

Business Coordinator Interview Questions
Question 24. What Is The Channel?

Answer :

A channel is a Web web site that uses "push" technology, also known as Webcasting, to hold subscribers abreast of updated information.

Each BUSINESSOBJECTS channel is related to a BROADCAST AGENT, itself related to a user group in the Business Objects repository. One BROADCAST AGENT could have numerous channels.

SAP BW Interview Questions
Question 25. How Do You Define Universe Parameters?

Answer :

The first step in growing a universe is to specify its parameters.

These parameters encompass the definition of a universe, which is created from the universe name, a description of the universe, a connection to an RDBMS. You enter universe parameters from the Universe Parameters conversation container.

This dialog field additionally helps you to set up database options, external techniques, image options, and print settings.

Question 26. What Do You Mean By Object Qualification?

Answer :

The qualification of an object well-knownshows how it could be used in multidimensional evaluation.
An item can be certified as a dimension, a detail, or a measure.
In the Universe pane, the image beside every object suggests its qualification.
Oracle BI Publisher Interview Questions
Question 27. What Is Alert Message?

Answer :

An alert is a message which is displayed before viewing the records data.

Business Ethics Interview Questions
Question 28. What Is Drill Up/down/by/thru?

Answer :

Drill mode permits you to investigate statistics from one-of-a-kind angles and on special tiers of element.
Drill down displays next stage of detail in hierarchy.
Drill up goes lower back up via the hierarchy to show information on less targeted levels.
By the use of Drill by using choice you could circulate to every other hierarchy to research other records that belongs to a distinctive hierarchy.
Drill Through if the bottom stage of detail you need isn't currently to be had inside the report, you could drill via to the database directly from drill mode and get the statistics you need. You do not have to edit the query in the Query Panel.
Question 29. What Are The Formats Supported For Business Objects Documents?

Answer :

You can view Business Objects files in the following codecs:

HTML
PDF
Enhanced Document Format
Business Objects Format
Sap Business One Interview Questions
Question 30. What Is Join?

Answer :

A Join is a dating that explains how the information in one table pertains to statistics in every other desk.

Question 31. What Are Linked Universes?

Answer :

If the records provided is from two specific statistics providers then we are able to hyperlink the ones  universes, such type of universe is called Linked Universe.

Question 32. What Is Business Intelligence 80 / 20 Concept?

Answer :

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

Question 33. How Can You Check The Universe?

Answer :

Using check Integrity, u can check the universe.

Go to Designer, Tools -> check Integrity

Business Development Interview Questions
Question 34. Can We Have A Report With Multiple Data Sources?

Answer :

Yes.

Question 35. How Do You Design A Universe?

Answer :

The layout approach includes two principal stages:

During the primary phase, you create the underlying database shape of your universe. This shape consists of the tables and columns of a database and the joins by way of which they're connected. You may need to solve loops which arise inside the joins the usage of aliases or contexts. You can conclude this segment via checking out the integrity of the overall structure.
During the second one segment, you may proceed to beautify the additives of your universe. You can also prepare sure items for multidimensional evaluation. As with the primary segment, you have to test the integrity of your universe structure. Finally, you could distribute your universes to users via exporting them to the repository or thru your file gadget.
Question 36. What Are Different Types Of Parsing?

Answer :

There are two forms of parsing:

Quick parsing
Through parsingents
DWBI Interview Questions
Question 37. What Is A Prompt?

Answer :

A Prompt is an give up customers object, which lets in the customers to go into the value or choose the values to restriction the facts in the file.

Question 38. What Are The Features In Bca?

Answer :

Automated report scheduling and publishing.
On the server aspect, CORBA-enabled features inclusive of load balancing and server optimization the usage of caches.
Tracing BROADCAST AGENT interest
Question 39. What Are The Roles Of Bo Administrator?

Answer :

The following are the obligation assigned to administrator:

Installations and configurations in a distributed surroundings .
Creating the BO Enterprise Repository.
Performing returned up and restoration of Metadata.
Tuning the servers.
Deployment of news.
Question 40. What Are The Resources That Are Managed By Supervisor?

Answer :

Business items merchandise
Universes
Documents
Repository domains
Stored Procedure
Business management Interview Questions
Question 41. What Is A Report Bursting?

Answer :

Report bursting lets in you to hold the version documents based at the consumer profiles.

Question forty two. What Is The Technique Used In The Bca?

Answer :

BROADCAST AGENT is a set of server additives that may be deployed over a allotted CORBA community.
The distributed architecture allows scalability, load balancing and failover.
Oracle BPM Interview Questions
Question 43. What Is Olap Interface?

Answer :

A top OLAP interface writes an green SQL and reads an aqua rate facts from database.
To layout the interface and architect having accurate expertise on database below standing the record requirements.
Question forty four. What Is An Application Developer Or Report Developer?

Answer :

Design the Reports in line with the document requirement templates.
Testing the every report with following varieties of tests:

Unit Testing
System Testing
Performance Testing
User Acceptance Test (UAT)
Question 45. What Are The Types Of Filters Which Affects The Report?

Answer :

There are  types of clear out:

A global filter affects the entire record.
A blockspecific filter out most effective filters statistics for the specified chart, table or crosstab.
Question forty six. What Are Cardinalities?

Answer :

Cardinality expresses the minimum and most number of times of an entity B that can be associated with an instance of an entity A. The minimum and the most wide variety of instances can be identical to 0, 1, or N.

Because a join represents a bi-directional dating, it ought to always have two cardinalities.

There are two most important strategies for detecting or modifying cardinalities:

The Detect Cardinalities command
The Edit Join conversation box
Question forty seven. What Is Bca?

Answer :

BCA is a software program product for the customers of WEBI and BO to method and distribute files mechanically at the scheduled dates and time.

Question 48. What Are The Types Of Objects?

Answer :

The following forms of items can be created within the universe:

Dimension
Measure
Detail
Question 49. What Is Designer?

Answer :

Designer is a Business Objects IS module utilized by universe designers to create and maintain universes.
Universes are the semantic layer that isolates quit customers from the technical troubles of the database shape.
Universe designers can distribute universes to cease-customers by means of moving them as files thru the report device, or by means of exporting them to the repository.
Question 50. What Is Business Objects?

Answer :

Business Objects is a Dynamic Business intelligence reporting answer from Business Objects.
BUSINESS OBJECTS is an included question, reporting and evaluation solution for commercial enterprise professionals that permit them to get entry to the statistics of their corporate databases at once from their computing device and present and examine this information in a BUSINESS OBJECTS document.
It is an OLAP device that high-stage management can use as part of a Decision Support Systems (DSS).
BUSINESS OBJECTS makes it clean to get entry to the records, because you work with it in commercial enterprise phrases that are familiar to you, no longer technical database terms like SQL.
Question 51. What Are The Types Of Query Filter That You Use In Web Intelligence?

Answer :

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

Predefined Filters
Single and Multi – value Filters
Prompted Filters
Complex Filters
Question 52. What Functions Are Supported?

Answer :

Designer provides four styles of functions:

Number
Character
Date and
@Functions.
Functions beginning with the @ man or woman are BusinessObject functions that render the definition of items dynamic and database–impartial.

Question 53. What Is Data Mining?

Answer :

Data Mining is the analysis of statistics and use of software program techniques for extracting hidden, comprehensible, and useful records from databases.

Question 54. What Are The Data Mining Technologies?

Answer :

Statistics
Cluster Analysis
Neural Network
Data visualization
Decision Trees
Question 55. What Are The Activities In Data Mining?

Answer :

Modeling the relationships among items in the data mining to discover and use the ones relationships.