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
What you will do when your report is not fetching right data?
What are the different types of variables in obiee 11g? Explain
How will you do sort in reports in obiee.
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How will you enable or disable caching in the system level and table level?
can you change the location of the obiee repository?
How will you create interactive dashboards ?
What is a table alias in obiee 11g? Where and how will you create it?
What is star schema and snowflake schema?
Explain the architecture of obiee and what each components do?
How analytics process your request when you create your requests?
You come morning to the office. And all the users are complaining about the obiee reporting system is very slow(dasboards). What is your approach to resolve the issue?
How to startup obiee in linux?
How the users created differs from rpd/answers/dashboards level?
How online/offline mode impact development and delpoyment?