Skip to Content
Jul 20, 2018 at 05:17 PM

Why do WebI and Universe generate different scripts for same query?

180 Views Last edit Jul 25, 2018 at 07:16 PM 3 rev

I have one universe based on a single MSSQL data source and I create the same query in IDT and in a WebI report.

However, the resulting SQL script if very different.

In IDT, this is a simple SELECT that represents well what I am trying to achieve while in WebI it's an unappropriate UNION of 4 SELECTs.

Why is that?

Here are the query panels from IDT and WebI:

And here are the resulting queries:


And WebI


webi-query.png (58.5 kB)