If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
1 2981If you want to create new logical column where will you create (in repository or dashboard) why?
1 2541If you want to limit the users by the certain region to access only certain data, what would you do?
1 2792If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
1 2903What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
1 5289How do you know which report is hitting which table, either the fact table or the aggregate table?
1 2643
What are the major challenges you faced while creating the rpd?
How will you execute direct sql in obiee?
How will you enable or disable caching in the system level and table level?
What is a bridge table ?
How online/offline mode impact development and delpoyment?
What is a table alias in obiee 11g? Where and how will you create it?
How to get sql from obiee for reports?
What are different types of joins that are possible in obiee rpd?
How will you create interactive dashboards ?
Have you created hierarchy in obiee. If so where and how?
What is a table alias in obiee? And where and how will you create it.
Explain the architecture of obiee and what each components do?
What is level based metrics.how will you create it?
can you change the location of the obiee repository?
How will you create report from two subject areas