How do you know which report is hitting which table, either the fact table or the aggregate table?



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

Post New Answer

More OBIEE Interview Questions

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 Answers  


What are different types of joins that are possible in obiee rpd?

0 Answers  


What is the difference between Data Level Security and Object Level Security?

1 Answers  


What is a bridge table ?

0 Answers  


What are the different log files in obiee?

0 Answers  






What are the different types of variables in obiee 11g? Explain

0 Answers  


What is a table alias in obiee 11g? Where and how will you create it?

0 Answers  


How will you do different types of narrative reports in obiee?

0 Answers  


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.

1 Answers  


What is the purpose of Alias Tables?

1 Answers  


What is the end to end life cycle of OBIEE?

1 Answers  


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?

1 Answers  


Categories