If you have 3 facts and 4 dimension and you need to join would you recommend joining fact with fact? If no than what is the option? Why you won’t join fact to fact?
Answer Posted / madhu
Instead of joining fact with fact we can create one logical table (fact) and add the 3 fact tables as logical table source in the BMM layer.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How will you do sort in reports in obiee.
What is authentication? How many types of authentication.
What is level based metrics.how will you create it?
How will you create interactive dashboards ?
How to enable drills in a given column data?
How will you port changes for dashboards,reports,rpd from development to production?
What are the challenges you faced while making of reports?
Explain the architecture of obiee and what each components do?
What are the different types of variables in obiee? Explain
What is a table alias in obiee 11g? Where and how will you create it?
can you change the location of the obiee repository?
What is time series wizard? When and how do you use it?
What are the different types of variables in obiee 11g? Explain
How analytics process your request when you create your requests?
How online/offline mode impact development and delpoyment?