Report brings objects from both sql's

[Former Member]

I have Webi report that has union in it, the issue I am having is my report bring in objects from both the sql's into the report.Eg: Q1-- has A1,B1,C1,D1

and Q2--has A2,B2,C2,D2. The report bring all A1,B1,C1,D1and A2,B2,C2,D2, instead of A1,B1,C1,D1

How would I over come this issue? IS this because of not setting contexts .properly in the universe? Any suggestions will be helpful.

[Former Member]

Hi SS243,

In the Universe connection parameters, under SQL tab, I believe there is an option to allow / disallow UNION queries. Try checking this property to make sure it is enabled.

You might also want to check the property "Multiple SQL statements for each context / measure". Even this might be causing you to get two queries.

Regards,

Srivatsa

Edited by: Srivatsa Kondapalli on Jun 22, 2011 2:32 PM

[Former Member]

Hi,

Can you make your requirement clear.

If you have combined query it means you need to combined the results of both queries into one. If you dont want to combine then take out the 2nd query and make it is as a separate data provider such that you will get results of two queries from separate data provider

Edited by: bolearner on Jun 21, 2011 1:21 PM

[amitrathi239]

Hi,

as i understand your requirement is to pull A1,B1,C1,D1 AND A2,B2,C2,D2 in the single query with union.

You can achieve by like create some dummy objects in the universe with same datatype like A1 datatype is character then dummy object with no value and datatype should be character.

so you query look like this

first query : A1,B1,C1,D1,DUMMY1,DUMMY2,DUMMY3,DUMMY4

second query : DUMMY5,DUMMY6,DUMMY7 DUMMY 8,A2,B2,C2,D2.

Thanks,

Amit