WEBI Generaing a wrong SQL

building reports webintelligence
1

I have validated the SQL of a report using the QUERY TOOL in the Universe and when i view the SQL it is being generated correctly. When i export the Universe to CMS and try to run a report in WEBI the SQL Generated in not correct. It has mutiple AND’s in the Join Condition and in the last filter condition. Which is causing the report to fail. I noticed that the SQL generated on the DESKI is also correct. The problem is just with WEBI

Has anyone noticed such a behaviour. Is it a BUG or what.

Help is appreciated.

Thanks

chili (BOB member since 2007-04-17)

2

DESKI and WEBI will generate the same SQL for the same report if it is using the same universe.

I would check that you are indeed using the same universe.

dessa :madagascar: (BOB member since 2004-01-29)

3

Yes, i am using the same Universe when building a report for WEBI and DESKI

chili (BOB member since 2007-04-17)

4

So, you’ve saved and exported the universe?

You have two reports built; one in Webi and one in Deski?

The two reports have identical objects and conditions and use the same contexts?

dessa :madagascar: (BOB member since 2004-01-29)

5

Yes

chili (BOB member since 2007-04-17)

6

Chili,

if you are using the same universe, then I would check any security build at universe level using manage Access.

Sujit

sujit_patange (BOB member since 2005-07-19)

7

Can you narrow it down to a specific condition or object that distorts the SQL?
i.e take out one condition at atime and check the resulting SQL.

dessa :madagascar: (BOB member since 2004-01-29)

8

Was any solution to this ever found? I’m experiencing the same problem now, in XI r3. Here’s what I have:

Universe:
T2.COL1=T1.COL1

DeskI:
FROM
T1 INNER JOIN T2 ON (T2.COL1=T1.COL1)

WebI:
FROM
T1 INNER JOIN T2 ON (T1.COL1=T2.COL1 AND )

Now, the query contains objects from two tables, and one of the objects forces a join to the same table that the other objects are from. Is this the problem? Should I not force that join?

EdGuru (BOB member since 2007-08-30)