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
can you change the location of the obiee repository?
What you will do when your report is not fetching right data?
How many bi services node can be clustered together?
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 will you create report from two subject areas
What are the major challenges you faced while creating the rpd?
How will you create interactive dashboards ?
How we are going to decide which schema we are going to implement in the data warehouse?
What are the key configuration files in obiee?
Explain the architecture of obiee and what each components do?
What is scd type 1 and 2.
How will you do different types of narrative reports in obiee?
What is a table alias in obiee 11g? Where and how will you create it?
What is a table alias in obiee? And where and how will you create it.
what is guided navigation?