Metric Outer Join

[sanjaydhol]

Hi ,
I have a requirement of putting multiple metric in a single report. I have created different metric using some different filters. Now the filter condition is such that some of the metric may not have a single row in it. Now when I try to include all these metric and define outer join on these metric I have not getting any report output. Though some of the metrics should return records. I will appreciate any help on this. I am using Access data base for my metadata as well as my DW. Thanks Sanjay

 

[Z3]

I am not sure Access support outer joins. But I think MS SQL engine some how using table inserts to workaround it to complete half outer joins, but not full outer joins. The key thing is, MS uses the exact opposite concept from the database outer join - I am not sure why, but say metric A you need for sure, metric B is optional, you need to set metric A as OUTER JOIN metric, while B as default. This would produce a left outer join. If you still have difficulty, get out of Access and use some real database like MySQL or something.