- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Business Intelligence Interview Questions & Answers - Learning Mode

Business Intelligence Interview Questions & Answers - Learning Mode

Business intelligence (BI) is an umbrella term that includes the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance. Business intelligence (BI) is a technology-driven process for analyzing data and presenting actionable information to help corporate executives, business managers and other end users make more informed business decisions.

Try Business Intelligence Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

Business Intelligence Interview Questions & Answers - Learning Mode
Try Business Intelligence Interview Questions & Answers - Exam Mode
Question: What are the various modules in Business Objects product?

Answer: Business Objects Reporter - Reporting & Analyzing tool<br>Designer - Universe creation, database interaction & connectivity<br>Supervisor - For Administrative purposes<br>Webintelligence - Access of report data through internet<br>BroadCast Agent - For scheduling the reports<br>Data Integrator - The ETL tool of Business Objects, designed to handle huge amounts of data<br><br>"Kumar Sparjan" ( ) Source:
Question: How do u determine or evaluate success?
In what ways you think you can contribute to our organisation?
Why should we hire you over the others waiting to be interviewed?

Answer: Success can be evaluated by the leadership qualities i.e.if a person is heading the staff of 10 people then if those 10 people are satisfied with their job & do whatever their leader ask them to do then there will be ultimate success waiting for that department/organization & that is the way that leader can contribute towards the success of the organization. Source:
Question: Define the Non-Voice Accounting Process and Semi-Voice Non-accounting process in BPO?

Answer: No answer available currently.
Question: Why an infocube has maximum of 16 dimensions?

Answer: Because any Database will supports only 16 foreign keys in a database table.

Question: Is the increase in CRR rate a good sign for Indan economy and why?

Answer: No. Hike is CRR (cash reserve ratio) of commercial banks means that, they have to keep more money as reserves. This reduces the amount of money available for credit (reduced liquidity) and naturally interest rates will rise. A rising interest rate means loans are more costly and will affect expansion plans by corporates resulting in lower overall economic growth.

But it is important to note that hike is CRR is generally done to bring down inflation! Source:
Question: What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples?

Answer: OLAP - On-Line Analytical Processing.
Designates a category of applications and technologies that allow the collection, storage, manipulation and reproduction of multidimensional data, with the goal of analysis.

MOLAP - Multidimensional OLAP.
This term designates a cartesian data structure more specifically. In effect, MOLAP contrasts with ROLAP. Inb the former, joins between tables are already suitable, which enhances performances. In the latter, joins are computed during the Source:
Question: Can anyone explain about Auditing in BO XI R2?What is the use of it??

Answer: Auditor is used by the business objects administrators to know the complete information of the business intelligence system. monitors entire BIsystem at a glance.

2.Analyzes usage and change impact

3.optimises the BI deployment
Question: How to connect GDE to Co>Operating system in Abinitio

Answer: U can connect Ab Initio GDE with Co>operating system using Run->Settings.In there u can specify the host ip address and the connection type .Refer Ab Initio help for further details. Source:
Question: What is BAS? What is the function ?

Answer: The Business Application Support (BAS) functional area at SLAC provides administrative computing services to the Business Services Division and Human Resources Department. We are responsible for software development and maintenance of the PeopleSoft?pplications and consultation to customers with their computer-related tasks.

Its called Broadcast Agent Server. Its function is to
run the jobs or reports scheduled and can be monitored
using Broadcast Agent Console.
Question: How open document syntax works?

Answer: No answer available currently.
Question: What are dashboards?

Answer: Dashboard is a user interface that organizes and presents information in a way that is easy to read.Its a reporting tool that consolidates aggregates and arranges measurements metrics. Source:
Question: What is Hyperion? Is it an OLAP tool? what is the difference between OLAP and ETL tools? What is the future for OLAP and ETL market for the next five years?

Answer: - Its an Business Intelligence tools. Like Brio which was an independent product bought over my Hyperion has converted this product name to Hyperion Intelligence.

Is it an OLAP tool?

- Yes. You can analyse data schemas using this tools.

OLAP: Its an online analytical processing tool. There are various products available for data analysis.

ETL: Extract , Transform and Load. This is a product to extract the data from multiple/single source transform the data and load i Source:
Question: What is one major characteristic or skill that you possess which you believe will complement our current management team? Please explain how this characteristic or skill distinguishes you.

Answer: Optimism. Doing all tasks with a confidence and attention assuring the best possible outcome. Source:
Question: What is hierarchy relationship in a dimension.
whether it is:
1. 1:1
2. 1:m
3. m:m

Answer: 1:M Source:
Question: Name some of the standard Business Intelligence tools in the market?

Answer: some of the standard Business Intelligence tools in the market According to there performance
Question: What is a Universe?

Answer: A "universe" is a "Business object" terminology. Business objects also happens to be the name of the company. The universe is the interfacing layer between the client and the datawarehouse . The universe defines the relationship among the various tables in the datawarehouse.


Universe is a semantic layer between the database and the user interface (reports).

A mapping of the data structure found in databases: tables, columns, joins, etc. A universe, made up of classes, obj Source:
Question: Why we can't create an aggregate on an ODS Object?

Answer: 1. Operational Data Store has very low data latency. Data moved to ODS mostly on event based rather than time based ETL to Data Warehouse/Data Mart.

2. ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.

3. Unlike data warehouse where data is HISTORICAL, ODS is near real time(NRT). So data aggregation is less important is ODS as data keeps changing.
Question: How to develop our business category?

Answer: No answer available currently.
Question: How do we Tune the BO Reports for Performance Improvement?

Answer: We can tune the report by using index awarness in universe Source:
Question: How do you define multiple queries in a document?

Answer: In BI,If the Multiple Queries have same or common inputs using RRI we can have multiple Quieres in a single document where all Queries are embedded in a single Document through Web Application Designer Source:

1 2 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.234375 Seconds