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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

can you change the location of the obiee repository?

444


How online/offline mode impact development and delpoyment?

475


How to enable drills in a given column data?

495


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

492


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

499






What are global filter and how they differ from column filter?

523


What are the major challenges you faced while creating the rpd?

483


How we are going to decide which schema we are going to implement in the data warehouse?

477


How will you create report from two subject areas

485


how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.

499


What is time series wizard? When and how do you use it?

1248


what is guided navigation?

537


From where u get the logical query of your request?

461


Have you created hierarchy in obiee. If so where and how?

495


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

533