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 2970We 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 2385How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
1 2547How 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 3474What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
1 2507
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?
How will you port changes for dashboards,reports,rpd from development to production?
How to enable drills in a given column data?
How will you do different types of narrative reports in obiee?
What is write-back in obiee ?
How will you enable or disable caching in the system level and table level?
What are the different types of variables in obiee? Explain
How to get sql from obiee for reports?
How analytics process your request when you create your requests?
What are the different types of variables in obiee 11g? Explain
What are different types of joins that are possible in obiee rpd?
What is clusterservices in obiee ? Why its used?
How will you create report from two subject areas
How will you do sort in reports in obiee.
What are the challenges you faced while making of reports?