1 Reply Latest reply: Mar 23, 2013 2:22 PM by Kasyap RSS

    Union reporting involving null fields.

      Hello ALL;

      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?