Outer Join

[138006]

Hi
I have a fact say F1.
Now there are 2 filters fl1 and fl2 on the same attribute but differenty hardcodings (e.g. fl1 maybe a1=1 and fl2 is a1=2)

I have 2 metrics M1 and M2. Both are made on F1 with fl1 and fl2 as the Conditions respectively.

As obvious when I drag both M1 and M2 in a report MSTR generates 2 SQLs in 2 passes and finally equi-joins these in a third pass.

But I need to see rows for both conditions. How to get an outer join feature on the third SQL ?

Any help?
thanks

 

[entaroadun]

On both metrics, set the join type to Outer. Each metric has an join setting within it. Dig around.

In general, all metrics with filters on them should be set to Outer.