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 |
What are the different layers of obiee repository?
Can you run multiple rpd’s in a single obiee instance?
What is authentication? How many types of authentication.
How we are going to decide which schema we are going to implement in the data warehouse?
How many bi services node can be clustered together?
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 to get sql from obiee for reports?
What is the end to end life cycle of OBIEE?
How do you define the relationship between facts and dimensions in BMM layer?
What is the difference between Data Level Security and Object Level Security?
How will you do different types of narrative reports in obiee?
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?