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 4523
What are the challenges you faced while making of reports?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What is a bridge table ?
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?
What are the different log files in obiee?
How to startup obiee in linux?
How will you port changes for dashboards,reports,rpd from development to production?
What are the different types of variables in obiee? Explain
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 enable or disable caching in the system level and table level?
From where u get the logical query of your request?
How will you go about adding additional column to the repository in the presentation layer?
What is a table alias in obiee? And where and how will you create it.
How to hide certain columns from a user?
Explain the architecture of obiee and what each components do?