Skip to Content
0
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:

Universe:

And WebI

Attachments

webi-query.png (58.5 kB)