Series: Subject: Topic:

Business Intelligence Interview Questions

Showing Questions 1 - 20 of 47 Questions
First | Prev | | Next | Last Page
Sort by: 

Aggregations for a system

Asked By: sakthistm | Asked On: Oct 23rd, 2014

What is the max possible number of aggregations for a system with 2 dimensional and 3 levels? ( in business objects & data warehousing)

What is business intelligence?

Asked By: Interview Candidate | Asked On: Aug 31st, 2005

Answered by: Poonam Makhija on: Sep 26th, 2014

Taking raw data and convert into information in readable format which helps to take tactical decision

Answered by: veera.:) on: Jun 14th, 2013

Bi is an approach for gathering diff data sources on integrating into Big data sources on generating reports, simplifying decision making.

What is a universe?

Asked By: Interview Candidate | Asked On: Jul 5th, 2005

Answered by: Rebecca on: Jan 20th, 2014

An answer to explain to end users: What is a universeť? A universe is a business-oriented mapping of a set of Epic Clarity or other data that is focused on a specific content area or user need. A u...

Answered by: maheswarrlasekharr on: Apr 10th, 2013

Middle layer of the data base table to Reporting tool

What is flat aggregation

Asked By: hanumanthu | Asked On: Mar 26th, 2007

Answered by: kishore on: Nov 25th, 2013

If we create an aggregate on a dimension which has less than or equal to 16 characteristics, then it is act as a line item dimension, This type of aggregates are called flat aggregates. my personal re...

Answered by: JAGADISH RAJU on: Sep 14th, 2011

If you create an Aggregate with more than 16 characteristics, then we call that aggregate as FLAT Aggregate. When an aggregate is active then new data is not available for reporting,These aggregates are called Flat Aggregates.

SAP bi/bo consultant

Asked By: soujanyal | Asked On: May 26th, 2013

Hi, this is srinivasa rao,pls help me I am having 3.5 years of experience as SAP bi/bo consultant ,i completed my bsc in 2009 how to tell about my self pls help me thanks in advance

What is olap?

Asked By: Interview Candidate | Asked On: May 22nd, 2005

Answer posted by vikas r on 2005-05-22 02:57:09: olap stands for online analytical processing. It is used for anaytical reporting

Answered by: maheswarrlasekharr on: Apr 10th, 2013

Olap stands for Online Analytical Processing.
Every day we load OLTP to OLAP for Data analysis.
Then generate reports base this reports end-user take decisions.

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

OLAP is used to extract data from multiple sources. All extraction is done online by making use of ETL

Name some of the standard business intelligence tools in the market?

Asked By: Interview Candidate | Asked On: Aug 4th, 2005

Answered by: maheswarrlasekharr on: Apr 10th, 2013

BO, Crystalreports, Xcelsius

Answered by: sudhaprakash on: Jul 6th, 2010

Micro StartegyMicrosoft OLAPQlik viewInformaticaBOSASCrystal ReportXcelsius

What is the main use of business content? How data can be loaded into business content after installation?

Asked By: swamy | Asked On: Dec 5th, 2006

Answered by: maheswarrlasekharr on: Apr 10th, 2013

Just install the ready made business objects and activate it, replicate into bw install suitable info source then onwards extract the data from R/3 to bw run info package.

Answered by: Sleekpage on: Dec 20th, 2009

Business content can come from various parts of your business operations. Some from the finance department and some from the sales department.If these business content are consistent and can be used b...

Generic extraction in SAP ecc

Asked By: mahes.raji | Asked On: Oct 20th, 2011

Can you explain the real time scenario in which we use generic extraction in SAP ecc for sd,fi etc

Answered by: maheswarrlasekharr on: Apr 10th, 2013

first we install the bi content data source. if any customization fields, add fields extract structure, Replicate the data source into bw it reads complete metadata of the data source and maintain tim...

Dimensional modelling

Asked By: Tejas_More | Asked On: Jul 3rd, 2008

Explain the design of dimensional model for internet selling

Answered by: Ramanagoud on: Mar 17th, 2013

Dimensional model will be having original tables and will be joined directly to other tables using primary key. As in ER modelling we will not do any normalization here. We don't bother about any memo...

Answered by: BIchick on: Feb 5th, 2010

