CoolInterview.com - 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
COOLINTERVIEW.COM BUSINESS INTELLIGENCE INTERVIEW QUESTIONS 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
Subcategories for Business Intelligence Interview Questions & Answers - Learning Mode

Following are sub categories for which Interview Questions & Answers are available under Business Intelligence Interview Questions & Answers - Learning Mode. Please select the appropriate sub-category:-

Investment Interview Questions & Answers (10) Learning Mode | Exam Mode

Operation Management Interview Questions & Answers (10) Learning Mode | Exam Mode

Supervisory Interview Questions & Answers (14) Learning Mode | Exam Mode

1

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 is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Explain with 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 reque Source: CoolInterview.com
Question: What is a Universe in Business Intelligence?

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.

Or

Universe is a semantic layer between the database and the user interface (reports). Source: CoolInterview.com
Question: What is hierarchy relationship in a dimension.
whether it is:
1. 1:1
2. 1:m
3. m:m


Answer: 1:M Source: CoolInterview.com
Question: Why we can not create an aggregate on an ODS Object?

Answer: ► 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.<br><br>► ODS is more closer to OLTP system. We don't normally prefer to store aggregated data in OLTP. So it is with ODS.<br><br>► 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. Source: CoolInterview.com
Question: How do we Tune the BO Reports for Performance Improvement?

Answer: We can tune the report by using index awareness in universe Source: CoolInterview.com
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 Applications and consultation to customers with their computer-related tasks. Source: CoolInterview.com
Question: How do we enhance the functionality of the reports in BO?

Answer: You can format the BO Reports by using various features available. You can turn the table reports into a 2-Dimensional or 3-Dimensional charts. You can apply an Alert to show some data in a different format , based on some business rule. You can also create some prompts, which will asks user to give some input values before seeing the reports, this way they will see only filtered data. There are many similar exciting options available to enhance the reports. Source: CoolInterview.com
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 their performance
► MICROSTRATEGY
► BUSINESS OBJECTS,CRYSTAL REPORTS
► COGNOS REPORT NET
► MS-OLAP SERVICES

Or

► Seagate Crystal report
► SAS
► Business objects
► Microstrategy
► Cognos
► Microsoft OLAP
7. Hyperion
8. Microsoft integrated services Source: CoolInterview.com
Question: 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.

► it monitors entire BIsystem at a glance.

► Analyzes usage and change impact

► optimises the BI deployment Source: CoolInterview.com
Question: Explain the Name of some standard Business Intelligence tools in the market?

Answer: Some of the standard Business Intelligence tools in the market According to there performance

1)MICROSTRATEGY
2)BUSINESS OBJECTS,CRYSTAL REPORTS
3)COGNOS REPORT NET
4)MS-OLAP SERVICES Source: CoolInterview.com
Question: What are dashboards?

Answer: The goal of the dashboard is to automatically show a user useful files and other objects as he goes about his day. While you read email, browsing etc. Source: CoolInterview.com
Question: Why an infocube has maximum of 16 dimensions?

Answer: It depends upon the Database limits provided to define the Foreign key constraint, e.g. in Sql Server 2005, the recommended max limit for foreign keys is 253, but you can define more. Source: CoolInterview.com
Question: i have coloum of id like "abcd-xyz-101-pqrs". i have to split it into 4 parts based on "-". xyz not a constant of 3 characters. some times it may be 4 or 5 charcters. how can i split it.

Answer: No answer available currently.
Question: What is Business Intelligence?

Answer: Business Intelligence is a process for increasing the competitive advantage of a business by intelligent use of available data in decision making.

The five key stages of Business Intelligence:

► Data Sourcing
► Data Analysis
► Situation Awareness
► Risk Assessment
► Decision Support Source: CoolInterview.com
Question: What are the various modules in Business Objects product?

Answer: ► Business Objects Reporter
► Reporting & Analyzing tool
► Designer
► Universe creation
► database interaction
► connectivity

Supervisor - For Administrative purposes
Webintelligence - Access of report data through internet
BroadCast Agent - For scheduling the reports
Data Integrator - The ETL tool of Business Objects, designed to handle huge amounts of data. Source: CoolInterview.com
Question: What are the various modules in Business Objects product Suite?

Answer: Supervisor:
Supervisor is the control center for the administration and security of your entire BusinessObjects deployment.

Designer:
Designer is the tool used to create, manage and distribute universe for BusinessObjects and WebIntelligence Users. A universe is a file that containe connection parameters for one or more database middleware and SQL structure called objects that map to actual SQL structure in the database as columns,tables and database.

BusinessObjects Full cli Source: CoolInterview.com
Question: What is hierarchy relationship in a How to connect GDE to Co Operating system in Abinitio?

Answer: We 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: CoolInterview.com
Question: What is OLAP in Business Intelligence?

Answer: Online Analytical Processing, a category of software tools that provides analysis of data stored in a database. OLAP tools enable users to analyze different dimensions of multidimensional data. For example, it provides time series and trend analysis views. The chief component of OLAP is the OLAP server, which sits between a client and a database management systems (DBMS). The OLAP server understands how data is organized in the database and has special functions analyzing the data.
A good OLA Source: CoolInterview.com

1



India News Network
Latest 20 Questions
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
"Holiday Packages" announced as an advertisement are an example of _________: (a) Offer (b) Counter Offer (c) Invitation to Offer (d) None of the above
A match fixing contract between a player and a broker is a: (a) Valid Contract (b) Unenforceable Contract (c) Void Contract (d) Illegal Contract
When a bookseller sells a book on cash payment then it is called as ___________: (a) Unilateral Contract (b) Bilateral Contract (c) Executed Contract (d) Executory Contract
____________ agreements are created by situation: (a) Written (b) Oral (c) Void (d) Implied
Cache = 0.046875 Seconds