How do you know which report is hitting which table, either the fact table or the aggregate table?
Answer / madhu
After running the report, go to “Administration” tab and go to click on “Manage Sessions”. There you can find the queries that are run and in the “View Log” option in the Session Management you can find which report is hitting which table.
Is This Answer Correct ? | 2 Yes | 0 No |
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?
What are different types of joins that are possible in obiee rpd?
What is the difference between Data Level Security and Object Level Security?
What is a bridge table ?
What are the different log files in obiee?
What are the different types of variables in obiee 11g? Explain
What is a table alias in obiee 11g? Where and how will you create it?
How will you do different types of narrative reports in obiee?
How 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.
What is the purpose of Alias Tables?
What is the end to end life cycle of OBIEE?
If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?