Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
1 3033We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
1 2439How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
1 2610How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
1 3551What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
1 2562
Have you created hierarchy in obiee. If so where and how?
How online/offline mode impact development and delpoyment?
How the users created differs from rpd/answers/dashboards level?
How will you go about adding additional column to the repository in the presentation layer?
What are the different log files in obiee?
What you will do when your report is not fetching right data?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What are the different types of variables in obiee? Explain
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 is scd type 1 and 2.
What is star schema and snowflake schema?
What is level based metrics.how will you create it?
How to startup obiee in linux?
How analytics process your request when you create your requests?
What are the different types of variables in obiee 11g? Explain