Thursday, October 25, 2012

Real Time Scenarios in OBIEE


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

Same as (c) but without  Joins?
Ans:-Both act like fact tables in BMM layer


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?

Go to Advanced tab(In answers) Change the subject area name and set XML it will  automatically  display the subject are

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?

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

No comments:

Post a Comment