GeekInterview.com
Series: Subject: Topic:

Business Intelligence Interview Questions

Showing Questions 21 - 40 of 45 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

What is your opinions on the hyperion tool as a industry best-in-class bi tool?

Asked By: Sreedhar | Asked On: Oct 23rd, 2007

Answered by: ABHI2411 on: Jan 2nd, 2009

Hyperion has a very wide product range which it offers.The widely accepted and most popular tools which distinguishes it from others like BO and COGNOS are Hyperion Essbase(MDDB),Hyperion Financial Ma...

Business performance management

Asked By: larrytsang616 | Asked On: Dec 3rd, 2008

Explain the advantages of business performance management.

Answered by: ABHI2411 on: Jan 2nd, 2009

BPM is very useful in analyzing the current performance of your business.After analyzing the performance of different operations in your organization you can easily identify the various areas where yo...

How to import universes and user from business object 6.5 to xi r2, it is showing as some ODBC error is there any setting to change?

Asked By: kumargai | Asked On: Jul 24th, 2006

Answered by: anasat on: Dec 22nd, 2008

If we import universes and users from BO 6.5 to XI R2, the universes and the connections are also imported.
If it is showing error in ODBC, It seems to be a connection error.  try to create a new conncetion for the importing universe.

Answered by: sithu on: Jan 10th, 2008

We can import the universe, users and reports by using a import wizard available in BO XI R2 the other way you can restore using BIAR file, just take a back of your BO 6.5 Security, universe and document domain and extract those in BOXI R2



Cheers,

Sithu,

Proclarity and bi tools

Asked By: elegantkvc | Asked On: May 8th, 2008

Is proclarity is the tool most widely used ...Or if whats the most popular tool for business intelligence......How much we can rate for pro clarity out of 10....Any ideas share it mates.Thanks & regards

Answered by: ramandeep singh on: Dec 1st, 2008

BI tools is very much used in data warehouse because with the help of BI tools we can analyse the performance of industries or we can make the history of records within few minutes.

Time series wizard

Asked By: St6x6 | Asked On: Apr 2nd, 2008

If there is a problem with time series wizard, how will you do it manually?

Answered by: ramandeep singh on: Dec 1st, 2008

By using SQL UPDATE Statement
UPDATE columnname SET date=()getdate

What are major d/f's b/w reporting tools(e.G. Crystal report) and olap reporting tools(e.G. Hyeprion,cognos )?

Asked By: Ali Jhon | Asked On: Oct 16th, 2006

Answered by: attiliasp on: Sep 19th, 2008

OLAP reporting (online analytical process) in this reporting can do simple anyalsis of the data in report like graphical and physical processing of  the company.

Reporting tools: In this we can only see the reports  we cannot modify them.

Answered by: Varun on: May 25th, 2007

I guess with Cognos Report Net report bursting is possible ie splitting one report and sending to multiple people, Which I suppose is not possible in other tools.
And the architecture of Reportnet is diff from the rest.

Has hyperion got the ability of doing etl process also? (or) is it only a olap toolhow hyperion differs from other tools?Does molap capability let it lead?

Asked By: murali chowdary | Asked On: Sep 7th, 2006

Answered by: attiliasp on: Sep 19th, 2008

Hyperion essbase internally act as a ETL tool. Hyperion tool is used for OLTP, since it can analyse the history of the bussiness data.

Answered by: sithu on: Nov 18th, 2006

It is an OLAP tool, which gives lot more options in fine tuning your reports,

Cheers,

Sithu, sithusithu@hotmail.com

Hyperion

Asked By: mandapudi | Asked On: Jul 11th, 2008

What is the current best business intelligence tool in the market and for next few years?I want to learn hyperion tell me about that?

Dashboard in the business intelligence

Asked By: rchrdrea | Asked On: Nov 15th, 2007

I would like to know the exact definition of the term dashboard. As of late there has been a great deal of confusion on the overuse of this term in my workspace. I was under the impression that this term referred to analytical graphs that were designed to mimic speedometer displays like a dashboard...

Answered by: sithu on: Jan 10th, 2008

Dashboard is a user interface that organizes and presents information in a way that is easy to read. In regards to Business intelligence dashboard is a reporting tool that consolidates aggregates and ...

Answered by: jd_usnj on: Dec 24th, 2007

I agree with you that it's like a car dashboard you can visualize every thing. but it works diffrent here. In detail we monitor our enterprise business process goals. In technical way KPI and then...

Why we can't create an aggregate on an ods object?

Asked By: VenkateshVandanapu | Asked On: Mar 16th, 2006

Answered by: sithu on: Jan 10th, 2008

ODS Data will be keep on changing...that only we are unable to do



Cheers, Sithu

Answered by: Javid on: May 2nd, 2007

Hi,This is a common question, asked anywhere.While loading into the Datawarehouse we gather data(source) from different source systems and place it in a STAGING area - which is literally called as ODS...

What is meant by ipedo in business intelligence?

Asked By: Ansari | Asked On: Nov 6th, 2007

What is hierarchy relationship in a dimension.Whether it is:1. 1:12. 1:m3. M:m

Asked By: sunil kumar jha | Asked On: Mar 13th, 2006

Answered by: sami on: Oct 14th, 2007

1:1 statrschema relatioship
1:m Parent-child relatioship
n:m sanwflakes relatioship

thanks,

sami

Answered by: sudha on: Jul 28th, 2006

hierarchy relation ship shows the relation between the desired attributes in the table

Explain the role of degenerated dimension in data warehouse?

Asked By: jvenkateshkumar | Asked On: Feb 27th, 2007

