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
- 2544 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 is a table alias in obiee 11g? Where and how will you create it?
What are different types of joins that are possible in obiee rpd?
What are the things you can do in the BMM layer?
How will you create interactive dashboards ?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
What are other ways of improving summary query reports other than Aggregate Navigation and Cache Management?
How do you work in a multi user environment? What are the steps?
What is the end to end life cycle of OBIEE?
Can you use physical join in BMM layer?
How we are going to decide which schema we are going to implement in the data warehouse?
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?
Teradata 
