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 will you port changes for dashboards,reports,rpd from development to production?
How we are going to decide which schema we are going to implement in the data warehouse?
What are different types of joins that are possible in obiee rpd?
How to get sql from obiee for reports?
What is star schema and snowflake schema?
Explain the architecture of obiee and what each components do?
What is write-back in obiee ?
can you change the location of the obiee repository?
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 interactive dashboards ?
What are the key configuration files in obiee?
Have you created hierarchy in obiee. If so where and how?
How will you enable or disable caching in the system level and table level?
How analytics process your request when you create your requests?
How will change port of obiee answers?