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 2916We 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 2315How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
1 2491How 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 3432What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
1 2454
Can you run multiple rpd’s in a single obiee instance?
What are different types of joins that are possible in obiee rpd?
What is a bridge table ?
What is authentication? How many types of authentication.
What is a table alias in obiee? And where and how will you create it.
What are the challenges you faced while making of reports?
Have you created hierarchy in obiee. If so where and how?
What are the major challenges you faced while creating the rpd?
How will you port changes for dashboards,reports,rpd from development to production?
How will you do different types of narrative reports in obiee?
How to startup obiee in linux?
How will you enable or disable caching in the system level and table level?
What are global filter and how they differ from column filter?
How to enable drills in a given column data?
What is a table alias in obiee 11g? Where and how will you create it?