This is simple layout without stocking/restocking data, also without GL, specials handling, etc...You would have to have these dimensions:Date (including, excluding time - based on how grainual you ne...

Complex join in alias table

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

Why and how do you use complex join in alias table?

Answered by: pnagarjuna.technical on: Oct 3rd, 2012

1) When ever the join between the tables is other than equal operator the join is complex join.
2) If we use AND operator in physical join it refers to complex join.
3) In BMM layer we can change the type of join like inner OR outer, this is also refers to Complex join.

Catalog manager.

Asked By: forumshah | Asked On: Oct 14th, 2010

What is catalog manager? How to move reports and dashboards using catalog manager?

Answered by: pnagarjuna.technical on: Oct 3rd, 2012

Leodin is correct and the catalog manager is that which stores the objects like reports, dashboards, pages, filters.

Answered by: leodingzy on: Jan 13th, 2011

When you migrate reports and dashboards from one environment to another, you can open the catelog side by side. Then select all the reports from the source catelog, right click on it and click on the ...

How do you improve performance in analytics.

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

Answered by: Shirley Reagor on: Jun 17th, 2012

The use of Data Cubes will help performance on queries to an OLAP database. Keeping in mind this will take up additional memory to do.

What are the various modules in business objects product suite?

Asked By: Interview Candidate | Asked On: Jul 5th, 2005

Answered by: giri on: Apr 6th, 2012

2 Types
Web Based: CMC,Infoview,Polestar,CCM
Window Based:UNIV,Webrich,BVM,Zcelsius

Answered by: anasat on: Dec 22nd, 2008

The various modules in BO are .,Desktop Intelligence, Designer module, Import wizard which are in client side. Web Intelligence(Infoview), Central Management Console (CMC), Central Management Server (CMS), Perfomance Management (PM) are in server side. 

What is physical query ?

Asked By: Ramesh babu abburi | Asked On: Oct 4th, 2011

Answered by: Shankar on: Oct 22nd, 2011

The table,column, and key objects provide the metadata necessary for Oracle BI Server to access the actual physical sources with SQL requests.

The actual SQL Query which is passing to DB(Data Warehouse).


Stored procedures and functions

Asked By: sasi | Asked On: Jul 15th, 2011

What is the difference between functions and stored procedures in SQL server? what tool we are using in project management tool for developing packages in ssis? how to rectify the errors in stored procedure in SQL server how many ways are there?

Answered by: Bapineedu Bollempalli on: Sep 21st, 2011

Functions â—¦can be used with Select statement â—¦Not returning output parameter but returns Table variables â—¦You can join UDF â—¦Can not be used to change server configuration â—¦Can not be u...

How do you use a column selector to change the dimensions dynamically

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

Answered by: kiran on: Sep 17th, 2011

Column selector permits users to dynamically change which columns to appear in results.
Try it in the 'views' in presentation services.



Asked By: raakesh1805 | Asked On: Jan 26th, 2008

Explain about t-codes and where can you find the list of t-codesraakesh

Answered by: balaramtripathy on: Nov 16th, 2010

T-Code are Transactional Codes in SAP it will quick navigate to a particular screen.We will find all the T-codes, on the following steps,Got to SE16(t-code)then type TSTC on barthen executive, and ag...

Answered by: suyogpatil09 on: Jan 7th, 2010

T-Code are Transactional Codes in SAP,  it facilitates the quick navigation to a particular screen by entering the T-code for that transaction in the textbox provided on left side top corner.&nbs...

Conditional reports

Asked By: email2sunil23 | Asked On: Jul 23rd, 2008

Can any one explain conditional reports in detail

Answered by: clarkpca on: Jun 14th, 2010

A conditional report is based on the data gathered, then analyzed during the report generation, which reports out results of the analysis in the report's output.

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

In the conditional reports we can make the hardcopy of reports which we want in any angle of database.

How would you handle conditional formats in bi

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

Answered by: idanh79 on: Dec 1st, 2009

You can use calculated members in OLAP cube and change the format accordingly the value of the cell.Idan Halfon 

Answered by: sithu on: Mar 24th, 2007

There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers,

First | Prev | | Next | Last Page





twitter fb Linkedin GPlus RSS


Interview Question

 Ask Interview Question?


Latest Questions

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.