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 effect the changes for a report , if for certain users only the column heading in the report should be changed?
What is level based metrics.how will you create it?
What you will do when your report is not fetching right data?
can you change the location of the obiee repository?
What are the different types of security you have worked in obiee?
How will you do sort in reports in obiee.
How will you create report from two subject areas
How will you execute direct sql in obiee?
Can you run multiple rpd’s in a single obiee instance?
How analytics process your request when you create your requests?
What are the different log files in obiee?
What is write-back in obiee ?
How to get sql from obiee for reports?
How will you do different types of narrative reports in obiee?
How many bi services node can be clustered together?