If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
1 3564
What is a table alias in obiee? And where and how will you create it.
What is time series wizard? When and how do you use it?
How will you go about adding additional column to the repository in the presentation layer?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
How we are going to decide which schema we are going to implement in the data warehouse?
Have you created hierarchy in obiee. If so where and how?
What is a bridge table ?
How will you do different types of narrative reports in obiee?
How will change port of obiee answers?
What is a table alias in obiee 11g? Where and how will you create it?
What is star schema and snowflake schema?
What are global filter and how they differ from column filter?
How will you create interactive dashboards ?
Can you run multiple rpd’s in a single obiee instance?
What is scd type 1 and 2.