Interested to Buy Any Domain ? << Click Here >> for more details...
How do you know which report is hitting which table, either the fact table or the aggregate table?
- 1 Answers
- 2568 Views
- I also Faced
- E-Mail Answers
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 you will do when your report is not fetching right data?
What are the key configuration files in obiee?
What are global filter and how they differ from column filter?
What are different types of joins that are possible in obiee rpd?
What is time series wizard? When and how do you use it?
What is data level security?
Can you migrate the presentation layer to a different server.
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
What is a table alias in obiee 11g? Where and how will you create it?
How do you identify what are the dimension tables and how do you decide them during the Business/Data modeling?
How will you execute direct sql in obiee?
How online/offline mode impact development and delpoyment?
Teradata 
