Issue:
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.
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.
Thank you very much for your good information.
ReplyDeleteAs I noted in the ... given information is very usefull to every student who ever want to learn about
best obiee Online Training .
This post is really nice and informative. The explanation given is really comprehensive and informative.I want to share about obiee tutorial and angular js course
ReplyDelete