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
- 2577 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 |
How online/offline mode impact development and delpoyment?
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 star schema and snowflake schema?
How to enable drills in a given column data?
How do you bring/relate the aggregate tables into the Siebel analytics Logical layer?
Can you use physical join in BMM layer?
can you change the location of the obiee repository?
If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
We have 4 dimension tables, in that 2 tables need to have hierarchies then in such a case is it mandatory to create hierarchies for all the dimension tables?
What are the different types of variables in obiee 11g? Explain
What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
Do you know about Initialization Blocks? Can you give me an example where you used them?
Teradata 