Answered by: Thiru on: Oct 4th, 2007

Degenerated dimension keys are keys in the fact table that are not dimension keys (Foreign keys to the Hiearchy/dimension tables) and measurements. Like, Order Number, Invoice Number etc.

Answered by: sithu on: Mar 24th, 2007

A Degenerate dimension is a Dimension which has only a single attribute.This dimension is typically represented as a single field in a fact table.Degenerate Dimensions are the fastest way to group sim...

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?

Asked By: kadilsai | Asked On: Jan 21st, 2006

Answered by: Andy on: Jul 18th, 2007

Hyperion has different modules such as essbase, interactive reporting, financial reporting and production reporting. Each tool has its own functionality. Hyprion interactive reporting and essbase are OLAP tools.

Answered by: Om Prakash Bang on: Sep 21st, 2006

Hyperion ia a Business Intelligence (BI) and Business Performanc Management (BPM ) Tool.  Its a market leader in Financial, Operational and Strategic Planning. It is having applications for Plann...

How do you improve performance in siebel analytics(standalone).

Asked By: gvikranthkumar | Asked On: Mar 8th, 2007

Answered by: adam89parkar on: Jul 12th, 2007

I worked with MNC where i was having standalone, see in Standalone while working on the side of admin you needed to pay attention on data modelling.If you are starting from scrach then give more look ...

What is olAP, molAP, rolAP, dolAP, holap? Examples?

Asked By: Interview Candidate | Asked On: Mar 27th, 2005

Star Read Best Answer

Editorial / Best Answer

Answered by: John

Answered On : Mar 27th, 2005

Cubes in a data warehouse are stored in three different modes. A relational storage model is called Relational Online Analytical Processing mode or ROLAP, while a Multidimensional Online Analytical processing mode is called MOLAP. When dimensions are stored in a combination of the two modes then it is known as Hybrid Online Analytical Processing mode or HOLAP. 
 
MOLAP 
 
This is the traditional mode in OLAP analysis. In MOLAP data is stored in form of multidimensional cubes and not in relational databases. The advantages of this mode is that it provides excellent query performance and the cubes are built for fast data retrieval. All calculations are pre-generated when the cube is created and can be easily applied while querying data. The disadvantages of this model are that it can handle only a limited amount of data. Since all calculations have been pre-built when the cube was created, the cube cannot be derived from a large volume of data. This deficiency can be bypassed by including only summary level calculations while constructing the cube. This model also requires huge additional investment as cube technology is proprietary and the knowledge base may not exist in the organization.  
 
 
ROLAP  
 
The underlying data in this model is stored in relational databases. Since the data is stored in relational databases this model gives the appearance of traditional OLAP’s slicing and dicing functionality. The advantages of this model is it can handle a large amount of data and can leverage all the functionalities of the relational database. The disadvantages are that the performance is slow and each ROLAP report is an SQL query with all the limitations of the genre. It is also limited by SQL functionalities. ROLAP vendors have tried to mitigate this problem by building into the tool out-of-the-box complex functions as well as providing the users with an ability to define their own functions.  
 
 
HOLAP  
 
HOLAP technology tries to combine the strengths of the above two models. For summary type information HOLAP leverages cube technology and for drilling down into details it uses the ROLAP model.  
 
Comparing the use of MOLAP, HOLAP and ROLAP 
 
The type of storage medium impacts on cube processing time, cube storage and cube browsing speed. Some of the factors that affect MOLAP storage are:  
 
Cube browsing is the fastest when using MOLAP. This is so even in cases where no aggregations have been done. The data is stored in a compressed multidimensional format and can be accessed quickly than in the relational database. Browsing is very slow in ROLAP about the same in HOLAP. Processing time is slower in ROLAP, especially at higher levels of aggregation.  
 
MOLAP storage takes up more space than HOLAP as data is copied and at very low levels of aggregation it takes up more room than ROLAP. ROLAP takes almost no storage space as data is not duplicated. However ROALP aggregations take up more space than MOLAP or HOLAP aggregations.  
 
All data is stored in the cube in MOLAP and data can be viewed even when the original data source is not available. In ROLAP data cannot be viewed unless connected to the data source.  
 
MOLAP can handle very limited data only as all data is stored in the cube.

Answered by: SWARNA on: Nov 23rd, 2006

 OLAP(ONLINE ANALYTICAL PROCESSING):It is a set of specifications which allows the client applications in retriving the data from the DataWareHouse for analytical process.There r 4 types of OLAPS...

Answered by: sithusithu on: Jan 10th, 2006

 OLAP – Online analytical Processes MOLAP – Multidimensional Online analytical Processes (Cubes) ROLAP – Relational Online analytical Processes (RDBMS) HOLAP – Combination of MOLAP...

Why an infocube has maximum of 16 dimensions?

Asked By: VenkateshVandanapu | Asked On: Mar 16th, 2006

Answered by: bhanu on: Aug 25th, 2006

As the total charecterstics are 255, out of which 16 charecters are being allowed for foreign keys and 6 charecters are for sap default, for this sake we have only 16 dimention tables, of which 3 are again sap default (unit, time. Datapacket): so finally we have only 13 user dimentions.

Answered by: VenkateshVandanapu on: Mar 16th, 2006

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

Can anyone explain about auditing in bo xi r2?? What is the use of it??

Asked By: kumar | Asked On: Jul 31st, 2006

Answered by: pinki on: Aug 8th, 2006

auditor is used by the business objects administrators to know the complete information of the business intelligence system.

1.it monitors entire BIsystem at a glance.

2.Analyzes usage and change impact

3.optimises the BI deployment

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.