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 |
What is a table alias in obiee 11g? Where and how will you create it?
What are the major challenges you faced while creating the rpd?
How will change port of obiee answers?
How to startup obiee in linux?
What is aggregate navigation? How do you configure the Aggregate tables in OBIEE?
How online/offline mode impact development and delpoyment?
What is clusterservices in obiee ? Why its used?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
Have you created hierarchy in obiee. If so where and how?
You worked on standalone or integrated system?
How do you split a table in the rpd given the condition. ( the condition given was Broker and customer in the same table) Split Broker and customer.
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?