LIMIT within universe

[Former Member]

Hi there,

we on on XI 3.1, unix deployment, MySQL database

I wondered if there was a smart way to include the LIMIT syntax in the universe to generate this SQL:

SELECT

tableA.column

FROM

tableA limit 500

I can obviously do custom SQL in webi, but this is for QaaWS where custom SQL is not possible, so the solution needs to be implemented in the universe

regards

James

[Former Member]

I createed a derived table where I was able to enter LIMIT 500 at the end of the SQL

[PPaolo]

Hello

I didn't have the chance to try it so I cannot confirm it will work.

There is a parameter in Universe Designer called "End_SQL".

This parameter will append a string to all queries executed with that universe.

Try setting the End_SQL parameter to " limit 500" and try running a query with QaaWS.

Hope that it helps

PPaolo