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 4418
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 create interactive dashboards ?
How analytics process your request when you create your requests?
What is a bridge table ?
How will you port changes for dashboards,reports,rpd from development to production?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How will you go about adding additional column to the repository in the presentation layer?
What you will do when your report is not fetching right data?
How will you do sort in reports in obiee.
What is time series wizard? When and how do you use it?
What is star schema and snowflake schema?
What is clusterservices in obiee ? Why its used?
How the users created differs from rpd/answers/dashboards level?
How will change port of obiee answers?
Have you created hierarchy in obiee. If so where and how?