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
How the users created differs from rpd/answers/dashboards level?
What are the different types of variables in obiee 11g? Explain
Have you created hierarchy in obiee. If so where and how?
How to startup obiee in linux?
What is authentication? How many types of authentication.
How will you execute direct sql in obiee?
What are the different types of security you have worked in obiee?
what is guided navigation?
Can you run multiple rpd’s in a single obiee instance?
What are different types of joins that are possible in obiee rpd?
What is star schema and snowflake schema?
What is clusterservices in obiee ? Why its used?
How will you go about adding additional column to the repository in the presentation layer?
Explain the architecture of obiee and what each components do?
What is time series wizard? When and how do you use it?