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 |
Do you know about Initialization Blocks? Can you give me an example where you used them?
What is authentication? How many types of authentication.
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
What are the different log files in obiee?
Define pipeline. Did you use it in your projects?
How do you work in a multi user environment? What are the steps?
What are the challenges you faced while making of reports?
How will you create report from two subject areas
What are different types of variables?
How to enable drills in a given column data?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
What is connection pool and how many connection pools did you have in your last project?