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 2963We 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 2377How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
1 2540How 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 3467What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
1 2499
Have you created hierarchy in obiee. If so where and how?
How will you go about adding additional column to the repository in the presentation layer?
What is time series wizard? When and how do you use it?
How will you create report from two subject areas
From where u get the logical query of your request?
What are the challenges you faced while making of reports?
What is clusterservices in obiee ? Why its used?
How to hide certain columns from a user?
What is level based metrics.how will you create it?
What is a table alias in obiee 11g? Where and how will you create it?
What are the different types of variables in obiee? Explain
What are the different types of variables in obiee 11g? Explain
What is scd type 1 and 2.
What are the major challenges you faced while creating the rpd?
Can you run multiple rpd’s in a single obiee instance?