Lumira Desktop and sql-generation when using .unx universe-panel

[Paul1202]

Hi,

I would like to understand how Lumira Desktop generates the sql when creating a data-source through  a .unx-universe ?

I'm asking the question since I noticed the sql generated by Lumira Desktop is different than the one generated by using WEBI (java-panel) on  the same universe.

With the BO-client tools (as formerly DESKI, or the WEBI-RC), we have the .prm files and the .sbo files, which one can adapt if needed.

Is there something similar in Lumira. I searched in the .sapvi folder but I could not find anything.

Eddy

[Henry_Banks · Accepted solution]

Hi

please could you illustrate the example - query panel screenshot for both, and syntax pasted here

it uses part of the webi sdk and a webservice to fetch the metadata and generate the sql

have you noticed a DB vendor specific problem ?  which sql parameter are you trying to force?

Regards

H