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 |
How will you port changes for dashboards,reports,rpd from development to production?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
How will you go about adding additional column to the repository in the presentation layer?
If you have 2 fact and you want to do report on one with quarter level and the other with month level how do you do that with just one time dimension?
How the users created differs from rpd/answers/dashboards level?
How to sort columns in rpd and web?
Can you run multiple rpd’s in a single obiee instance?
What is a table alias in obiee 11g? Where and how will you create it?
What are the key configuration files in obiee?
What are the major challenges you faced while creating the rpd?
How will you do different types of narrative reports in obiee?
What are different types of variables?