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 2878We 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 2285How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
1 2450How 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 3398What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
1 2419
How will you execute direct sql in obiee?
What are the major challenges you faced while creating the rpd?
How to get sql from obiee for reports?
From where u get the logical query of your request?
What are global filter and how they differ from column filter?
can you change the location of the obiee repository?
What are the key configuration files in obiee?
How analytics process your request when you create your requests?
What are the different types of security you have worked in obiee?
What are the different log files in obiee?
How the users created differs from rpd/answers/dashboards level?
How will you go about adding additional column to the repository in the presentation layer?
Explain the architecture of obiee and what each components do?
How to enable drills in a given column data?
How will you do different types of narrative reports in obiee?