Archive

Posts Tagged ‘SAP BI 4.0’

Partial Results when running Webi-report

January 9, 2013 1 comment

Hi,

Environment: SAP B I4.0 SP5 p1, Universe Design Tool

Issue: Running a webi-query returns into partial results.

Image

Cause:

By default the “Limit Size of a Query Resultset” is set to 5000 rows.┬áIn case your webi-query returns more than 5000 rows, you do not retrieve the complete resultset.

Solution:

Open IDT and modify the in the “Query Options” the “Query Limits” of your universe business layer.

Image

Also note that you make this “query limit” user of group dependent. This can be done by activating the security editor in IDT (Window/Security Editor), select the universe and insert a new “Data Security Profile”.

Image

Next, modify the size-limit of the resultset in the “Controls”-tab:

Image

Finally, add the necessary users and/or groups to the security profile:

Image

kr,

Hans