Real Time Scenarios in OBIEE

 Real Time Scenarios in OBIEE

Real Time Scenarios in OBIEE

I have 2 tables in DataBase table1 and table2

a)Imported together with keys and foreign keys?

bJoins will be automatically established in the physical layer.

b)Imported together only with keys?

Ans:-Keys will remain but joins not

c)Dragged the 2 tables from physical layer to BMM layer(along with Joins),which act like fact table and which act like dimension table?

Ans:-Primary key-----Dimension

          Foreign key-------Fact

d)Same as (c) but without  Joins?

Ans:-Both act like fact tables in BMM layer

You recently changed the columns of your presentation catalog as your manager wants to enforce naming standards for all customer facing applications. What happens to all the dashboard requests written prior to this change?Do they function properly or do they appear broken?”If yes,they will function”,How does they work?”If not,reports appear broken”,what can you do to fix this?Give examples?

Ans:-If alias table is available for presentation table then all the reports work fine.

I have configured the repository(3 layers) and saved.I have generated some reports and saved.If I change the presentation catalog name then it is showing  that you don’t have permissions to access this subject area in answers.How can you fix this?

Ans:-Goto Advanced tab(In answers)àChange the subject area name and set XML it will automatically display the subject area.

For More

Interview Questions on OBIEE
Inteview Questions On OBIEE