OBIEE Left Outer Join Puzzle Solved.

Recently i was facing an issue with my report where the measures are doubled, where as i dont have any dubes in the Fact table, issue was because of the left outer join that i had as it was throwing null values the entire row is repeated twice as a result because of my aggregation defined on measure.

Sol 1:
whenever you group a colum with left outer always write a ifnull(expr, 'NA') so that distinct is counted and you wont be facing any issues.

Sol 2:
In other ways try to fig it out if you can avoid left outer by implementing a look-up on the fact.

1 comment:

  1. Thank you very much for your good information.
    As I noted in the ... given information is very usefull to every student who ever want to learn about
    best obiee Online Training