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 2288If you want to create new logical column where will you create (in repository or dashboard) why?
1 1818If you want to limit the users by the certain region to access only certain data, what would you do?
1 2154If there are 100 users accessing data, and you want to know the logging details of all the users, where can you find that?
1 2259What is the difference between Single Logical Table Source and Multiple Logical Table Sources?
1 4379How do you know which report is hitting which table, either the fact table or the aggregate table?
1 1928
How will you port changes for dashboards,reports,rpd from development to production?
How the users created differs from rpd/answers/dashboards level?
How will you do sort in reports in obiee.
Can you run multiple rpd’s in a single obiee instance?
What is scd type 1 and 2.
Explain the architecture of obiee and what each components do?
What are global filter and how they differ from column filter?
How we are going to decide which schema we are going to implement in the data warehouse?
What are the different types of variables in obiee? Explain
What is time series wizard? When and how do you use it?
How will you create interactive dashboards ?
How will you go about adding additional column to the repository in the presentation layer?
How analytics process your request when you create your requests?
can you change the location of the obiee repository?
What is star schema and snowflake schema?