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 2316We 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 1734How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
1 1932How 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 2854What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
1 1926
How will you port changes for dashboards,reports,rpd from development to production?
can you change the location of the obiee repository?
What you will do when your report is not fetching right data?
How will you do sort in reports in obiee.
What is a bridge table ?
What is time series wizard? When and how do you use it?
How will change port of obiee answers?
Can you run multiple rpd’s in a single obiee instance?
What are the challenges you faced while making of reports?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
What are global filter and how they differ from column filter?
What are the different types of variables in obiee? Explain
How will you go about adding additional column to the repository in the presentation layer?
How the users created differs from rpd/answers/dashboards level?
What is a table alias in obiee 11g? Where and how will you create it?