OBIEE Basic interview Qns stuff

whats OLAP / OLTP?

Whats schema u r using ? how many Facts & Dim tables?

Explain all layers (or tell the process flow in Rpd)

How you join tables in SA ?

What objects available in Physical Layer?

How SA identifies Fact table?

Can u have multiple connection pools?

What is use of BMM layer ?

How to create Dims? What is Preferred Drill path?

How u use Time series Wizard (for calculation wizard ur fact table must contain at least 1 aggregations like sum, u can ask that)? Calculation wizard? Pooling of table

can u add Logical column in BMM ? whats benefit of adding that column in Physical layer.

1-2 questions on Physical layer

Data level security & Report level security

Initialization block , Session, Repository variable. & why they used

repository migration all possible ways. What is use Multi check in – Check out.

NQSConfig.INI & DBFeatures.INI how these files configured? Is there any other way to configure “DBFeatures.INI” file? Also about other config. Files.

Some questions on Cache ?

some questions on various types of reports. Pivot , graph , table .

some basic questions on Dashboard ? pages

Performance improvement at report level & at Repository level.

What are iBots , how they configured , & their use.

how much is size of ur rpd & webcatalog?

General (but important)

how is the deployment process (Dev-QA-prod)

How u support the application

load initial & incremental

how many environment

which quality process, document u follow (if interviewer work in CMM 5 level company he must be aware of those)