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
- 2484 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 aggregate navigation? How do you configure the Aggregate tables in OBIEE?
How will you go about adding additional column to the repository in the presentation layer?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
What is a table alias in obiee? And where and how will you create it.
If you want to create new logical column where will you create (in repository or dashboard) why?
How to startup obiee in linux?
What is the difference between Data Level Security and Object Level Security?
Suppose I have report which is running for about 3 minutes typically. What is the first step you take to improve the performance of the query?
What is clusterservices in obiee ? Why its used?
From where u get the logical query of your request?
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
Why do we have multiple LTS in BMM layer? What is the purpose?
Teradata 
