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 |
Why do we have multiple LTS in BMM layer? What is the purpose?
What is the purpose of Alias Tables?
What is write-back in obiee ?
How will you do sort in reports in obiee.
Can you migrate the presentation layer to a different server.
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What is data level security?
How to startup obiee in linux?
How will you create report from two subject areas
How the users created differs from rpd/answers/dashboards level?
What is a table alias in obiee 11g? Where and how will you create it?
How do i disable cache for only 2 particular tables?