These questions are asked
in the interviews of
ORACLE INDIA Hyderabad
GEN PACT Hyderabad
GEN PACTGURGAON (NEW
DELHI)
ACCION LABS (MALAYSIA)
AFUAIT (BANGALORE AND
QATAR)
TCS AHAMADABAD (GUJARAT)
OBIEE Interview Questions And Answers for Experienced
1.what are the tough/hard reports faced by you?
2.what are the responsibilities carried by you?
3.what work you have done in the last week .?
4.What is cross subject area analysis?
5.what is bubble chart or view?(Question on how measures)
6.what is Bursting in BI Publisher?
7.Tell me about yourself.
8.what make you to fit for this job or what do you do if i give you the job.
9.write a sql query using left outer join(8i/9i) and some conditions
10.With want the physical query in the log file starts.
3.what work you have done in the last week .?
4.What is cross subject area analysis?
5.what is bubble chart or view?(Question on how measures)
6.what is Bursting in BI Publisher?
7.Tell me about yourself.
8.what make you to fit for this job or what do you do if i give you the job.
9.write a sql query using left outer join(8i/9i) and some conditions
10.With want the physical query in the log file starts.
11. In one dashboard can
we display objects from two subject areas?
12. While defining a dimension the entry for “No of elements at this level” is for performance not precision, please explain how?
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
13. Why it is not recommended to use physical join in BMM layer?
14. Can you update/change value of session variable in Answers?
15. Using Answers, is it possible to insert/update a column in the source system?
16. How do you get data from 2 dimensions without any measure?
17.Which OBIEE Versions did you worked on in your projects?
18.What are modes of using RPD?
19.What is OCI and ODBC?
20.Difference between OCI and ODBC?
New OBIEE Interview Questions 2016 for experienced
21.how u scale your self in bi admin tool,em,analysis on scale of 5.
22.what versions u worked on obiee and obia
23.My scenario is - if the etl is running for every 4 hours and schmes are changing how u access with obiee or admi tool - what is your solution?
24.how to find the database features supported by your database in OBIEE.
25.what are types of logical dimension hierrarcies
26.what are unskipped and ragged hierarchies.
27.How to create unskipped and ragged hierarchies.
28.Did you created any measure columns?what are they?
29.Did you create any logical dimension hierrarcies?Which one and how?
30In Level Based Measures (LBM) creation,suppose you created time dimension hierarchies and assigned revenue measure at year,quarter,monthly,weekly.
My question i did you create weekly measure,monthly measure...so on or revenue meausre is enough.what will you do?
31.Did you implement data security? How?what is the scenario.
32.can we assign different presentation tables to different users?How?
33.Did you enabled cache is your environment?How?
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
34.Can we enable cache at system level or table level or what levels we can enable?
35.How did you do automate purging of cache?
36.If you about Event Polling Table?Explain?
37.Did you worked on MUDE?
38.In analysis or report output can you format output as first row green,secod row white vice versa...? Can we achieve this?How?
39.In dashboard can we hide certain reports based on a condition?How?
40.In report,can i display a image?How?
41.what is complex requirement or reports you faced?Explain the scenario?
42.Did you do any migration from lower environment to higher?How?
Upcoming Posts!
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....
12. While defining a dimension the entry for “No of elements at this level” is for performance not precision, please explain how?
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
13. Why it is not recommended to use physical join in BMM layer?
14. Can you update/change value of session variable in Answers?
15. Using Answers, is it possible to insert/update a column in the source system?
16. How do you get data from 2 dimensions without any measure?
17.Which OBIEE Versions did you worked on in your projects?
18.What are modes of using RPD?
19.What is OCI and ODBC?
20.Difference between OCI and ODBC?
New OBIEE Interview Questions 2016 for experienced
21.how u scale your self in bi admin tool,em,analysis on scale of 5.
22.what versions u worked on obiee and obia
23.My scenario is - if the etl is running for every 4 hours and schmes are changing how u access with obiee or admi tool - what is your solution?
24.how to find the database features supported by your database in OBIEE.
25.what are types of logical dimension hierrarcies
26.what are unskipped and ragged hierarchies.
27.How to create unskipped and ragged hierarchies.
28.Did you created any measure columns?what are they?
29.Did you create any logical dimension hierrarcies?Which one and how?
30In Level Based Measures (LBM) creation,suppose you created time dimension hierarchies and assigned revenue measure at year,quarter,monthly,weekly.
My question i did you create weekly measure,monthly measure...so on or revenue meausre is enough.what will you do?
31.Did you implement data security? How?what is the scenario.
32.can we assign different presentation tables to different users?How?
33.Did you enabled cache is your environment?How?
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
Click Here to go OBIA 7.9.6.3/7.9.6.4 Implementation and Installation
34.Can we enable cache at system level or table level or what levels we can enable?
35.How did you do automate purging of cache?
36.If you about Event Polling Table?Explain?
37.Did you worked on MUDE?
38.In analysis or report output can you format output as first row green,secod row white vice versa...? Can we achieve this?How?
39.In dashboard can we hide certain reports based on a condition?How?
40.In report,can i display a image?How?
41.what is complex requirement or reports you faced?Explain the scenario?
42.Did you do any migration from lower environment to higher?How?
Upcoming Posts!
OBIEE 100+ Interview Questions
OBIEE 100+ Interview Questions and Answers
OBIEE 100+ Interview Questions for 4 Experienced
OBIEE 11g Interview Questions
OBIEE 11g Interview Questions and Answers
OBIEE 11g Tutorials
OBIEE 11g architecture
OBIEE 11g Installation Steps
OBIEE 11g
and more.....