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!!!
Thanks!
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.
http://help.sap.com/businessobject/product_guides/boexir31/en/xi31_designer_en.pdf
Regards
Niraj
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.
Add a comment