Business Intelligence Interview Questions

Decision making data

BI is refers to computer-based techniques used in identifying extracting and analyzing business data ,such as sales revenue by products and/or departments, or by associated costs and income and also...

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.

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

BO, Crystalreports, Xcelsius

Micro Startegy
Microsoft OLAP
Qlik view
Informatica
BO
SAS
Crystal Report
Xcelsius

Middle layer of the data base table to Reporting tool

Universe is a Semantic Model or you can Layer which helps to connect users to different databases to design module for business requirement. Universe is a methodology to modify the structure of data...

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.

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

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

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

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.

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

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

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.

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

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. 

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

Thanks,
Shankar

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

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

kiran

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.

There is not such term as "flat aggregation". However, there are something called "flat dimension" - dimension that has no hierarchies. I would think that when you aggregate across flat dimension you will be doing flat aggregation?

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

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

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.

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

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

Idan Halfon 

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,
Sithusithusithu@hotmai.com

Yes there is. Let me clarify:-1. An   agent represents one   Company while a Broker represents the Customer and takes the customer details and goes to multiple companies to get the best quote and...

Broker is individual and not a part of any organization/company.
Agent works for a company for eg : LIC agent works for LIC.

Create a Alternate Drill down   like if region is the name of dimension and the hierarchy is RegionCountry          Branch NameBranch Name &...

Its better to use drillacross.