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 4326
can you change the location of the obiee repository?
How many bi services node can be clustered together?
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 will you port changes for dashboards,reports,rpd from development to production?
How will change port of obiee answers?
How will you create interactive dashboards ?
What is a table alias in obiee 11g? Where and how will you create it?
what is guided navigation?
How online/offline mode impact development and delpoyment?
What are the different types of variables in obiee? Explain
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
How will you enable or disable caching in the system level and table level?
How will you create report from two subject areas
How analytics process your request when you create your requests?
What is star schema and snowflake schema?