Explain the architecture of obiee and what each components do?
How will you create interactive dashboards ?
How to hide certain columns from a user?
What are the major challenges you faced while creating the rpd?
What is a table alias in obiee? And where and how will you create it.
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How to get sql from obiee for reports?
can you change the location of the obiee repository?
What is write-back in obiee ?
What you will do when your report is not fetching right data?
How many bi services node can be clustered together?
What is scd type 1 and 2.
Have you created hierarchy in obiee. If so where and how?
What is star schema and snowflake schema?
How we are going to decide which schema we are going to implement in the data warehouse?