Skip to Content
author's profile photo Former Member
Former Member

MUltiple Query-Full Outer Join

Hi All,

In IDT i created below measures:-

1st level :-I have created four measures namely A,B,C and D with Case statements.

2nd level:- Added this measures A and B to create Measures AB

3rd level:-Added measure AB with C to create measure ABC

4th level:-Added measures ABC with measure D to create measure ABCD

Now in WEBI, i have a dimension Country and when i drag measure AB and ABCD it creates a single query.

But when i drag country, ABCD and then measure AB it creates two query at webi level and creates a FULL outer join between them.

I don't have any data yet in DEV system to check whether the data comes correctly in both the cases, but can i find why the behaviour is like this when i drag fourth level aggregated measures at first?

Any help appreciated!!!


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2016 at 07:07 AM

    Hello Rakshit,

    You need to check the Universe structure for Context may be you have to define the proper context when dealing with multiple measures.

    This is because of the join problem that got created because of your underlying data model and relationships in Universe structure.

    Have a look at the CHapter 4 in below document.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 24, 2016 at 08:28 AM

    check in the where clause in both query you will get the difference there.This happened when conditions are different in measure objects.

    similar like

    You can try with unchecking "Multiple SQL for each measure" option in universe and try.

    Untitled.png (7.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      No there is no where clause in the measure or in the report panel and also the multiple sql option for measure is already unchecked.

      The multiple queries come into picture only when the fourth level aggregate measures is dragged before the initial aggregation measures else the Full outer join query are displayed as single query with the entire sql being exact the same as that of full outer one.

      Message was edited by: Rakshit Shetty

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.