I'm new to OBIEE and the following is a query on 10g.
I use the union reporting using dummy/null fields as the Subject areas are built in a way that they don't include all fields one report would need at my work place.
(Let me know if I could work otherwise)
Suppose I have a, b fields from S1 and c from S2, I implement the following approach:
S1 a b 0
S2 a 0 c
What I expect to see is:
Result a b c
What I see is:
Result a b 0
a 0 c
I see two records with one ID(feild a).
Could anyone help me on this, please?