Could we use Dynamic SQL to restric row numbers.

[Former Member]

Could we use Dynamic SQL to restric row numbers in Universe Designer?

[Former Member · Accepted solution]

Hi Rachel,

We can restrict rows for a particular user at the database (Oracle) level by adding a policy using Policy Manager. This concept is called Virtual Private Database. In this way we can restrict the rows at the database level using PL/SQL. These restrictions are not applied in Universe Designer and as a result the rows are not restricted for that particular user.

Please correct me if I am on a wrong page.

Regards,

Arun Sasi

[Former Member]

I hope this helps as I'm not sure if it addresses your question exactly.

You can restrict the number of rows if the database vendor provides SQL syntax for limiting rows to a specific count. In this case you could enter this SQL in a derived table. If you wanted to only restrict the row count on a certain set of tables you might consider restricting their total rowcount by enforcing a join to a derived table which applies the appropriate SQL syntax.

Also, in the Universe Parameters dialog on the Controls tab (You can launch this dialog by clicking File | Parameters) you can set the row count by setting the "Limit size of result set to" option.