Home > SAP BI, WeBi > Partial Results when running Webi-report

Partial Results when running Webi-report

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

Advertisements
  1. May 24, 2015 at 12:54 pm

    Perfect Solution with detailed explanation. I faced similar problem and resolved it in the same way. Good job guys keep it up… 🙂

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: