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 Answers
- 2299 Views
- I also Faced
- E-Mail Answers
Answer Posted / madhu
Using level base metrics.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is level based metrics.how will you create it?
From where u get the logical query of your request?
What is scd type 1 and 2.
What is a table alias in obiee 11g? Where and how will you create it?
How will you execute direct sql in obiee?
How will you enable or disable caching in the system level and table level?
What is write-back in obiee ?
What is a bridge table ?
how will you implement security in obiee,so that subjects areas accessed by one group are not accessed by another group.
What is authentication? How many types of authentication.
What are different types of joins that are possible in obiee rpd?
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?
What are the challenges you faced while making of reports?
What you will do when your report is not fetching right data?
How will you create interactive dashboards ?
