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 2345We 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 1759How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
1 1954How 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 2892What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
1 1954
What is a table alias in obiee? And where and how will you create it.
How will you create interactive dashboards ?
What is write-back in obiee ?
What is a table alias in obiee 11g? Where and how will you create it?
How will you create report from two subject areas
What are the different types of variables in obiee 11g? Explain
What are the different types of variables in obiee? Explain
How to hide certain columns from a user?
What is a bridge table ?
What is time series wizard? When and how do you use it?
How will you port changes for dashboards,reports,rpd from development to production?
How will you do different types of narrative reports in obiee?
what is guided navigation?
Explain the architecture of obiee and what each components do?
How will you go about adding additional column to the repository in the presentation layer?