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?
1 2308If you want to create new logical column where will you create (in repository or dashboard) why?
1 1837If you want to limit the users by the certain region to access only certain data, what would you do?
1 2175If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
1 2282What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
1 4425How do you know which report is hitting which table, either the fact table or the aggregate table?
1 1958
What are the different types of variables in obiee? Explain
What is a bridge table ?
From where u get the logical query of your request?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
How to get sql from obiee for reports?
How will effect the changes for a report , if for certain users only the column heading in the report should be changed?
What are the different log files in obiee?
What are the challenges you faced while making of reports?
What is level based metrics.how will you create it?
How will you execute direct sql in obiee?
What is time series wizard? When and how do you use it?
What are the major challenges you faced while creating the rpd?
What are the key configuration files in obiee?
What is a table alias in obiee 11g? Where and how will you create it?
How we are going to decide which schema we are going to implement in the data warehouse?