Business Intelligence Interview Questions and Answers

1/07/2011 No Comment
Business Intelligence Interview Questions and Answers,Business Intelligence Interview Questions and Data Warehouse Business Intelligence Interview Questions

Explain about Auditing in BO XI R2? What is the use of it?
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

How do we Tune the BO Reports for Performance Improvement?
We can tune the report by using index awareness in universe

Why we ca not create an aggregate on an ODS Object?
► 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.

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

► 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.

What is hierarchy relationship in a dimension.
whether it is:
1. 1:1
2. 1:m
3. m:m


How to connect GDE to Co Operating system in Abinitio?
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.

Explain the Name of some standard Business Intelligence tools in the market?
Some of the standard Business Intelligence tools in the market According to there performance

What are the various modules in Business Objects product Suite?
Supervisor is the control center for the administration and security of your entire BusinessObjects deployment.

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 client Reporting tool:
Helps to create businessobjects reports based on the universe and also from the other data sources.

BusinessObjects Thin client Reporting tool:
Helps to querry and analysis on the universe and also share the report among other users. It doesnt require any software, just need a webbrowser and the system connected to the businessobjetcs server.

Tool is used for monitor and analysis user and system activity.

Application Foundation:
This module covers a set of products which is used for Enterprise Performance Management (EPM). The tools are

► Dashboard manager
► Scorecard
► Performance Management Applications
Related Posts

No comments :


Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer